Description: Stock Portfolio Tracker is Investment Moats attempt at creating an online spread sheet that will let a stock investor 1) Monitor your stocks in a portfolio. Choose and Download an Investment Trading Journal Template. Choose and download an investment trading journal template so that you can start making one right away. To start, choose among a list of investment trading journal templates included in this article. After choosing, hit the download button so you can edit it immediately.

Analysis for:Stocks, Options, Futures, Forex, Spread Betting, CFDandCryptocurrency traders.

Where Trades Come to Life!

For over a decade, the Trading Journal Spreadsheet has been turning raw trading data in to refined evaluation analysis. Track every move you make in multiple (personalized) performance tracking categories.

Get TJS, and watch your trades come to life.

Better trading, through better Analysis!

A TJS for ALL Traders!

Whether you trade single or multiple markets, the TJS has a version for you: Stocks, Options, Futures, Forex, Spread Betting, or Cryptocurrencies.

We’ve made every effort possible to ensure your TJS experience exceeds your expectations!

Meet Doug and his new Trading Journal.

TJS Elite Support

To get the support you deserve from a Trading Journal, it should come straight from the developer. We created the TJS; we stand behind our work and are here to assist you with any questions by email, phone or remote support.

Analysis is only half of what we provide!

Trading Journal Spreadsheet ™

We created tons of amazing features and functionality in each TJS product.

TJS Home Menu

Here’s a glimpse of the TJS Home Menu, where you’ll find all sheets neatly displayed in an aesthetically pleasing and organized format.

Each time you open the file, you’ll be greeted by the Home Menu asking, “where would you like to go?” You’ll have quick & easy access to all of the TJS product sheets, and even direct links to blank pages that you can use to create or consolidate your own worksheets.

Direct Support and Contact links are also included in your TJS Home Menu!

TJS Analysis

Customize & Analyze what’s important to “you”.

  • “At-a-Glance” display.
  • Expectancy figures for all categories.
  • Know your strength & weaknesses, and compare Strategy performance.
  • Track your mistakes (w/ cost & frequency).
  • Send to Mentor / Instructor function.
  • Filter the top producers from each category to find your “Ultimate Trade Scenario“.
  • View all Analysis by: Cumulative, Yearlyor Monthly, and by Grossor Net P&L.

TJS Trading Log

User friendly, aesthetic design, and a plethora of great features and functionality, including:

  • Fixed header with cumulative results.
  • Equity-curve graph (with filter).
  • P&L Candlestick graph.
  • R-multiple Scatter Plot graph (except Options)
  • Embedded instructional tips.
  • Drop-down menus / Input error detection
  • Journal & Notes section.
  • Comprehensive, per trade analysis.
  • Trade Review, for each trade.

There’s much more! View the TJS Gallery / Info page.

Let's find out more

TJS and Microsoft Excel.. 'Bringing Your Trades to Life!'

Easy to Use

We created the TJS to be user friendly with design features you’ll appreciate, like Text-button links to view various sections of the Trading Log, and Arrow-button links to get you back to where you came from. Just say no to scrollbars!

Why Excel?

The De-facto standard for spreadsheet software. Excel has the Data Power, Data Visualization, Customization, Advanced Features and Coding capabilities necessary to “Bring Your Trades to Life”. When choosing a Trading Journal, go with a proven platform developer and company that’s been devoted to trade analysis (for over a decade).

For (both) Windows and Mac Excel users

The current TJS product can be used by all Windows or Mac HighSierra (or greater) operating systems.

Mac users will also need the latest Excel 2016 (or greater) or Office 365.

TJS Reviews

Traders just can’t stop talking about the Trading Journal Spreadsheet.
A few words from some of the happy TJS users around the globe.

Best Value for Money

As someone who has been trading for over 10-years, I have to say that this is the best value for money trading spreadsheet I’ve come across.

~Lance Beggs / AU / YourTradingCoach.com

Best Trade Analysis Tool

You have developed the best trade tracking tool and I’m confident that traders looking to increase their performance and forecasting should use TJS.

~Randall Bal, Olympian / USA

Development Factors

My development to the trading level I’ve achieved is based on three factors: Mentorship, a Trading Plan, and use of the Trading Journal Spreadsheet.

~Pål-Harald Uthus, Chief Analyst / NORWAY

Great Customer Support

