Odds formula turns out odds that don't exist

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
maik79
Posts: 22
Joined: Fri Jul 23, 2010 9:19 am

What if i have formula in odds and it turns out 6.134

You know only 6 and 6.2 do exist on Betfair, would it place the bet at 6 or 6.2 still?
toptrader
Posts: 77
Joined: Sun Jan 31, 2010 9:58 pm

No
easiest to use an excel lookup to pick the next odds available. Guardian won't process something which doesn't exist as an actual Betfair odds price
maik79
Posts: 22
Joined: Fri Jul 23, 2010 9:19 am

Thanks.
BeatTheHouse
Posts: 10
Joined: Sat Nov 27, 2010 9:21 am

You can get excel to round the numbers off to two decimal places if that helps you, but remember that any calculations you use will be the real figure not the rounded figure unless you manually set it.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”