New Posts For Thread: Maths help required re odds %ageshttps://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-agesHow would i work out a figure for how low a horse has traded ie if a horse is backed at 7/1 (12.5%) and traded at 3/1 (25%), i think it would be true to say that horse has traded at 50% of the backed price. If so, what equation would you use to workGood man, top2. It's just aswell i'm better at punting than with maths, Excel etc or i'd be ****ed! All the besthttps://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481519849#481519849Good man, top2. It's just aswell i'm better at punting than with maths, Excel etc or i'd be ****ed! All the bestFri, 14 Jan 2011 03:24:34 -0600duncan idahoYou can see for yourself; probably easier than me trying to post it here!When you've got the spreadsheet in view just click on File and then move cursor down to Download as and take your pick.Save it and look at it at your leisure.https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481454457#481454457duncan idahoYou can see for yourself; probably easier than me trying to post it here!When you've got the spreadsheet in view just click on File and then move cursor down to Download as and take your pick.Save it and look at it at your leisure.Thu, 13 Jan 2011 13:45:11 -0600Thanks for the help....much appreciated. Yeah, that's the sort of thing i'm looking for top2rated...what calculation are you using to arrive at the %IPMINhttps://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481447849#481447849Thanks for the help....much appreciated. Yeah, that's the sort of thing i'm looking for top2rated...what calculation are you using to arrive at the %IPMINThu, 13 Jan 2011 12:44:29 -0600how has horse traded at 50% of back price..7/1 to 3/1 is a 4 point difference(50% would be 7/2)..divide the difference by original price..4/7=57.14%.......5/8=62.5%..forget probability percentages.. keep it simple....:-))))))))))))))))))))))))https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481363661#481363661how has horse traded at 50% of back price..7/1 to 3/1 is a 4 point difference(50% would be 7/2)..divide the difference by original price..4/7=57.14%.......5/8=62.5%..forget probability percentages.. keep it simple....:-))))))))))))))))))))))))Wed, 12 Jan 2011 17:22:44 -0600If deep down you are asking how to consolidate Backs and Lays:Assume you record Backs in Columns : Stake and Gross Return.Then Lays can be integrated by thinking of them as Negative Backs.eg Back $100 @ $5Lay $80 @ $4Record:100 500-80 -320Total is20https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481343321#481343321If deep down you are asking how to consolidate Backs and Lays:Assume you record Backs in Columns : Stake and Gross Return.Then Lays can be integrated by thinking of them as Negative Backs.eg Back $100 @ $5Lay $80 @ $4Record:100 500-80 -320Total is20Wed, 12 Jan 2011 14:57:00 -0600duncan idahoIs this the sort of thing you're talking about?https://spreadsheets.google.com/ccc?key=0AjriKHhwpRQQdEdVSzVuYXVMajZfSDk1NWdHeHhpbVE&hl=en&authkey=CK39idUF#gid=0https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481331929#481331929duncan idahoIs this the sort of thing you're talking about?https://spreadsheets.google.com/ccc?key=0AjriKHhwpRQQdEdVSzVuYXVMajZfSDk1NWdHeHhpbVE&hl=en&authkey=CK39idUF#gid=0Wed, 12 Jan 2011 13:25:20 -0600Oh right...i'm confused again now.https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481329049#481329049Oh right...i'm confused again now.Wed, 12 Jan 2011 13:02:22 -0600You're mixing probabilities and odds, remember the probability is worked out using decimal odds where the stake's included whereas the odds don't include the stake. So for a horse to have traded half the odds of 7 (8's) it'd only need to hit 7/2 (4.5https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481324417#481324417You're mixing probabilities and odds, remember the probability is worked out using decimal odds where the stake's included whereas the odds don't include the stake. So for a horse to have traded half the odds of 7 (8's) it'd only need to hit 7/2 (4.5Wed, 12 Jan 2011 12:24:39 -0600Cheers Lori. What i'm trying to do is work out how many of my bets trade IR at less than 50% of backed price (and less than 25% etc). So equation would be 100-(backed price/traded price)....x100 for %age. Many thankshttps://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481323473#481323473Cheers Lori. What i'm trying to do is work out how many of my bets trade IR at less than 50% of backed price (and less than 25% etc). So equation would be 100-(backed price/traded price)....x100 for %age. Many thanksWed, 12 Jan 2011 12:16:11 -0600Ok, think I know what you're trying to do.You're trying to say "How much of this horse was backed"So if it starts at 9.0 and comes into 4.0, then there's 44% of the price left, so 56% of it has been taken.https://community.betfair.com/general_betting/go/thread/view/94082/26623605/maths-help-required-re-odds-ages?post_id=481322861#481322861Ok, think I know what you're trying to do.You're trying to say "How much of this horse was backed"So if it starts at 9.0 and comes into 4.0, then there's 44% of the price left, so 56% of it has been taken.Wed, 12 Jan 2011 12:11:17 -0600