Conditional SP betting

[Cockneydan]

Can someone please help.
I found out to my cost that a strategy I have been working on only works with the SP price. I would like to use a excel spreadsheet to automatically place a bet based on various criteria including whether or not the SP price falls into a specific range.
For example I would like a bet placed if the SP price is greater or equal to 10 but less than 25. Is that possible?

Thank you

[alrodopial]

You can specify the lower odds for backSP and the max odds for laySP, not both for the same bet .

[Cockneydan]

Thanks for the reply.
I have seen you can set minimum odds for a back bet and maximum odds for lay bet. I think you can do this on the standard betfair site. I wondered if there was any way using this software you can specify the minimum and maximum odds you would take for a SP back bet that I could then use to trigger a bet as part of a bigger automation calculation?

[alrodopial]

Will the sp price be used as part of a calculation and not be taken?
You can not set ie a max limit for a back sp bet but if you get matched at odds higher than this limit it would be great. When I place a back bet at ie odds of 5.0 I love it if it gets matched at odds of 8.0, wont you?

Thanks for the reply.
I have seen you can set minimum odds for a back bet and maximum odds for lay bet. I think you can do this on the standard betfair site. I wondered if there was any way using this software you can specify the minimum and maximum odds you would take for a SP back bet that I could then use to trigger a bet as part of a bigger automation calculation?

[MarkRussell]

Thanks for the reply.
I have seen you can set minimum odds for a back bet and maximum odds for lay bet. I think you can do this on the standard betfair site. I wondered if there was any way using this software you can specify the minimum and maximum odds you would take for a SP back bet that I could then use to trigger a bet as part of a bigger automation calculation?

The software can't do anything that you can't do on the website but what it does allow you to do is speed everything up, e.g. how quickly you can refresh the prices, making calculations for green up, dutching etc and then automating processes through Excel triggered betting.

[Cockneydan]

Again thank you for the replies.

I currently have a spreadsheet set up that pulls out various horses from every race of the day. One of my criteria for placing the auto bet is that I want the SP starting odds to fall within a given odds range e.g. 10<= and <20.

If I was to use the SP and set a minimum price only it would place bets on all the horses picked out on my spreadsheet over the odds of 5. This would result in backing too many horses and run a loss.

I tried it last week setting a time close to the start of the race, not using SP and specifying a price range and if a horse met that criteria place a £2 bet. I quickly went through my gambling pot.
I also ran the same exercise after the day’s racing using the Timeform results sheet and the SP shown for each horse. That showed I would make a profit.

The difference in using SP and not SP is that just before the start of the race the prices fluctuating will inevitably mean more horses trigger a bet as the odds drop in and out of the range I have specified, and too many bets equals a loss. I need to limit the amount of bets placed and my analysis of SP prices shows I need to base my bets based on these rather than the market prices just prior to the race.

Thank you for your help

[MarkRussell]

Hi,

Then you must wait until the SP is reconciled just after the race has gone in play and then place the bet in play assuming the SP price is within your range.

Regards,
Mark

[alrodopial]

1. Manually watch every race and place the bet manually as close to the actual start as you can - odds will fluctuate a bit
2. What Mark suggested -have in mind that you may not get matched

[Cockneydan]

Hi Mark
Thanks for the note. So basically the best way to achieve my goal is to trigger a bet as soon as the race is in play. Is there a way of limiting to a time, for example within 10 seconds from the off?
Cheers
Dan

[MarkRussell]

Hi Mark
Thanks for the note. So basically the best way to achieve my goal is to trigger a bet as soon as the race is in play. Is there a way of limiting to a time, for example within 10 seconds from the off?
Cheers
Dan

If you watch for the race going in play and then wait at least 2 seconds, that should be plenty of time for the SP to be fully reconciled and hopefully won't get caught out by any false starts.

Regards,
Mark

[Cockneydan]

Thank you

Dan

[peleus]

Got it here. I was assuming that it was around 3-4 seconds before but now you mentioned it, 2 seconds still works fine.