General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I want to work out the exact tote take out figures. I want to put all the final tote prices in and have a formula work out the final Overround figure. Can anyone please provide an excel formula that saves me having to add each price %manually.
Thanks
Thanks
Show More
If you understand percentages sufficiently to add them up manually then I don't see why you can't figure out how to do it in excel? Just have the prices in column A, the conversion to percentage in column B, then sum them up.
So for example if the first price is 3.5 that goes in A1, then in B1 you have =100/A1 which is 28.57143. If you have say 10 horses in the race, then in cell B11 (or wherever you want, really) you put =SUM(B1:B10) and it gives you the total book percentage.
Good luck!
So for example if the first price is 3.5 that goes in A1, then in B1 you have =100/A1 which is 28.57143. If you have say 10 horses in the race, then in cell B11 (or wherever you want, really) you put =SUM(B1:B10) and it gives you the total book percentage.
Good luck!
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539