New Posts For Thread: Another maths questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-questionI used to be able to do this but have lost an old spreadsheet and can't remember how I got the formulaI 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 toThanks BayesThat did the trick cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806614#420806614Thanks BayesThat did the trick cheersFri, 05 Mar 2010 17:33:04 -0600ie. numerators are a=100yz... and c =100xy... (denominator the same)https://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806422#420806422ie. numerators are a=100yz... and c =100xy... (denominator the same)Thu, 04 Mar 2010 17:35:30 -0600I guess a and c follow symmetricallyhttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806418#420806418I guess a and c follow symmetricallyThu, 04 Mar 2010 17:33:25 -0600If x, y and z are the odds....then...b = 100xz/(z((x-1)(y-1)-1)-xy)https://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806414#420806414If x, y and z are the odds....then...b = 100xz/(z((x-1)(y-1)-1)-xy)Thu, 04 Mar 2010 17:30:13 -0600I worked it out! it doesn't look good but it goes like thisif Cell L5=5Cell L6=8Cell L7=13Then=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 HorseI can work out the other stakeshttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806410#420806410I worked it out! it doesn't look good but it goes like thisif Cell L5=5Cell L6=8Cell L7=13Then=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 HorseI can work out the other stakesThu, 04 Mar 2010 17:12:12 -0600Thanks 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 wageshttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806406#420806406Thanks 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 wagesThu, 04 Mar 2010 16:48:10 -0600Assuming the numbers 5,8 and 13 are in cells A1,A2,and A3 then=1/(1/A1+1/A2+1/A3)gives you the answerhttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806394#420806394Assuming the numbers 5,8 and 13 are in cells A1,A2,and A3 then=1/(1/A1+1/A2+1/A3)gives you the answerThu, 04 Mar 2010 16:40:45 -0600Sorry, odds are 5 8 & 13Dutched price is 2.49https://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806382#420806382Sorry, odds are 5 8 & 13Dutched price is 2.49Thu, 04 Mar 2010 16:11:23 -0600I used to be able to do this but have lost an old spreadsheet and can't remember how I got the formulaI 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 tohttps://community.betfair.com/general_betting/go/thread/view/94082/23531398/another-maths-question?post_id=420806370#420806370I used to be able to do this but have lost an old spreadsheet and can't remember how I got the formulaI 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 toThu, 04 Mar 2010 15:53:53 -0600