Free trading journal template for Excel

A ready-to-use spreadsheet for logging your trades and reviewing your performance. Download it, fill in your trades, and the key numbers calculate themselves.

Free download · No sign-up required · Excel & Google Sheets

What's inside the template

  • A trade log with date, symbol, direction, setup, entry, stop loss, take profit, size and exit
  • Automatic P&L, R multiple and risk % calculations
  • A summary sheet with win rate, profit factor and average R
  • A notes column for the lessons behind every trade
  • Example rows so you can see exactly how to fill it in
  • Works in Excel and Google Sheets — no macros, nothing to install

1. Log every trade

One row per trade, right after you close it. Entry, stop loss, exit and position size are all the template needs.

2. Review the summary

Win rate, profit factor and average R multiple update automatically, so you can see whether your edge is actually working.

3. Write down the lesson

The notes column is the real value. The patterns in your own words are what make you a better trader.

Outgrow the spreadsheet?

Norviq does everything this template does — automatically. Log trades in seconds, get a full performance calendar and stats, and grow alongside a community of retail traders. Free forever, no credit card required.