SP to Betfair odds conversion

[MiniBlueDragon]

Hi all. I currently use a formula to estimate the required Betfair odds for a selection based on it's SP. As the odds increase, the multiplier does also as you'd expect, however above an SP of 3/1 things start to get a little erratic.

Couple the above with big odds swings due to lack of volume on the exchanges and I'm not actually sure it's possible to calculate a decent conversion as the odds go up but I figured I may as well ask in case anybody's found something accurate throughout the odds range (my system doesn't have an odds cutoff)

Any ideas folks?

[austingrd]

Hi Mini, I got nothing on top of my head for this. Have you found any updates yet?

[MiniBlueDragon]

It's not ideal at all and I don't have the historical BF SP's to confirm the higher odds numbers but this is what I'm using to estimate currently:

Code: Select all

=IF(F2<1,F2*1.05+1,IF(F2<1.875,F2*1.1+1,IF(F2<4,F2*1.15+1,IF(F2<6,F2*1.2+1,IF(F2<9,F2*1.3+1,IF(F2<12,F2*1.4+1,IF(F2<15,F2*1.5+1,F2*1.6+1)))))))

F2 is the cell with my SP figure.

That's spot on for everything of SP <= 4/1 but above that it loses the correlation as the odds increase (I think!)