Trade Tracking Spreadsheet

by Hugh Kimura on August 7, 2009 · 3 comments · Trade Well


Where are my profits?

Where are my profits?

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!

Cheers,
Hugh

About The Author: Hugh Kimura
Hi, I'm Hugh Kimura and my mission is provide you with the very best information about trading and living better through research and my own personal experience. You can also follow me on Twitter and Google+. Note: All information is for entertainment and education only and is not investment or trading advice.


If you liked it, please share:



Want More? Yup, It's Also Free...


  • The Complete Strategy Development Course
  • The Ultimate Free Forex Education Directory
  • The Trading Plan Template
  • And More!
"...your forex Strategy Development Course has added so much structure to the way I produce, test, and analyze a strategy. I definitely think it belongs on the TOP of the Forex Trading Courses list." - Bryan Tenort
Justin White August 7, 2009 at 11:39 pm

Please post that version whenever you get it. I would love something like that. The one I use is just very basic and keeps basic stats with excel.

Hugh August 8, 2009 at 4:58 pm

Sure thing.