In-running bet being price dependent on BSP?

Questions about integrating Excel and Cymatic, programming, formulae, etc

In-running bet being price dependent on BSP?

Postby RoB » Sun Jan 20, 2019 11:39 am

If a bet is struck with the instruction to take Betfair SP as the default, as soon as the race starts the Cymatic software works out and displays the profit should the bet be successful. This suggests that Cymatic is reading the BSP from somewhere.

So, would it be theoretically possible to...
1) display the BSP's in Cymatic (even if solely displayed in to the Cymatic Excel worksheet?)
2) crucially, act upon them?

For example, if the race at Cheltenham starts and immediately at this point the BSP of Altior is sent from Betfair as 2.0, would it then be possible to strike further bets in-running with reference to this BSP? i.e. only back Altior if he drifts out to, say BSP +1.0 (3.0) or, say, only LAY if price goes to BSP -0.5 (1.5) ?

Thanks,
Rob
RoB
 
Posts: 49
Joined: Sun Aug 14, 2016 6:42 am

Re: In-running bet being price dependent on BSP?

Postby Gavin » Tue Jan 22, 2019 12:05 am

Hi Rob,

Cymatic does not display the BSP price, so I usually suggest that people calculate an expected SP by looking at the prevailing price just before the market goes in-play, which on average will probably be a pretty close estimate of BSP. This can be done using the Visual Basic Editor in Excel, to store the prevailing price just before the market goes in-play.

Yes, Cymatic displays the P&L for a bet after it takes the SP price at the off, but it is not because Cymatic reads the SP price. It is just because the software reads the price that bets are matched at.

Kind regards,

Gavin
User avatar
Gavin
Site Admin
 
Posts: 3835
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron