New Posts For Thread: Excel Help for Profit/Loss Analysishttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysisI'd like to analyse my 3 month P&L in a more in depth way but I'm not great with Excel. What information can I take from it and how ?That's the sort of thing I'm after, cheers Investor.https://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=486081657#486081657That's the sort of thing I'm after, cheers Investor.Wed, 16 Feb 2011 05:37:39 -0600*onhttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485874777#485874777*onMon, 14 Feb 2011 11:43:32 -0600i used to use macro's at uni for project management.the old adage is true though that he who fails to record or keep a close eye in his bets, fails.https://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485874741#485874741i used to use macro's at uni for project management.the old adage is true though that he who fails to record or keep a close eye in his bets, fails.Mon, 14 Feb 2011 11:43:18 -0600you do come across as the most intelligent person on these boards mr investor.i assume you missed a k off the £10https://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485874577#485874577you do come across as the most intelligent person on these boards mr investor.i assume you missed a k off the £10Mon, 14 Feb 2011 11:41:54 -0600regarding the process above, if you record it as a macro you can use it again and again. I have another macro that totals up the PnL of different markets for the same game, so that I can see how much I make per match.This is interesting because it wehttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485872669#485872669regarding the process above, if you record it as a macro you can use it again and again. I have another macro that totals up the PnL of different markets for the same game, so that I can see how much I make per match.This is interesting because it weMon, 14 Feb 2011 11:25:37 -0600I guess you're talking about the account statement listing all transactions?On the market PnL you only see profit per market, not individual bets.I've automated everything now. But if you want to work out profit by market type: correct score, match ohttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485872165#485872165I guess you're talking about the account statement listing all transactions?On the market PnL you only see profit per market, not individual bets.I've automated everything now. But if you want to work out profit by market type: correct score, match oMon, 14 Feb 2011 11:21:38 -0600Cheers for the replies.I want to see how my stake has increased, what the average stake is, what my average odds are and how much profit I have made on each day.Because I back and lay many times in a market I'm not sure how to extract meaningful resuhttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485849297#485849297Cheers for the replies.I want to see how my stake has increased, what the average stake is, what my average odds are and how much profit I have made on each day.Because I back and lay many times in a market I'm not sure how to extract meaningful resuMon, 14 Feb 2011 07:01:00 -0600Hi Rocket. I always felt that you should decide what you want to analyse and then base your stats on this, rather than get a load of information and then try to work out what you can do with it. I suppose my question back to you would be what is it yhttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485849041#485849041Hi Rocket. I always felt that you should decide what you want to analyse and then base your stats on this, rather than get a load of information and then try to work out what you can do with it. I suppose my question back to you would be what is it yMon, 14 Feb 2011 06:56:55 -0600Check whether you do best backing or laying and analyse both by price range. Be careful not to change strategy on small data sizes. Continue to monitor. If you record your bets yourself, you could consider adding other details. e.g. If it's horse rachttps://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485848985#485848985Check whether you do best backing or laying and analyse both by price range. Be careful not to change strategy on small data sizes. Continue to monitor. If you record your bets yourself, you could consider adding other details. e.g. If it's horse racMon, 14 Feb 2011 06:55:48 -0600Suppose that post is a bit vague. I've converted the Stake column to Numbers and summed it so now I have my total stake for backs and lays. Is there anything useful I can do with this now ?https://community.betfair.com/general_betting/go/thread/view/94082/26996757/excel-help-for-profitloss-analysis?post_id=485848309#485848309Suppose that post is a bit vague. I've converted the Stake column to Numbers and summed it so now I have my total stake for backs and lays. Is there anything useful I can do with this now ?Mon, 14 Feb 2011 06:44:10 -0600