Help with placing SP bets

[Jailbreak Heart]

Hi, as someone finding my way around the system, please can I have some help with this requirement.

Basically - I want to trigger an SP bet from Excel with the minimum price based on the price 5 minutes before the off.

How would I do that? For the sake of simplicity lets say the required minimum price would be the Offer price at that time. The only restriction would be that the offer price at the time is 10.0 or less


Thank you!

[GaryRussell]

You haven't stated whether it is a back or lay bet so I will assume it is a back bet. Here is a suggestion to how you could set it up for the first runner in the list.

1) Update to the latest Beta as the Excel trigger you require is not in version 1.1.0.62. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link.

2) Copy the following formula to cell R1. It will provide a reference to the number of seconds before the start of the race.

Code: Select all

=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))

3) Copy the following formula in cell Q5

Code: Select all

=IF(AND($R$1<=300,R5<=10,F2<>"Suspended"),"BACKSP","")

4) Copy the following formula into cell R5

Code: Select all

=F5

5) Put your required stake in column S.

You can use Auto select|At specific time before off from the market menu and set the time to 6 minutes so that each market in the quick pick list is selected at 6 minutes before the scheduled start time. You will probably also want to tick Clear bet refs on auto select market when setting up the link to Excel so that when a new market is selected the bet refs are cleared so new bets can be triggered.

[Jailbreak Heart]

Great, yes it was Back, I'll try it and let you know if there were any problems

Best regards

[Jailbreak Heart]

In step 3 I think the code should be

Code:
=IF(AND($R$1<=300,F5<=10,E2<>"Suspended"),"BACKSP","")

Right?

[GaryRussell]

No, my formula is correct. Suspended definitely appears in cell F2. Cell E2 only ever contains Not In Play or In Play

In step 4 you insert a formula that references cell F5 so it is actually referencing cell F5 indirectly.

The following formula would also be correct.

Code: Select all

=IF(AND($R$1<=300,F5<=10,F2<>"Suspended"),"BACKSP","")

[Jailbreak Heart]

ok. Got it, sorry. However I need to be more specific. If I want a margin of say 5% I need to capture the price with 300 seconds left and retain it, and strike the SP bet at that price * 1.05 in odds. The stake will be 100/(the price at 300 seconds)
Thanks in advance

[GaryRussell]

Since the SP bet will be placed at 300 seconds then you can simply insert the following formula in cell S5.

Code: Select all

=100/F5

You can insert the following formula in column R5

Code: Select all

=F5*1.05

[Captain Sensible]

ok. Got it, sorry. However I need to be more specific. If I want a margin of say 5% I need to capture the price with 300 seconds left and retain it, and strike the SP bet at that price * 1.05 in odds. The stake will be 100/(the price at 300 seconds)
Thanks in advance

If you want to capture the price at 5 mins before the off you'll need some VB code, the following code will capture the last price traded at 5 mins before the off ( it starts at 5:10 and stops at 5:00 so amend it if your refresh rate is higher than 10 seconds). It'll stick the price in column AA

Private Sub Worksheet_Change(ByVal Target As Range)
lastrow = Target.Rows.Count
If Target.Columns.Count <> 16 Then Exit Sub
Application.EnableEvents = False
If Cells(2, 4) > 0.003472222 Then
If Cells(2, 4) < 0.003587962 Then
For i = 5 To 35
Cells(i, 27) = Cells(i, 15)
Next i

End If
Application.EnableEvents = True

Else

Application.EnableEvents = True
End If


End Sub

[Captain Sensible]

ignore my post , hadn't read the post fully and didn't realise the bet was being placed 5mins before the off

[Jailbreak Heart]

Thanks anyway Captain

Sorry if my posts appeared a bit dim, didnt realise my version 64 had not loaded so I was struggling to work out why my bets weren't triggering

[Happy Harry]

I have had no luck with getting conditional BACKSP bets to trigger properly when there are more than 1 selection in a race when the criteria for the trigger is whether a particular runner is above or below a certain value in the forecast SP Column - Column Y. Using the original standard spreadsheet.

So in cell Q5 etc I have =IF(AND($AJ$5="Y",Y5>30,$F$2<>"Suspended", $E$2<>"In Play"),"BACKSP","")

What happens though is that if there is more than 1 runner in the list for a particular race with a bet value and any of the runners trigger the sheet both runners for that race have the bets put into the market even if the second (or more) runners does not satisfy the criteria.

So the "Trigger" column doesn't trigger the bets individually for BACKSP and LAYSP bets.

There is another sheet and thread, this one, viewtopic.php?f=8&t=3557 which address's a similar issue but I cant seem to make that work properly for BACKSP and LAYSP bets.

How can I get around this?

Thanks in advance.

HH