Does anybody know the Formula within a spread sheet to calculate the Betfair Odds Increments?
For Example I know say 6.0 and I want 9 ticks from this = 6.0+1.8 =7.8
The problem is all good till I get to 9.8 and want same amount of 9 Ticks =14.5 which will be 14.5
Does anyone know the Formula for this to add on in Spreadsheet?
Odds Formulas Spreadsheets
I haven't used a spreadsheet to place bets for a few years, but my workaround was to use an additional sheet and in column A I had every price in 0.01 increments, and in column B I had the closet odds allowed for placing a bet. For example, 9.84 matched to 9.80.
I then used a vlookup formula to convert my calculated odds to the odds I could place the bet at.
Hope that makes sense.
I would give you an example spreadsheet but I'm currently on holiday with only my phone.
I then used a vlookup formula to convert my calculated odds to the odds I could place the bet at.
Hope that makes sense.
I would give you an example spreadsheet but I'm currently on holiday with only my phone.