Trade Log – Excel Spreadsheet

13 July, 2010

Trade Sheet V5

This set of spreadsheets I find useful for backtesting and keeping track of my trades. It calculates SQN, MAE, Exit Efficiency, Profit Factor and PROFIT. It allows you to work out exactly how much to risk per trade for a set % risk of capital and with enough data will show which set-ups are the most profitable. All in all a darn handy bit of code. As it should be because it took me six months of refinements to get it to where it is! It comes with a handy help/example sheet to start you off…

{ 10 comments… read them below or add one }

RobM January 14, 2011 at 5:15 am

Excellent Trade Log spreadsheet. Thank you.


Allonblack January 16, 2011 at 7:57 pm

Anthony – I really like the spread sheet. I am going to try and incorporate into my trading process. I would be interested in the definitions for each column if possible. Either way great work!


Anthony January 16, 2011 at 9:52 pm

Hi Allonblack, If you look in the notes section on the example sheet there are some basic outlines of what each column represents. If you have any specific questions ask away. Anthony


allonblack January 17, 2011 at 4:00 pm

Anthony -

Do you have any thoughts of adding entry point and exit point?




UC January 18, 2011 at 2:09 pm

Hi there,

FYI, between the other records, I have found that it’s useful to keep track also of the time spent on trades.
In my case (I trade FESX and ES for 6 ticks) i’ve found that the longer the trade it takes, the worst the result. Winning trades are usually are the fastest to be close.

Nice work on your spreadsheet. Thank you for sharing. May I ask you to spend more words on the “exit test” (or just indicate to me some reference). I’m completely new to this concept.

Good trading,



Anthony January 18, 2011 at 4:57 pm

Hi UC,

Totally agree with you regarding time

Here’s a full explanation of exit test:

Good trading,



scott October 9, 2012 at 4:39 pm

Hi Anthony, I was looking at your excel spreadsheet for trades. Is there any chance you can email me a copy of the excel spreadsheet so I can start one of my own?

Thank you.


Anthony October 9, 2012 at 4:46 pm

Hey Scott,

Just hit the blue highlighted text “TradeSheet V5″ at the top of this post and you should get a download Excel file.



Kay March 8, 2014 at 12:06 am

Hi Anthony,

Your spreadsheet is wonderful! Thank you very much for sharing it. I trade multiple Forex and futures products. Where can I add a column in your spreadsheet to record which products I trade in the transactions? So far whenever I tried adding a column, there is a warning saying that data embedded may be lost. I appreciate a lot your help! Thank you!!


Kay March 8, 2014 at 7:04 am

Hi Anthony,

I have figured out how to add a column for the symbol. Again, thank you!

Happy trading! God bless!


Leave a Comment

{ 1 trackback }

Previous post:

Next post: