How to Create Your Own Trading Journal in Excel

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Why create a trading journal?

A key tool most successful traders use is a Trading Journal. The reason we keep journals is so we can easily go back and review past trades and figure out what went right, what went wrong, and attempt to figure out why. There are many different ways that you can keep your own trading journal. In this post, I'm going to show you how I started keeping my trading journal in excel, how you can do the same, and how you can even download this template for free!

Designing a Trading Journal

My trading journal template came about after reading "Trading in the Zone" by Mark Douglas. One of the suggestions in his book is to keep a trading journal of all of your operations in the market so that you may perform a post analysis of exactly what you did and why you did it. He stressed the importance of recording this information as soon as possible, preferably immediately. The reason is because the longer we wait to record our decisions, the more time we give ourselves to justify them. A good journal will capture your actions as close to raw as possible. In designing my trading journal template, I opted to use Excel because it provided me with a large workspace where I can keep just about everything I wish to track, plan with, analyze, etc.. And the ability to use formulas to automate some of the processes and make it more efficient.

100% free trading journal

How to use the trading journal

(with pictures)

Trading Journal Template 1

Trading Journal in Excel

 

ACTIVITY TAB

Trading Journal in Excel

 

QUOTES TAB

Trading Journal in Excel

 

TRADING PLAN HISTORY TAB

Trading Journal in Excel

 

NEEDS IMPROVEMENT TAB

Trading Journal in Excel

 

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Here are more articles you may like

Claim Your Free Guide Today

Give us your email and we will give you the tools to change your life. 

FREE 7 DAY EMAIL COURSE

Learn about Early Entry Points & much more...

© ChartYourTrade | Contact us: website@chartyourtrade.com

Disclaimer: All communication from FindLeadingStocks.com is general in nature and for educational and general informational purposes only. Under no circumstance should it be considered personalized investment advice. All our work is general in nature and not specific to any one person. All the information on this site and/or that originates from us, or any of our partners or affiliates, is for educational and informational purposes only and is NOT a recommendation to buy or sell anything. To avoid any conflicts of interest, we do not have a working relationship with any of the companies mentioned in our work. Furthermore, we may have a long, short, or no position in any, or all, of the names that appear in our work and they may change at any time without notice. Investing and trading in capital markets or using margin carries a high level of risk and may not be suitable for all investors. Leverage can work against you as well as for you. Before you decide to invest or trade in capital markets you should carefully consider your investment objectives, level of experience, and risk appetite, among other factors. The possibility exists that you could sustain a loss of some, all, or more of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with capital markets, investing/trading, and seek specific investment advice from an independent financial advisor and other professionals. Remember all the information we provide is for educational and general informational purposes only and is subject to change without notice.

Terms of Service | Privacy Policy