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.