Spreadsheets for calculating profit /loss on strategies
-
Can anyone help me please, I am wanting to set up a spreadsheet so I can copy and paste my results and know why strategies are making profit and which one I should scrap or redefine.
I am currently just recording the results on paper but not calculating profit from each trade. I haven't got a clue how to set up a spreadsheet and wondered if any of you could help me please.Thanks -
You can also use the BTC results sheet, so you can copy those into your sheet to help you get the results data and it would be in one place
http://forum.betfairtradingcommunity.com:4567/topic/840/btc-results-sheet
-
@jordan-kane Hi Jordan, is there a way I can download this template? Thanks
-
@jordan-kane said in Spreadsheets for calculating profit /loss on strategies:
I have attached the trading P&L spreadsheet I use myself but as I said it is pretty manual in terms of inputting dats. The overall summary tab shows your daily, weekly, monthly and yearly P&L across all football trading strategies. There is a tab for each strategy and I have left one trade in most of the tabs to show you how I populate it. I only trade football at the moment but I am sure it could be amended for other sports. Could be a good starting point and hopefully I will figure out how to export football stats data more easily to save time!
Thanks Jordan I will have a look at this evening much appreciated
-
I have attached the trading P&L spreadsheet I use myself but as I said it is pretty manual in terms of inputting dats. The overall summary tab shows your daily, weekly, monthly and yearly P&L across all football trading strategies. There is a tab for each strategy and I have left one trade in most of the tabs to show you how I populate it. I only trade football at the moment but I am sure it could be amended for other sports. Could be a good starting point and hopefully I will figure out how to export football stats data more easily to save time!
-
When updating results on your spreadsheets such as HT score, final score etc. Do you export this info from anywhere? I find it very time consuming looking back over results websites and manually entering the results of games, therefore it would be good to export stats of specific games. Is there a specific trading software which can do this?
-
Honestly mate just google it there are countless youtube videos, use the daily btc email spreadsheet martin uses as a template and then put in your own headings. Spreadsheets and tracking your trades are for me the key to profiting long term. So the more effort you put in the better your results.
-
Yeah they would be good. Hopefully they follow somewhere in the future.