Laying at half sp

[jayalexander]

I've now got a problem...

Whenever I click on Log current prices, BA stops responding and I need to restart the program, although I can never get any further.

I could do it yesterday, so could it be a bug?

[GaryRussell]

Never heard of that one before. There are many users using triggered betting so if they couldn't get that far there would be many complaints so it's doubtful it's a bug. If it worked yesterday then maybe something is corrupted. Does rebooting solve the problem?

[jayalexander]

You beat me to it! A good old reboot did the job

Didn't get to test the trigger today, so plan to tomorrow.

[jayalexander]

Hello from your most recent paid member!

At £6 a month it's criminal not to pay

I have obtained a slightly easier sheet to work with (for me anyway!) and a good friend (also a paid member here) has since adapted it.

I'm sure he wouldn't mind me emailing it to you if you want it for future reference?

I have also recently bought a copy of Excel VBA Programming for dummies and hope to learn a thing or two in the near future!

Thanks once again and here's to a profitable 2011

[john_boyuk]

Hi Gary I'm currently testing out the theory you describe here and I have pasted the code into the editor as instructed. I have opened an excel spreadsheet and ticked enabled trigger betting and ticked sp fom the additional columns. I Have loaded tomorrow's Fontwell 12.35 race and the fifth horse is the one I want to work with (a French Horse) which is cell 9 so i have copied the 2 sums into Q9 and R9. The E2 cell reads NOT IN PLAY. Would this be correct if I am hoping to match the lay bet in play?

Thanks John

Sorry my brain was not in gear yesterday. My solution would place the lay bet 2 seconds after the scheduled start of the race, not the actual start of the race which it needs to be to get the actual SP.

Instead of using the formula I provided in T1 you will need a small amount of VBA to monitor cell [E2] for "In Play" and then insert the elapsed seconds in cell T1.

1. Press alt-f11 to display the code editor.
2. Double click Sheet1 under VBAProject to the left of the code editor.
3. Paste the following code into the editor.

Code: Select all

Option Explicit

Dim inPlayTime As Date
Dim turnedInPlay As Boolean

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 then
       Application.EnableEvents = False
       If [E2] = "In Play" Then
           If Not turnedInPlay Then
               turnedInPlay = True
               inPlayTime = Now
           End If
           [T1] = DateDiff("s", inPlayTime, Now)
       Else
           turnedInPlay = False
           [T1] = 0
       End If
       Application.EnableEvents = True
    End If
End Sub

4. The trigger should now be =if($T$1>=2,"LAY,"")

Yes, just enter your required stake in column S. I recommend using a small stake at first like £0.10 to test it.

[GaryRussell]

i have copied the 2 sums into Q9 and R9

It's not exactly clear what you mean by this. Q9 should contain the formula =if($T$1>=2,"LAY,"") and R9 should contain =Y9 (assuming the SP is output to column Y). If you have done this then it should work. Also don't forget S9 should contain your required stake.

[john_boyuk]

i have copied the 2 sums into Q9 and R9

It's not exactly clear what you mean by this. Q9 should contain the formula [b=((Y5-1)/2)+1b] and R9 should contain =Y9 (assuming the SP is output to column Y). If you have done this then it should work. Also don't forget S9 should contain your required stake.

Thanks gary.... Q9 contains the formula =if($T$1>=2,"LAY,"") and R9 is currently showing 12.3. Column Y shows an SP for each horse. Not sure if this is right!

[john_boyuk]

i have copied the 2 sums into Q9 and R9

It's not exactly clear what you mean by this. Q9 should contain the formula [b=((Y5-1)/2)+1b] and R9 should contain =Y9 (assuming the SP is output to column Y). If you have done this then it should work. Also don't forget S9 should contain your required stake.

Thanks gary.... Q9 contains the formula =if($T$1>=2,"LAY,"") and R9 is currently showing 12.3. Column Y shows an SP for each horse. Not sure if this is right!

Oh and I've just realised that the 12.3 showing in R9 is also showing in the Y9 cell which is the SP column

[john_boyuk]

i have copied the 2 sums into Q9 and R9

It's not exactly clear what you mean by this. Q9 should contain the formula [b=((Y5-1)/2)+1b] and R9 should contain =Y9 (assuming the SP is output to column Y). If you have done this then it should work. Also don't forget S9 should contain your required stake.

Thanks gary.... Q9 contains the formula =if($T$1>=2,"LAY,"") and R9 is currently showing 12.3. Column Y shows an SP for each horse. Not sure if this is right!

Oh and I've just realised that the 12.3 showing in R9 is also showing in the Y9 cell which is the SP column

Ok I think i've worked out what i'd done wrong! It was originally set to Y5 instead of Y9 meaning it had the same odds in the stake cell (R9) as the SP cell (Y11) R9 is now showing half of the SP in Y9 + 1. I have set the stake at 10p for a test for tomorrow. Will it place the lay bet at double the back bet (20p) which is what I want it to do..

[alrodopial]

Will it place the lay bet at double the back bet (20p) which is what I want it to do..

No, you have to place the back bet manually.
Code and formulas Garry provided will place the lay bet in running.

[john_boyuk]

Will it place the lay bet at double the back bet (20p) which is what I want it to do..

No, you have to place the back bet manually.
Code and formulas Garry provided will place the lay bet in running.

Ahhh... right thanks alrodopia... So can I place a back bet to take the betfair SP the morning of the race then?

[alrodopial]

Ahhh... right thanks alrodopia... So can I place a back bet to take the betfair SP the morning of the race then?

yes you can, use the "BACKSP"

[john_boyuk]

Ahhh... right thanks alrodopia... So can I place a back bet to take the betfair SP the morning of the race then?

yes you can, use the "BACKSP"

Oh well everywhere has fallen victim to the weather today so i'll test out the code and formulas tomorrow if we get any racing on!! Thanks guys...really appreciated

[john_boyuk]

Ahhh... right thanks alrodopia... So can I place a back bet to take the betfair SP the morning of the race then?

yes you can, use the "BACKSP"

Oh well everywhere has fallen victim to the weather today so i'll test out the code and formulas tomorrow if we get any racing on!! Thanks guys...really appreciated

This is not working guys. I tried it in the 12:40 at southwell just now and it placed the sp back at the start of the race at 6.46 on Silk Bounty. The lay bet didn't trigger and it got as low as 2.0 in running. Also the lay odds seem to be more than half by 0.5 ie: back 6.28...lay 3.64 instead of 3.14.

[GaryRussell]

What exactly are you trying to do? Are you trying to back at SP and then lay at half that price?

The easiest thing to do would be to use the trigger BACKSP-P50 which will place a back bet at SP and lay bet at 50% of the matched odds. Also there are two ways of calculating 50% odds. You need to install the latest Beta version, see http://www.gruss-software.co.uk/forum/v ... php?t=5669

Once you have installed the latest Beta version it is important that you tick "Calculate tick % on decimal odds" in general preferences. This will ensure the odds are calculated how you expect. If you use this trigger then you don't need the VBA code to calculate the elapsed time from start of race. You also don't need to output the SP column.