Free Trading Journal Template (Excel, Google Sheets & Notion)

A good trading journal template isn’t a pretty grid — it’s a specific set of columns chosen so you can judge your process, not just your P&L. This free trading journal template is a single CSV you can download and open in Excel, Google Sheets, or Notion in under a minute, with no email and no card. It doubles as a plain trade log template, but ships with the columns most free versions skip — R-multiple, planned risk/reward, and a simple “did I follow my plan?” flag — so you review how you traded, not only whether it paid. A spreadsheet is a legitimate way to start, and this one is built to teach you what actually matters.

What separates a real template from a glorified P&L log

Most downloadable templates — and most trade log templates — track outcome: symbol, entry, exit, profit. That tells you whether a trade worked, never whether you traded well, and over a small sample those are different things. A serious template adds three layers most skip: risk (so a win on a blown stop reads as the mistake it was), plan (what you intended before the outcome was known), and review (the lesson, graded on process). Get the structure right and the analytics — expectancy, win rate, average R — fall out almost for free. For the full why-each-field rationale, see our guide on what to put in a trading journal.

The columns that matter: R-multiple, planned R:R, and rule-adherence

Three columns turn a logbook into a journal. R-multiple normalizes every result to units of risk: a +$300 win on $100 of risk is +3R; the same dollars on $300 of risk is only +1R — the only honest way to compare a position-sized portfolio. Planned R:R records what you expected going in, so you can judge selectivity. And Plan Followed — a simple Yes/No/Partial — records whether you actually traded the plan you wrote: right size, real stop, planned entry, no chasing. Sort by Plan Followed = No and your worst trades usually cluster there — often more useful than any indicator, and the column most templates omit entirely. Size each trade to a fixed one-unit risk with our position size calculator.

Trading journal template for Excel, Google Sheets, or Notion

Excel is best for offline control and pivot-table math: Data → From Text/CSV, format the price and date columns, then add R-multiple as =(Exit−Entry)/(Entry−Stop) for longs (flip the sign for shorts) and a PivotTable grouping average R by Setup. Google Sheets is the fastest start and easiest to share: File → Import → Upload, choose “Replace current sheet,” and freeze the header row. Notion suits you if you think in pages: create a database, Import the CSV, and convert Setup and Plan Followed to Select properties for one-click filtering — though Notion has no native R or expectancy math, so those stay descriptive there. Compute planned R:R from your target and stop with our risk/reward calculator. Whichever you choose, add a filter view for Plan Followed = No and an AVERAGE on R-Multiple — a working discipline dashboard in about ten minutes.

How to fill it in so it actually helps

Log the trade while the setup is still live, not from memory at the end of the week — that’s when the honest data exists. Fill Plan Followed before you know the outcome, so the result can’t color your answer. Record your stop even when there wasn’t one; “no stop” is data, and usually expensive data. After the close, grade the setup on how clean it was, not on whether it paid — a textbook A that hit its stop is still an A — and write one lesson, flagging whether it’s a repeat. Once you have roughly 30 trades, average the R-Multiple column by Setup to get your trade expectancy formula in practice, then sort by Plan Followed and look for the pattern that surprises you. That single sortable view is the entire point of journaling.

Where a spreadsheet stops scaling

A CSV template is the right place to start — building the columns forces you to decide what matters. But it stores numbers and throws away the one thing that explains the trade: the chart you actually traded. It also breaks on scaled and partial fills, every R is hand-math you maintain, and nothing scores your discipline for you. That’s a feature of starting simple, not a flaw — it’s something you outgrow. Our trading journal vs spreadsheet guide covers exactly where that handoff happens.