General Betting
There is currently 1 person viewing this thread.
I used to be able to do this but have lost an old spreadsheet and can't remember how I got the formula
I want to calculate a dutch lay on three horses say at 3.0 5.0 & 8.0 so that my total liability is exactly £100 for all three. I know that those totals added together is approx 2.47 (i can work that out) but can't get the liability right.
Any takers to ease my pain?
I want to calculate a dutch lay on three horses say at 3.0 5.0 & 8.0 so that my total liability is exactly £100 for all three. I know that those totals added together is approx 2.47 (i can work that out) but can't get the liability right.
Any takers to ease my pain?
sort by:
Show
per page
Replies: 8
|
By:
Sorry, odds are 5 8 & 13
Dutched price is 2.49 |
|
By:
Assuming the numbers 5,8 and 13 are in cells A1,A2,and A3 then
=1/(1/A1+1/A2+1/A3) gives you the answer |
|
By:
Thanks for the reply bongo but as I said I know how to get that answer, it's the stake that I need to work out so that if I put £33.44 on H1 and £20.90 on H2 and £12.86 on H3 then my total liability on all three is £100 - it's getting those wages that I am struggling on
|
|
By:
I worked it out! it doesn't look good but it goes like this
if Cell L5=5 Cell L6=8 Cell L7=13 Then =100/(((100+(100/(L6/L5))+((100/(L6/L5))/(L7/L6)))*(1/(1/L5+1/L6+1/L7)-1))/100) gives me £33.440514 to lay on the first Horse I can work out the other stakes from there. But if anyone else can make it easier I would appreciate it |
|
By:
If x, y and z are the odds....
then... b = 100xz/(z((x-1)(y-1)-1)-xy) |
|
By:
I guess a and c follow symmetrically
|
|
By:
ie. numerators are a=100yz... and c =100xy... (denominator the same)
|
|
By:
Thanks Bayes
That did the trick cheers |