New Posts For Thread: Evaluating Betfair betting historyhttps://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-historyHi,Can anyone tell me a formula, so when I download my betting history to Excel I can change the amount staked to a level stake and see what my profit and loss would have been. I.e. instead of staking £100, £300, £75 & £150 on 4 seperate bets, whMuch appreciated - will give this a go this afternoon.Thanks again.https://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-history?post_id=486338097#486338097Much appreciated - will give this a go this afternoon.Thanks again.Fri, 18 Feb 2011 05:05:34 -0600Have to change the formula in cell P8The original formula was for lays only at a liability of 100New formula for cell P8 and then fill down. Replace all Question marks (?) with less than symbol.and replace all # with more than symbol. I can't get thohttps://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-history?post_id=486326301#486326301Have to change the formula in cell P8The original formula was for lays only at a liability of 100New formula for cell P8 and then fill down. Replace all Question marks (?) with less than symbol.and replace all # with more than symbol. I can't get thoFri, 18 Feb 2011 00:11:47 -0600Typo in In cell O8 type =$O$8should be =$O$1When and if you do the above, say you wanted to find how many losers you hadclick on the triangle in cell P7 click select all to empty all boxes then ticknext to -100. In L column up the top it will tell yohttps://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-history?post_id=486306741#486306741Typo in In cell O8 type =$O$8should be =$O$1When and if you do the above, say you wanted to find how many losers you hadclick on the triangle in cell P7 click select all to empty all boxes then ticknext to -100. In L column up the top it will tell yoThu, 17 Feb 2011 19:34:52 -0600If you have have 10 to 15 minutes and want to do a reasonable job of setting up your spreadsheetto analyse your downloaded betting history ~ continue.Here we go!Do this step by step ~After downloading and the spreadsheet is open, select the firsthttps://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-history?post_id=486304621#486304621If you have have 10 to 15 minutes and want to do a reasonable job of setting up your spreadsheetto analyse your downloaded betting history ~ continue.Here we go!Do this step by step ~After downloading and the spreadsheet is open, select the firstThu, 17 Feb 2011 19:14:39 -0600Hi,Can anyone tell me a formula, so when I download my betting history to Excel I can change the amount staked to a level stake and see what my profit and loss would have been. I.e. instead of staking £100, £300, £75 & £150 on 4 seperate bets, whhttps://community.betfair.com/general_betting/go/thread/view/94082/27033801/evaluating-betfair-betting-history?post_id=486278589#486278589Hi,Can anyone tell me a formula, so when I download my betting history to Excel I can change the amount staked to a level stake and see what my profit and loss would have been. I.e. instead of staking £100, £300, £75 & £150 on 4 seperate bets, whThu, 17 Feb 2011 15:12:45 -0600