Free Trading Journal

Post Title - Featured Image

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

Trading Journal Statistics Page with Charts of P&L, MFE, and MAE

You can download the Excel Trading Journal or access the online version, Google Sheets Trading Journal, by following these steps:

  1. If you’re not already a JT Insider, register here. It’s free.
  2. In the first email title “Insider Downloads” there will be a link to the JT Insider Downloads page.
  3. 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.
  4. 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.

Data Definitions

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.

Future Contracts
This will be the value of a 1 point move on 1 contract

Examples:
eMini S&P 500: $50
eMicro S&P 500: $5
eMini Nasdaq 100: $20
eMicro Nasdaq 100: $2

Stocks
The value will always be 1

Forex
Value of the Contract
Examples:
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.

Google Sheet Graphs Displaying 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.

Example of Hiding Columns in Google Sheets

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.

Arrow Designating How to Unlock Hidden Cells in the Trading Journal

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.

Example of Exposing Formula Columns in Trading Journal to Change Strategy Names

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.

Example of Hiding Columns in the Trading Journal

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.

Example of Linking Trade Photos to the Trade Journal

Next head back to your journal and highlight the corresponding trade photo number and hit the insert link button as seen below.

Displaying How To Link Trading Photos to Spreadsheet

Editing Formulas

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.


Conclusion

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.

SHARE THIS:

Adam

Adam

20 Year Professional Trader
Founder of JumpstartTrading.com
FULL BIO >

18 Comments

    1. 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.

  1. 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

  2. Hi Adam,

    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.

    1. 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.

  3. 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.
    (Sujith)

  4. 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.

    1. 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.

  5. 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?

Leave a Comment

Your email address will not be published. Required fields are marked *