Spreadsheet/tools for managing trades.
-
Hi, can’t seem to find any advice on how you keep track of your trades, different spreadsheets for different types of trade, or a single one, any pointers would be apppreciated, you can guess by the post I’m new to trading, thanks,
Martyn. -
@martyn-hemmens said in Spreadsheet/tools for managing trades.:
Hi, can’t seem to find any advice on how you keep track of your trades, different spreadsheets for different types of trade, or a single one, any pointers would be apppreciated, you can guess by the post I’m new to trading, thanks,
Martyn.Hey Martin. I use this "Betting Tracker Worksheet" offered for free download at Australia Sports Betting
-GoogleSheets Version: http://www.aussportsbetting.com/tools/google-sheets-betting-tracker/
-Excel Version: http://www.aussportsbetting.com/tools/betting-tracker-excel-worksheet/After trying dozens of simple and complex SpreadSheets Templates and those by my own craft; this is the one.
You can record as a category(s) and subcategory(s):
-Sports
-Markets
-Strategies
-Bookmakers
-Bankroll, deposits, withdrawal.You can filter results of your TradeHistory, by Sport, by Market, by SubMarkets, by Strategy, etc.
I just work with Football, so I use that "category" to customize my strategies, and below the three, markets. Is fully adaptable to take out columns that not suit you. And add some columns for any specific data you need to keep track for every trade.
Keeping monitored you ReturnOfInvestment, Yield and BankRollover gives you a huge idea where you can improve or trash strategies, cut Losses, focus on ProfitableMarkets, etc.
Give a look and let me know any doubt. I did a few tweaks, to keep it simple and robust at the same time. An right now im adding BTCMembers strategies that i worked with, coz im new in this community.
I will be glad to offer you/any a Screenshot or ScreenAudioVideo meeting if its required. Because it would be overwhelming at first sight.
Cheers.
-
@kristian
wow many thanks, just need to get my head round it, thanks.
-
@kristian said in Spreadsheet/tools for managing trades.:
I just created a spreadsheet that has all the strategies that I use on different pages. You can copy and use for your own if you like it...
https://docs.google.com/spreadsheets/d/12xD4zjs9C4sUZyoS4UB-iNJRRCrf1efWvenXomuaRN8/edit?usp=sharing
I do it another way and have all my results on one data sheet but then also have a summary sheet for each strategy and country so I can see the overall results and strike rates by strategy and country
-
I just created a spreadsheet that has all the strategies that I use on different pages. You can copy and use for your own if you like it...
https://docs.google.com/spreadsheets/d/12xD4zjs9C4sUZyoS4UB-iNJRRCrf1efWvenXomuaRN8/edit?usp=sharing
