I am a firm believer in tracking all your stock trades. In fact, you can see how all my trading strategies are performing by visiting my trading profits page. By tracking your trades according to which strategy you are using you can identify how profitable a strategy is and whether you should be using more or less money to trade it. Furthermore, tracking your trades will help you to avoid trades that are based on hunches and not on specific strategies, because it will quickly become clear how quickly you lose money on such trades.
Download below a version of the trade log spreadsheet I use. Use a separate sheet in the spreadsheet for each different trading strategy. Watch the video below if you need guidance in how to use the spreadsheet.
Excel 2000 trade log spreadsheet
Open Office trade log spreadsheet
Disclosure: No positions in any stocks shown in the spreadsheets or in the video.
#1 by John C on August 26, 2009 - 11:53 am
you got the excel and open office document links Backwards… and Thank you Very much for making this for me. I was just thinking of making one within the next week or so…
#2 by Reaper on August 26, 2009 - 11:58 am
fixed it, thanks!
#3 by Preston on August 26, 2009 - 6:22 pm
Yeah same here buddy, thanks for doing this. I was working on one and me and my over thinking had this massive spreadsheet that did way more than I needed.
#4 by whizzler on August 26, 2009 - 6:49 pm
cheers reaps, very useful insight. I like the idea of weighted avg. have a great day in the markets tomorrow!
#5 by Reaper on August 26, 2009 - 8:25 pm
Another useful statistic is win/loss ratio. I’m not personally a huge fan, though. It is easy enough to program in with a for loop.
#6 by whizzler on August 26, 2009 - 9:20 pm
hmmm… just fiddling with Excel and this does the trick for me..
Win/Loss ratio
=COUNTIF(I:I,”>0″)&”:”&COUNTIF(I:I,”<0")
where 'I' denotes column title.
#7 by whizzler on August 26, 2009 - 9:27 pm
hmmm… just fiddling with Excel and this does the trick for me..
Win/Loss ratio
=COUNTIF(I:I,”>0″)&”:”&COUNTIF(I:I,”<0")
where 'I' denotes column title…
#8 by Anthony on March 30, 2010 - 1:44 pm
Question for you. I’m tracking my trades using the document above for Excel. When I buy and sell I don’t always get complete fills and their usually at different prices. When I average them out I don’t get the same dollar amount that TOS shows. When you keep track of your trades do you have the same issue or I am doing something wrong?
#9 by Reaper on March 30, 2010 - 1:47 pm
I rarely use TOS … simply put, either you or the software must be doing something wrong. Most likely it is you, or the software doesn’t take commission into account.
You can always use a new line for different fills. I’ll do this is I leg out of a position holding part of it much longer.