Correct Score Trading

[thunderfoot]

I'm looking at trading, In-Play, on the Correct Score markets, and want to LAY the current score, always starting at 0-0. After a goal is scored I will then LAY that score (1-0 or 0-1) and will carry on doing this up to the 3rd, 4th or 5th Goal being scored (haven't decided yet!!) and will then stop.
I have a trigger at which a stop-loss kicks-in, so for example, if a goal doesn't get scored then I will trade out by placing a BACK bet, thereby limiting my loses.

Questions/Help .....
How will I determine when a Goal has been scored from the Correct Score market (is there a formula)? Does Betfair have anything that can be linked to EXCEL and therefore the worksheet that the Market will be displayed on? How will I determine which is the next current score (1-0 or 0-1)?
There could be 12+ worksheets in operation at the same time, particularly on Saturday games, will worksheet macros cause conflict between each other?
Once a LAY bet has been placed (i.e. at the satrt of the game LAY 0-0), is it possible to set worksheet macros to automatically a) Record the LAY odds at which the LAY bet was placed b) The size of the LAY stake (not liability) c) The time of the Bet d) then clear the Betting/Stake information area so that I can either place another LAY bet when a goal gets scored or place a BACK bet if a goal is not scored, thereby trading out of the relevant market at a limited stop-loss figure.

Hope this makes sense!!! I'm sure it could be done, but am not very good at VB/Macros, so any help greatly appreciated.

[mikedmc]

Hi Thunderfoot,

a) Yes although this information is also available on the MyBets tab.
b) Yes although this information is also available on the MyBets tab.
c) The time of the bet is only recorded on the trigger sheet but you could have this recorded using v.b.a. if you wish I do the same with one or two of my sheets.
d) Yes

Not sure the best way to know the correct score and maybe someone else can help you more but if a goal goes in and it becomes 0-1 then I would assume the 0-0 will shoot up to odds of 1000 along with the 1-0 (and others like 2-0 etc.) and 0-1 will drop so a check for these movements would work. Does the correct score market suspend when there's a goal?

All the best.
Michael.

[thunderfoot]

a) Yes although this information is also available on the MyBets tab.
b) Yes although this information is also available on the MyBets tab.

..... and can it be recorded on the trigger sheet?

Does the correct score market suspend when there's a goal?

I believe it does.

c) The time of the bet is only recorded on the trigger sheet but you could have this recorded using v.b.a. if you wish I do the same with one or two of my sheets.

Got any code you're willing to share??

[yantz]

@thunderfoot
i think the simplest way is to look for odds 1000 on the back1 side. eg. if score is now 1-0, back1 odd 0-0, 0-1, 0-2 and 0-3 will all be 1000.

[robbi100]

Hi, I've some experience of trading correct score in play, as Yantz wrote the score can be exactly determined by the odds, if current score is 0-1, 1-0, 2-0 and 3-0 will jump to 1000, then it can be 1-1 so 0-2 and 0-3 will do the same, and so on. In markets with low liquidity that could not happen but they aren't good for trading anyway. Market is suspended and unmatched bets canceled when a goal is scored but also when a red is shown or a penalty given, it is suspended but not zeroed in other circumstances, so I suggest to wait for the market to adjust before triggering the lay bet since there are uncertainties sometimes.
Don't know if it is a good idea to lay till the 4th or 5th goal, unless you've piled significant winnings on them and their odds are low, the average goal scored per match is about 3 and after all, when the 1st goal is scored and you've laid 0-0 you're already on the right side, personally I switch to another game which have seen no more than 1 goal scored in the 1st half. Also, not always the current score odds shorten, an early 1-0, or 0-1 will see its odds rising to start a new slow descent if nothing happen shortly, anyway the odds movement is in relations with the time left to play. bye.

[mikedmc]

Hi Thunderfoot,

Apologies for the delay in replying, snowed under here!

Code, you're more than welcome although not sure what's helpful.

What I did is have a Select.. Case.... Like below...

Code: Select all

Select Case Workbooks("WORKBOOK").Sheets("SHEET").Range("D12").Value
   
           Case TimeValue("00:15:00") To TimeValue("00:15:05")
             
Workbooks("WORKBOOK").Sheets("SHEET").Range("AE15:AE35).Value = Workbooks("WORKBOOK").Sheets("SHEET").Range("AA15:AA35).Value
             
           Case TimeValue("00:12:30") To TimeValue("00:12:35")
             

End Select

This was used a while back when I was copying and saving data from races at different time intervals. I'm not doing that any more and do something slightly differently as I only need to copy the odd cell but need it to be put into the next available cell in a row. This I do using the following code:

Code: Select all

Workbooks("WORKBOOK").Sheets("SHEET").Range("A500").End(xlUp).Offset(1, 0).Value = betRef1(y)

If you wanted to copy a row to the next available row or column to column I'm not sure of the top of my head but I am sure someone else in here will know.

Hope that helps.

All the best.
Michael.

[warriorfullights]

Ever since Betfair started and until today, odds changes weird every once in a while. Sometimes, I tried betting on odds that seems like winning, then all of a sudden, it changes tremendously and made me lost.

I would say luck is the only key to win.

[six gun]

When a goal is score the backing odds of the previous score will often go to 1000 however having bet on correct score many times I can tell you that is by no means always correct.

I am looking at two games right. They are big games and this is correct in this case.
On lesser games this is often not the case.