General Betting

‹ back to topics

There is currently 1 person viewing this thread.

Percentage Figures

argosy

23 Mar 16 21:58

Joined:

Date Joined: 01 May 03

| Topic/replies: 334 | Blogger: argosy's blog

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

Switch to Live View refresh Post Reply

Post your reply

sort by:

Show per page

Replies: 1

By:

Knight Rider When: 24 Mar 16 15:23

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!