Free & printable

Trading Journal Template and Checklist

A trading journal only helps if you record every trade the same way. This page lists the fields you need, the key metrics, and a checklist for before, during and after a trade. The table is available as a CSV for Excel and Google Sheets, and you can print the checklist or save it as a PDF.

Download template (CSV)

Fields every trading journal needs

FieldWhy you need it
Date and timeShows when you trade better or worse.
Instrument and directionLong or short; stock, forex pair or crypto.
SetupThe name of your strategy, so you can compare setups later.
Entry, stop, targetThe plan before you trade. It defines your risk.
Position size and riskRisk in currency and as a percentage of your account.
Result in currency and in RR makes trades of different sizes comparable.
FeesCosts eat a noticeable share of profit across many small trades.
Plan followed (yes/no)Separates outcome from discipline. A loss that followed the plan is not a mistake.
Mood before the trade (1 to 5)Shows whether tiredness, anger or euphoria affects your results.
Screenshot and noteWithout a chart image you will not remember what you saw weeks later.

Key metrics

  • R-multiple: Result divided by the initial risk. A 200 profit on 100 risk is +2R.
  • Win rate: Share of winning trades among all trades.
  • Average R: The mean of all R-multiples. If it is positive, your system has shown an edge so far.
  • Expectancy: Win rate times average win in R, minus loss rate times average loss in R.
  • Maximum drawdown: The largest drop from your account's peak.

These numbers only become meaningful after many trades. With a few dozen entries they are a first hint at most.

Checklist for every trade

tradinglogapp.com

Before the trade

During the trade

After the trade

Once a week

Template or app?

A spreadsheet is enough to start. If you want to log quickly on the go, see metrics automatically, and keep your data on your device, use the app. TradingLog logs trades offline, shows win rate and R-multiple, and exports to JSON or CSV.

Try TradingLog

Free for 10 trades. No account. Pro is a one-time purchase.