The Trading Journal Spreadsheet is the standout tool in trade tracking and analysis. It’s excellent value for money with great customer support.

~Stuart Young / GlobalTradingTools.com / AU

In the Trading Room

There’s so many great features to your journal, our trading room members are enjoying the benefits where it counts, the bottom line – Profit!

~Kam Dhadwar / UK / theTradingFramework.com

Does It All

This spreadsheet does it all for you. It tracks and analyzes everything you want and need. This is money well spent!

~Trisha / USA / EasyEminiTrade.com

Plan It: Customize the TJS Analysis sheet to “track” what’s most important to you and your trading business.

Trade It: While gaining experience in the markets, record everything you do in the TJS Trading Log.

Analyze It: The TJS Analysis sheet automatically displays all pertinent stats (at a glance), for your review.

Identify Strengths & Weaknesses: The TJS alerts you to which categories are producing either a positive and negative expectancy.

Improve: You’ll soon have the knowledge needed to: trade confidently, perfect your plan, increase / decrease risk amounts, progress naturally as a seasoned trader, and become a standout trader.

Trade It
Identify Strengths & Weaknesses

Let's Analyze your trades, shall we?

Not ready Yet?

Let’s view the Gallery and Info page

Inquiries, Feedback, Assistance

Our team spends hundreds of hours testing financial products and services each year. Our reviews are honest and unbiased. If you use the links on this page to open an account, we may be compensated. Thank you for your support! Read more.

Using a trading journal is one of the most under utilized tools by beginner stock traders. Recapping trades to break down what went right or wrong will help prevent future mistakes and improve returns down the road.

In this guide, I will break down the five best trading journal available today for analyzing stocks, options, futures, forex, and cryptocurrency trades. After the summary, I will cover some tips for success with examples from my own personal trading for those who are new to journaling their trades.

Best Trading Journals for 2020

  • TraderSync – Best overall trading journal
  • Tradervue – Best for professional traders
  • Trademetria – Best for simple design and included quote data
  • Power E*TRADE – Best overall trading simulator
  • Edgewonk 2.0 – Best for software download
  • Build your own – Best for Microsoft Excel users

1. TraderSync Trading Journal

Supports: Stocks, options, futures, forex, cryptocurrency
Pricing: Free (unlimited trades, manual entry), Pro ($29.98/mo), Premium ($49.95/mo), Elite ($79.95/mo)

Put simply, TraderSync takes the crown because of its features and outstanding usability. When David (the founder) reached and I started testing TraderSync, it felt like David had taken our Trading Journal tool and rebuilt it for 2020. Beyond a slew of features that match or exceed other journals (including trade importing), it is the tool’s design that impresses me most. Along with our own journal (see No 3 below), TraderSync is the only other journal that I actively use myself. Oh, and it is the only journal to include iOS and Android mobile apps. Bottom line, for an easy to use and overall feature rich replacement for excel, TraderSync delivers.

2. Tradervue

Best for professional traders

Supports: Stocks, options, futures, forex
Pricing: Free (100 stock trades/mo), Silver ($29/mo), Gold ($49/mo)

Tradervue was one of the very first trading journals to come online alongside ours and I’ve known Greg (the guy behind Tradervue) for years. Tradervue isn’t the easiest to use, but it has the best broker importing support out of all the trading journals I’ve ever tested, and Greg keeps the site in good shape. It is popular among hedge funds and professional institutions because it is so reliable and includes a variety of features, including automatic trade marking on charts and community sharing.

3. Trademetria

Supports: Stocks, options (single-leg only), forex, futures, cryptocurrency
Pricing: Free (30 trades/mo), Basic ($14.95/mo), Pro ($24.95/mo)

Trademetria is very basic as far as what data is tracked and what you can analyze; however, it does include real-time quote data for paid subscriptions. This allows Trademetria to serve as effectively a watch list tool as well as a trading journal. Arguably, that’s what your online stock broker is for, but nonetheless it is a unique feature. It also supports cryptos, which I’m sure will make some traders very happy.

4. Power E*TRADE

Best overall trading simulator

Supports: Stocks, options, futures
Pricing: Free ($0 trades)

