Skip to content

Guide · 2 min read

What should a trading journal include? (Free template)

A trading journal should record, for every trade: the date, stock, timeframe, reason to buy, entry price, stop-loss, target, lots, fees, exit price, result after fees and a short lesson. Reviewing it monthly shows your win rate, average win against average loss and profit factor. Download the free template below.

Last updated

Download the free trading journal template

Download the trading journal template (CSV). It opens in Excel, Google Sheets or Numbers, and includes one example row you can delete.

Which columns should a trading journal have?

Column Why it matters
Date in / date out Shows how long you actually hold
Stock Name or code
Timeframe Short, mid or long-term: never mix their results
Reason to buy The setup or fundamentals, written before buying
Entry price What you paid per share
Stop-loss Where the idea is wrong
Target Where you plan to take profit
Lots Position size (1 lot = 100 shares)
Fees Brokerage, clearing fee and stamp duty, both sides
Exit price What you sold at
Result (RM) After all fees
Followed plan? Yes or no: the honest column
Lesson One line you can use next time

How do you review your journal?

Once a month, work out four numbers from the closed trades:

  • Win rate = winning trades ÷ all closed trades
  • Average win and average loss, in RM
  • Profit factor = total RM won ÷ total RM lost (after fees). Above 1 means winners paid for losers.
  • Fees paid: if it’s a big share of your results, you may be trading too often.

Then read the Followed plan? column. Trades where you broke your own rules usually explain most of the damage. The How my system works page explains these numbers in more detail.

What’s the fastest way to start?

  1. Practise in the paper trading simulator, which tracks win rate, profit factor and fees for you.
  2. Export your paper trades with Download CSV and paste them into the template.
  3. Use the position size calculator and fees calculator to fill in lots and fees before each real trade.

The XpertStocks stock tracking dashboard (coming soon) will keep this journal for you automatically. Join the waitlist for early access.

This guide is education only. It is not a recommendation to buy or sell any security.

Frequently asked questions

Is the trading journal template free?

Yes. It is a free CSV file that opens in Excel, Google Sheets or Numbers. No sign-up is needed.

How often should I review my trading journal?

A short look after every trade and a proper review once a month works for most people. Look for patterns in your losses, not just your wins.

Should I journal paper trades too?

Yes, but keep them separate from real trades. The XpertStocks paper trading simulator can export its trades as a CSV for this.

What is the most important column?

The reason to buy and the lesson. Prices tell you what happened; your notes tell you why, which is what you can improve.

Want stock tracking for your own portfolio?

Join the waitlist to get early access to the XpertStocks dashboard: holdings grouped by short, mid and long term, a win/loss scorecard, dividends and a watchlist with your own target prices.