We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
|
By:
Removing Man U (As you can get it right by accident with a 50-50 shot)
So Chelsea 2.0 = .500 Man U 4.0 = .250 Ars 5.5 = .182 Man C 7.0 = .143 Pool 11.0 =.091 Total 1.166 So, the overround is 16.6%, I'm going to assume you want to keep that the same. Taking out Man U 1.166 - 0.25 = .916 Then: Chelsea = .5/.916 = .546 Arsenal = .182/.916 = .199 Man C = .143/.916 = .156 Pool = .091/.916 = .099 BUT you want to retain the 16.6% overround (or you might not, in which case stop now) so multiply each one by 1.166 Chelsea = .633 Arsenal = .232 Man C = .182 Pool = .115 Then to turn into odds, it's 1/.633 for Chelsea = 1.58 1/.232 for Arsenal = 4.3 1/,182 for Man C = 5.5 1/.115 = 8.7 for Pool There are quicker ways but that step by step allows you to stop where you like and write your own formula etc for excel if you need. *Disclaimer: I've not slept much for two days, so could be errors. |
|
By:
Note that Chelsea are 1.84 if you remove the overround. Big difference!
|
|
By:
If prices of remaining teams are in Column A:
Then required odds are given by replicating =A1*COUNT(A:A)/HARMEAN(A:A) |