As the head of research for StockBrokers.com, I have spent thousands of hours testing online trading platforms. Hands down, Power E*TRADE offers the best trade simulator I have ever used. With streaming data, a fully featured trading journal for notes, and seamless order entry, Power E*TRADE is terrific for both beginners and fully experienced traders looking to tune their trading strategies. Available only to US residents, E*TRADE requires no minimum deposit and the platform is immediately available to use. Naturally, E*TRADE wants to earn your business so you fund the account and use the brokerage for your $0 stocks and options trading. See also: best online stock brokers 2020.

5. Edgewonk

Supports: Stocks, forex, futures, CFDs, spread betting
Pricing: $169

Edgewonk is downloadable trading journal software that offers pretty deep analysis of your trades. The upside is the customization possibilities pending you enter in detailed notes and tags for each trade. Also, since it is software, you only need to pay for it once; there is no monthly subscription. The downside is that the broker import tool support is nearly non-existent for US based stock traders and is instead focused primarily on a handful of popular forex brokers and platforms like MetaTrader4 (MT4).

6. Build your own!

Best for Microsoft Excel users

Supports: Anything and everything
Pricing: Free with Microsoft Excel 🙂

To get you started, here’s a free trading journal excel spreadsheet template to use, which includes all of the basics alongside a handful of advanced data points. If you have a great spreadsheet template that you’d like to share with readers of the site, please email me!

Trading Journals are for Post Trade Analysis

Reviewing the film is critical part of professional sports, and investing is no different. Taking a screenshot of the stock chart after the trade is completed, plotting buy and sell points, writing down your notes recapping the trade, and tweaking trade rules thereafter all fall under the post trade analysis.

Trading journals provide you an easy way to figure out what went right, what went wrong, and look back at your trade history. There is simply no better way to improve over time.

Steps to a Journaling a Trade

You can improve your success rate, and ultimately make more money from your investing if you put in the time to conduct post-trade analysis. /download-apk-gta-5-mobile-for-android.html.

  1. Log the trade details – This includes the ticker symbol, trade date, buy price $, total shares, sell price $, return $, return % (at a minimum). Other great data points to track include stop price, risk, and commission spend.
  2. Download a stock chart and mark it up – Mark it up with your buy and sell points alongside any trendlines, support, resistance, etc. Then, mark this chart with the trade info and archive it.
  3. Write your trade notes – Either on the chart itself, in your excel journal, or on paper, write down what you did right, wrong, and overall recap the trade in your own words. I personally use Evernote.
  4. Reflect back on trade data, chart, notes – This is the true “reviewing the film” exercise; identify potential bad habits, make rule tweaks, identify areas for improvement, and overall set the focus for the next trade.
  5. Archive for later use – Once you have reviewed the trade start to finish and gone through the motions of a proper recap, save your trading journal and move the trade to a folder on your computer. I use Dropbox and organize trades by ticker and date, e.g. “AAPL 050619”.

Why You Should Tag All of your Trades

Tagging your trades means marking the strategy you used to make the trade. By tagging each trade, you can assess performance over time and identify whether or not the strategy you are using is successful.

Any good trading journal will allow you to filter performance by tag to view your biggest winners, losers. By looking back every so often, you can identify areas of improvement and tweak your trade rules for that strategy.

Here’s an example of a day trade I made a few years back for Tesla (TSLA). Notice how it is tagged with “Day Trading 3.1”. By tagging your trades, you can easily create a new strategy, take a few trades (with a smaller position size to start), and assess the results thereafter.

Why Day Trading isn’t for Me

As an example of how using a trade journal correctly can be effective, over a year and a half of day trading in my spare time I found that I wasn’t profitable.

To track my progress, I started each strategy as “1.0”, then updated the trade tag each time I made a new rule adjustment so I could see how I improved over time. More specifically, I started with “DayTrading 1.0”, then updated it to “DayTrading 2.0”, and so on and so forth.

In total, I made 444 trades and had a net return of +$4,662.56. I risked on average $93.38 per trade (the average spread between my buy point and my stop price). I had eight total iterations of the strategy over the course of 18 months.

At first glance, +$4,662.56 doesn’t sound so bad. However, one key metric was being left out of the equation. Commissions.

With commissions factored in, my net return was a whopping +$86.37. I had roughly $25,000 allocated to the strategy, so clearly I under performed the overall market averages and would have been better off passive indexing.

Forex Trading Journal Spreadsheet Free Download

Despite the blow to my pride, without tagging my trades and using a trading journal, I never would have been able to determine day trading wasn’t right for me. And, even better, thanks to the tagging and strategy honing, I was able to learn A LOT about myself as a trader.

