I recently realized that it is very important to have real-time trading stats for my trades.
I looked around the internet and there are a lot of solutions out there…some good, but mostly mediocre. The majority of the spreadsheets were very simple and although I’m all about simplicity most of the time, I wanted something that would do a fair amount of analysis to give me better insight into my trading on the fly.
There is a spreadsheet that is being sold on eBay that actually looks really good but like all commercially produced spreadsheets, they have to protect the spreadsheet so people don’t copy the design. This is fine of course, but doesn’t allow me to customize the data that I can get from it.
I created an Access database a couple years ago, but I never ended up using it. I thought about using it again, but I decided that it is overkill and Access is not a very stable platform anyway.
Therefore, I decided to create my own spreadsheet using Excel. I might upload it to Google Docs later so I can access it on any computer, but I’ll see how it goes. It depends on how easy Google Docs is to use.
I don’t know why I didn’t think of doing this before but review and improvement is key to success in any field. In Kelly Slater’s Biography, he mentions that after a particularly agonizing defeat, he went back and looked at all his old results and analyzed each heat and how he could have won that heat and what the judges were looking for. This type of study helped him become 9-time world surfing champion, the most championships of any surfer in history.
So here is a list of things I would like the spreadsheet to do:
- Win/Loss %
- Average profit/loss
- Biggest profit/ loss
- Day of the week analysis – Which are the best/worst days to trade for me based on results
- Strategy used when entering a trade
- Profitability of each strategy
- Best day of the week to trade strategy
- Time of day analysis – What time of day to most of my winning trades happen?
- Time of day broken down by strategy
- Biggest/average drawdown
- % equity risk on each trade in relation to win %
- Reason to exit trade
- Mistake (if any) made on trade – would help me track things I do wrong often
- Average risk/reward ratio
- Equity graph
- Notes on each entry and exit
- Max number of losses/wins in a row
- The ability to enter custom lot sizes (for Oanda trading)
This is by no means a complete list and I may remove some of these items, but I think this is a good start. How do YOU track your trades? Do you have any suggestions for useful metrics to track?
Feel free to leave a comment below and let everyone else know what you think.
When I a get a version that I like, I’ll post it here…for FREE. Check back soon!
If you liked it, please share: