Keeping an accurate trading journal of all your trades is essential for your growth as a trader. You can’t improve if you don’t track.
You can use our Free Trading Journal to track Stocks, Futures, Options, Forex, and Crypto. In fact you can track all of them on the same spreadsheet.
Honestly, I think it’s the best free trading journal you’re going to find. Keeping your monthly expenses down is essential when you start trading, so no need to use any expensive software.
Our journal provides you with all of the statistics and calculations you’re going to need to properly analyze your trading data.
All of the data inputs you will track in the journal are the same data inputs you will need down the road should you decide to start using a different journal.
Free Trading Journal Download
You can download the Excel Trading Journal or access the online version, Google Sheets Trading Journal, by following these steps:
- If you’re not already a JT Insider, register here. It’s free.
- In the first email title “Insider Downloads” there will be a link to the JT Insider Downloads page.
- Download the Excel file titled “Trade Journal” or use the online version via Google Sheets which is in the folder as well. It’s free to sign up for a Google Drive Account if you don’t have one already.
- Please note, if you are going to use the online version you must duplicate the file in order to be able to edit.
Personally I prefer the Google Sheets version as I love Google Docs and and having everything in the cloud. It comes down to personal preference, they both accomplish the same thing.
Note: If you are already an Insider but lost the link to the downloads folder you can simply sign up again.
How to Use the Trading Journal
The journal is very easy to use once you understand a few of the definitions and features. These inputs are optional depending on what you want to track.
The following data inputs are located on the Journal Tab.
MULTIPLIER (Column B)
The Multiplier is specific to the instrument you’re trading and is used by the spreadsheet to calculate your P&L.
Use the following values depending on the instrument you’re trading.
This will be the value of a 1 point move on 1 contract
eMini S&P 500: $50
eMicro S&P 500: $5
eMini Nasdaq 100: $20
eMicro Nasdaq 100: $2
The value will always be 1
Value of the Contract
EURUSD Standard Lot: $100,000
EURUSD Mini Lot: $10,000
EURUSD Micro Lot: $1,000
You can double check you’re using the correct multiplier by confirming your P&L is accurate.
High Price & Low Price (Columns M&N)
The High Price and Low Price inputs are use for calculating MFE & MAE.
Maximum Favorable Excursion (MFE) marks the highest price during a long trade and the lowest price during a short trade.
The MFE measurement can be used to analyze the efficiency of your exits.
You potentially can improve your strategy by analyzing MFE and determining if you should be more or less conservative with your take profit.
Remember that anytime you make and adjustment to a strategy it’s a give take relationship. If you tighten your take profits your win rate will go up but your expectancy is going to drop. So make sure to evaluate both sides.
Maximum Adverse Excursion (MAE) marks the lowest price during a long trade and the highest price during a short trade.
The MAE measurement can be used to analyze the efficiency of your stop placement.
Once again you can looking to improve your strategy by analyzing MAE to determine if you should be more or less conservative with your stops.
If for some reason you’re not interested in tracking MFE/MAE, you can simply hide columns M&N.
Simply highlight the columns and right click>Hide columns, as seen below.
Changing Strategy Names
To change the strategy names to reflect the strategies you trade you will need to unhide the formulas. Head over to Column P and click on the black arrow in the upper right of the cell.
This will unlock all of the formulas as seen below. Now you can change the names of the strategies by editing the labels in column Q.
Once you’re done I would hide these columns again so you don’t accidentally change a formula. Simply highlight the columns and right click>Hide columns, as seen below.
Linking Trade Photos
I find it beneficial to link the trade photos to the journal so they’re easily accessible.
To do this start by creating a folder in Google Drive where you will store your photos.
After storing your trade photos, right click on the photo and choose get link and then copy the link as seen below.
Next head back to your journal and highlight the corresponding trade photo number and hit the insert link button as seen below.
You are free to edit any formulas that you wish but you may end up breaking a formula in the spreadsheet if you don’t know what you’re doing. If you accidentally screw something up you can always just download or duplicate the original journal again.
There are two additional hidden sheets you will have to unhide by going to View>Hidden Sheets.
Tracking your trades in a trading journal is going to allow you to analyze and improve your performance.
I’ve been trading a very long time and I still prefer a traditional spreadsheet journal over any other software or third party journals. You’re always going to have different needs, and the ability to manipulate the raw data how you want is very beneficial.
If you’re not familiar with Excel or Google Sheets a quick google search will get you the answer as they are both extremely well documented.
I hope you enjoy our Free Trading Journal!
If you have a question or a request for the spreadsheets please leave a comment below.
Thanks Adam! Quick question. Why do you have a different spreadsheet for backtesting?
When I first begin backtesting something new I like to keep it pretty basic until I’ve recorded 50 – 100 trades. At that point if it looks like it has potential I will go back through those trades and track a lot more variables. Simply put, it’s just less time consuming until I know a strategy has potential.
Thank you very much for this journal, love it.
Glad to hear Dustin!
If I am trading forex what is quantity mean?
Hi Andres, thanks for the comment! Quantity is simply the number of contracts. It’s your position size.
hey thank you soo much loving this. it’s been a lot of help to track these data, i’m still a paper pen journal writer but this excel helps me to track a lot of other information without manual calculation. thanks buddy
Thanks for the comment! I’m glad you’re finding it useful!
If you sell partly of a trade, say 25% after a move, then 50% after a couple of days and rest like a few more days later, how do you keep track in the journal?
Thank you for an awesome journal.
Thanks for the comment! You would simply have to calculate the average exit price. If you sell half at 9.50 and half at 10.00 your exit price would have been 9.75. For exit day just use the final date you exit.
This looks amazing, excited to give this a try!
Awesome! Let us know what you think could be improved!
I was trying to create a journal myself, did a google search and found your journal. This is much more than I could ever do with all the statistics and details, which is super helpful. Thanks for being generous to share this for free. Most websites, look for your money right away or free stuff is sub-par. Again thanks much.
Greatly appreciated Sujith! Glad you’re finding it useful.
Thank you for being so generous as to provide a free journal! It is really appreciated. However, when I open the download it says there is an error. It will open but the Net P&L and Gross P&L show a formula error.
=IFERROR(IF(C4=”Long”,((J4-H4)*B4*G4)-O4,IF(C4=”Short”,((H4-J4)*B4*G4)-O4,””)),”Symbol not found”)
Am I doing something wrong? Thanks again for all you do to help us newbies.
Hi Kim, thanks for the comment. I can’t really troubleshoot without seeing the file. I just double checked and it’s working for me. Possibly a version issue. Best option is to use the Google Sheets version.
Hey Adam, I have a discord group with some other traders. I’ve been looking for a solid trading journal that I can use in excel or google sheets for free and came across this one and it looks great!
I’m sure your tracking sheet is protected under copyright, being IP, but I was curious if I would be able to share this with my fellow traders?
Of course Nate, feel free!