Trying day trading sprouted numerous other strategies that I use now. I also didn’t lose any money, only time.

In life and especially in the market, you can’t beat free education!

How to use your Trading Journal to Build Strategies

Here are a few tips for success that I’ve learned over the years:

  • Have clear rules for each strategy – I use Evernote to journal all my market thoughts, ideas, research, etc. This allows me to organize each strategy with clear rules so I can be consistent with my trades. Consider having preset profit targets, objectives, position management rules, and make sure to tag each trade!
  • Use numerical identifiers – Start your seed strategy with “1.0” and refresh the tags each time you adjust your rules so you can accurately track performance. You can progress to “1.1” or “2.0”, etc. You’ll be amazed when you compare the trades and performance of each iteration.
  • Challenge yourself to improve across the board – Don’t just analyze the net return of each strategy iteration, look also at mistake %, time committed overall, trade frequency, and your overall emotions to assess true success. For example, day trading requires far more trades, time, and stress than buying and holding long.

In Van Tharp’s book, Trade Your Way to Financial Freedom, he advocates finding the right strategy for YOU. The more you test different strategies and learn about yourself, the more successful you will be over time. For me, day trading just isn’t the right fit.

Trading Journal Spreadsheet Free Download

Final Thoughts for Maintaining a Successful Trading Journal

What variables do successful traders use when logging trades in their trading journal? Here are 11 to always include:

  1. Stop Price $ – The Stop Loss price ($) which can be a physical stop loss order or a mental stop. Cutting your losses short is one of many crucial keys to successful investing.
  2. Strategy – Always tag each trade with the strategy used.
  3. Risk $ – This is the amount of capital being risked on the trade. So, if you buy 100 shares at $100, and your Stop is at $99, then you are effectively risking $100 on the trade. Risk can also be expressed as an “R” multiple (Van Tharp principal), and is a concept that has truly changed the way I approach trading.
  4. Risk % – The percent of capital risked on the trade. Referencing the previous example, the total risk would be 1% ($10,000 invested / $100 being risked).
  5. Target Price $ – Back to our example of buying long at $100, if we set our target price at $110, that means our goal is to hold the stock until it reaches at least $110. Once we reach out initial target price, we can check back in and consider trimming our position to take some profits, sell the entire position, or hold the position and set a new, higher price target.
  6. Return $ – The number everyone loves to see, which hopefully is a profit and not a loss. If our 100 shares of stock we bought at $100 reaches our $110 target price and we sell our full position to lock in profits, then we would realize a return of +$1,000 ($10 per share x 100 shares).
  7. Return % – The dollar return converted into a percentage. Sticking with our example example, selling at $110 would yield a +10% return ($1,000 / $10,000).
  8. Return “R” – Applying R multiples, we convert the Return $ into “R”. Using this same example, if we had risked $100 (1R), and made $1,000, then our return would be +10R.
  9. Mistake? – Did you make a mistake or break a rule with this trade? If yes, then you mark the trade as a mistake. Mistake tracking is one of the more underused, yet very powerful variables. By logging mistakes, you force yourself to replay the trade in your mind and reflect back on what went right and/or wrong.
  10. Notes – Not necessarily a variable, but writing notes when reflecting on the trade is important to learning from each trade. What went right, what went wrong, what you were thinking when buying, selling, etc. are all examples of what can be journaled.
  11. Risk / Reward Ratio – The risk-reward ratio measures how much your potential reward is for each dollar you risk on the trade. Using the same long 100 shares at $100 trade example, with $99 as our stop and $110 as our target, our risk / reward ratio would be 1:10. As long as the trade works out at least once every 10 tries, we will still make money (excluding trade costs).

Bottom Line

Regardless if you build your own trading journal or use one of the services recommended above, there are endless ways you can go about conducting post trade analysis.

What matters most is that you take the time to use and maintain a trading journal. Without one, you are setting yourself up for failure.

Have a question about trading journals? Tweet this post and tag me, @InvestorBlain!

Check out our free Trading Journal here on the site and join over 20,000 other investors!

$0 commissions + Best trading technology

Voted best trading platform, TradeStation gives you the power and technology of an award-winning online trading platform with full access to stock, ETF, options, futures trading and more! Plus support when you need it most. Open an account today

Read Next: