Saturday, May 28, 2016

Exchange Spread Calculator

I've created an 'Exchange Spread Calculator' that uses the 'Bet For' and 'Bet Against' bids to come up with a few useful metrics:
Implied chance of winning for each horse based on 'Bet For' and based on 'Bet Against'
Total implied chance of winning for all horses in race based on 'Bet For' and based on 'Bet Against'
Spread in implied chance of winning for each horse
Total spread for all horses in race

Here's an example of the output with less than a minute until post time for the 2nd race at Presque Isle Downs on Thursday:


Right now, the calculator requires you to manually enter the best Bet For offer and best Bet Against offer for each horse, but I'd like to create a version of this that uses the Betfair API to automatically update the information live.

If you're interested in getting a copy of the spreadsheet containing the 'Calculator', just join my email list (on the right side of the screen) and then send me an email at zelvin30@hotmail.com letting me know that you'd like a copy.

No comments:

Post a Comment