Record Keeping for Day Traders
A number of people have asked me how I keep track of my trades
and how I use my trading records. Instead of answer each query I've
decided to present the answer here in an article.
For my record keeping I always use Excel. You can use any
spreadsheet but I choose Excel because it's already on my computer.
The reason that I choose a spreadsheet over the custom record
keeping software out there is because of its flexibility and power.
You can do anything in Excel. It has its own built in programming
language (VBA) which allows you to extend it as much as you
If you decide that you want to start tracking or calculating
another aspect of your trading results then it usually takes no
more than 5 minutes to add in this feature and often no more than
This is a zip file holding a template of my trading spreadsheet
with some dummy trades in it. If you don't already have a record
keeping spreadsheet then this is not a bad place to start:
1 2 3