Free download · Excel & Google Sheets · no email

Free trading journal template for Excel and Google Sheets

A ready spreadsheet: one row per trade, and it counts your win rate, profit factor and drawdown — and what each mistake costs you.

Download for Excel (.xlsx)Russian version

.xlsx · 5 sheets · formulas work in Excel and Google Sheets

What is inside

  • Trades

    One row per trade. Net, R, balance and drawdown fill in by themselves; drop-downs for side, setup, mistake, emotion and rules.

  • Summary

    Win rate, average win and loss, break-even win rate, expectancy, profit factor, max drawdown — and your result when you kept your rules against when you broke them.

  • Cost of mistakes

    Every mistake tag with the number of trades and what they cost in total and per trade.

  • Lists

    Your setups, mistakes and emotions; the drop-downs read them, so new tags appear everywhere.

  • How to use

    The steps, the formulas and how to open it in Google Sheets.

What to fill in for each trade

Date, account, symbol, side, lots
What the platform shows
Entry, exit, stop
Prices; the stop is the one you planned
Risk $
What you would lose at the stop — the base of R
Gross P&L, commission, swap
From the trade history; net adds them up
Setup, mistake, emotion
One tag each, picked from the lists
Rules kept
Yes or No — did the trade follow your rules?

What to write in a trading journal, with an example entry →

Open it in Google Sheets

  1. Download the .xlsx above.
  2. In Google Sheets: File → Import → Upload, and pick the file.
  3. Choose «Create new spreadsheet». The formulas and drop-downs come with it.

When a spreadsheet stops being enough

  • Typing every trade: a busy week is 50 rows, and a missed one skews every number.
  • Partial closes, commissions and swaps: the spreadsheet only knows what you type.
  • Questions it cannot answer quickly: which hour or setup loses, what each habit costs this month.

Questions

›Is the template really free?

Yes. Download it — no sign-up, no email. It is yours to change.

›Does it work in Google Sheets?

Yes. Import the .xlsx (File → Import → Upload): every formula is one Google Sheets supports, and the drop-downs come with it.

›Can I import my MT4/MT5 history into it?

Not automatically — a spreadsheet has no import. You can paste rows from the report by hand, or upload the report to the journal, which reads it as it is.

Same numbers, without typing a single trade

The journal brings every trade in from MT4/MT5 and counts all of this — by day, setup and mistake. Free for one account.

Start free — no card
Start free — no card