New Posts For Thread: Formula questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-questionA question for the mathematics geniuses on here.I am compiling a database of results, both football and tennis. I am working on the tennis one and what I want to calculate is this..In a match which is out of 3 sets..If I back the winner of Set 1 in e""https://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415990#420415990""Sun, 28 Feb 2010 15:14:55 -0600Your /3 formula in the 1st stage seems a bit too general as well, it's not a bad estimate but you're much better off recording odds inplay than using that and getting an idea whether it's profitable. I know the answer, but i'll let you figure it outhttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415746#420415746Your /3 formula in the 1st stage seems a bit too general as well, it's not a bad estimate but you're much better off recording odds inplay than using that and getting an idea whether it's profitable. I know the answer, but i'll let you figure it outFri, 26 Feb 2010 21:45:28 -0600=IF(A(GREATER)B, (S*(P2-1)), S + ((S*(P2-1))*(1/P1))+(-S*(1-(1/P1))))That should give you your profit (ignoring commission) in the event its a straight sets victory but in the event it goes to a 3rd set, the lay stake that makes you equal red. May bhttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415742#420415742=IF(A(GREATER)B, (S*(P2-1)), S + ((S*(P2-1))*(1/P1))+(-S*(1-(1/P1))))That should give you your profit (ignoring commission) in the event its a straight sets victory but in the event it goes to a 3rd set, the lay stake that makes you equal red. May bFri, 26 Feb 2010 21:31:49 -0600Cheers for the formula though.https://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415738#420415738Cheers for the formula though.Fri, 26 Feb 2010 21:29:32 -0600I'll give it a try when my mind is more active i.e. tomorrow.https://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415734#420415734I'll give it a try when my mind is more active i.e. tomorrow.Fri, 26 Feb 2010 21:29:01 -0600To work out the lay stake in the event goes to a 3rd set simply add S to that 3rd part of the formulahttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415730#420415730To work out the lay stake in the event goes to a 3rd set simply add S to that 3rd part of the formulaFri, 26 Feb 2010 21:22:16 -0600I may have to use a sequence of formulas.https://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415726#420415726I may have to use a sequence of formulas.Fri, 26 Feb 2010 21:07:54 -0600It's not too bad when you plug it into excel, that only gives your risk though in the event that the 1st set winner loses the 2nd, you want to the stake so let me have a thinkhttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415722#420415722It's not too bad when you plug it into excel, that only gives your risk though in the event that the 1st set winner loses the 2nd, you want to the stake so let me have a thinkFri, 26 Feb 2010 21:04:34 -0600Thanks, getting very complex!https://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415718#420415718Thanks, getting very complex!Fri, 26 Feb 2010 21:02:05 -0600=IF(AB, (S*(P2-1)), ((S*(P2-1))*(1/P1))+(-S*(1-(1/P1))))WhereA = Player who won 1st set, 2nd set scoreB = Player who lost 1st set, 2nd set scoreS = StakeP2 = Estimated price of A after winning 1st setP1 = Starting price of Ahttps://community.betfair.com/general_betting/go/thread/view/94082/23524814/formula-question?post_id=420415714#420415714=IF(AB, (S*(P2-1)), ((S*(P2-1))*(1/P1))+(-S*(1-(1/P1))))WhereA = Player who won 1st set, 2nd set scoreB = Player who lost 1st set, 2nd set scoreS = StakeP2 = Estimated price of A after winning 1st setP1 = Starting price of AFri, 26 Feb 2010 20:56:06 -0600