Excel trading journal: free template and its limits

Kévin KOUSSOUGBE
· 2 min read

A trading journal on Excel or Google Sheets is a very good starting point: it costs nothing and it forces you to look at your trades. Here are the columns that really matter, the statistics to pull from them, and the limits that push most traders to move on.

The columns to keep

Create a "Trades" sheet with one row per closed position:

  • Open date and time, close date and time
  • Instrument (EURUSD, XAUUSD, NAS100…)
  • Direction: buy or sell
  • Position size (lots)
  • Entry price, stop-loss, take-profit, exit price
  • Result in account currency
  • Risk in % of capital at entry
  • Result in R (result divided by initial risk)
  • Setup: the name of the configuration you traded
  • Note: one sentence on how you felt or on the mistake, if any

The "Setup" and "Note" columns are the ones beginners skip, and they are the most useful for improving.

The statistics to calculate

On a second sheet, use formulas to compute:

  • Win rate: winning trades divided by total trades.
  • Average win and average loss, then their ratio.
  • Expectancy per trade: (win rate × average win) − (loss rate × average loss).
  • Maximum drawdown: the largest drop from a peak to a trough of your capital.
  • Result by weekday and by hour: this is often where you discover your costly time slots.

The limits of Excel

  1. Manual entry takes time. After a few weeks, trades get skipped, and an incomplete journal distorts every statistic.
  2. Copy errors. One wrong price and the result in R is wrong.
  3. No automatic detection. Excel will never tell you that you lose more often after two consecutive losses: you have to build each analysis yourself.
  4. No imported history. If you already have months of trades on MetaTrader, retyping them is discouraging.

When to move to an automatic journal

If you trade on MT4 or MT5, your history already exists in the platform. An automatic journal imports it in seconds, calculates the statistics above and flags repeated mistake patterns. You save the entry time and you analyze a complete history.

Tradeora does exactly that: you import your MT4/MT5 history, and the statistics, weekly review and recurring mistakes are calculated for you. The trial is free for 14 days, no credit card required.

To get started well, also read how to keep an effective trading journal on MT4/MT5.

This content is educational and is not investment advice. Trading involves a risk of capital loss.