Are the templates really free?

Yes. The Notion, Google Sheets, and Excel versions are all free to copy and keep, with no signup required to download them.

Notion, Sheets, or Excel — which should I pick?

Pick the tool you already use daily. Notion is best if you want browsable views and tags; Google Sheets is fastest to start and easy to share; Excel suits offline work and heavy customization. The trade log and dashboard are identical across all three.

Can I track crypto trades in these templates?

Yes — they include exchange, fees, and funding columns specifically so crypto trades log correctly. Just remember you have to look up fees and funding yourself, which is exactly the step TMM automates.

How do I auto-import trades instead of typing them?

Connect your exchanges to TMM with read-only API keys. Every trade then imports and calculates itself — no manual entry, no missed sessions, live PnL across all your accounts.

Is the template available in my language?

This page is available in several languages, but the template files themselves (Notion, Sheets, Excel) are English-only in this first version. The columns and formulas are language-neutral, so they work the same regardless of your interface language.

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

Below are three free trading journal templates — one for Notion, one for Google Sheets, one for Excel. Each comes pre-built with a trade log and an auto-calculating dashboard, so you copy it once and start logging trades in minutes.

All three are genuinely free and genuinely useful. They are also manual, and that matters more than it sounds — once you have one, see the spreadsheet-vs-automated section below to see what changes when your journal fills itself.

Notion trading journal template — duplicate to your workspace
Google Sheets trading journal template — make a copy
Excel trading journal template — download the .xlsx

Notion

A linked Trades database with filtered views and a live rollup dashboard.

Google Sheets

Make a copy straight into your Drive — no app, no extra account.

Excel

Same Trades and Dashboard tabs, same formulas, works fully offline.

Download the .xlsx

What every version includes

Each template ships with the same core trade log so your numbers stay consistent no matter which format you choose. The columns are:

Column	What it captures
Date	When the trade closed
Exchange	Binance, Bybit, OKX, and so on
Symbol	The pair or contract traded
Side	Long or short
Entry price	Your average fill on entry
Exit price	Your average fill on exit
Stop price	Your planned stop — feeds the R-multiple
Size	Position size in units of the asset
Leverage	Informational, defaults to 1
Fees	Trading fees, plus funding on perps
PnL ($)	Net profit or loss after fees — calculated
R-multiple	Result measured in units of risk — calculated
Result	Win, Loss, or BE — calculated
Setup tag	The pattern or reason you took the trade
Mistake tag	Left empty on clean trades
Notes	What you saw, felt, and learned

Notion trading journal template

The Notion version is built as a linked database, which is the format most people actually want. The trade log is a database with the columns above; switch to the gallery or board view to browse trades by setup, and the dashboard page pulls live rollups — total PnL, win rate, R-multiple — from the same database.

What you get inside: a Trades database, filtered views by win/loss and by symbol, a tags property for setups and mistakes, and a dashboard page with rollup properties already wired up. Add a row, the numbers move.

Google Sheets trading journal template

The Google Sheets version is the fastest to start with — no app, no account beyond the Google one you already have. Opening the link prompts you to copy the sheet straight into your own Drive. The original stays untouched; your copy is yours to edit.

Inside, the Trades tab holds the log and the Dashboard tab holds the formulas. Win rate is a COUNTIF over total trades; PnL totals and per-symbol breakdowns use SUMIF; the R-multiple column is computed from your entry, stop, and exit. Everything recalculates the instant you add a row.

Excel trading journal template

Prefer Excel, or trade offline? The Excel version mirrors the Google Sheets layout exactly, with the same Trades and Dashboard tabs and the same formulas (COUNTIF, SUMIF, and an R-multiple calculation) pre-built.

Download the .xlsx, open it in Excel or any compatible app, and start filling in the Trades tab. The dashboard handles the math. This file is English-only in v1 — the columns and formulas are all Latin-script and language-neutral, so it works the same regardless of your interface language.

Download the .xlsx

A filled-in example

Here is what one complete entry looks like, so the columns stop being abstract:

Date	2026-06-24
Exchange	Bybit
Symbol	BTCUSDT (perp)
Side	Long
Entry	62,400
Exit	64,900
Stop	61,200
Size	0.5 BTC
Fees	18.20 (incl. funding)
PnL	+1,231.80
R-multiple	+2.1R
Result	Win
Setup	Breakout retest
Notes	Entered on the retest, not the break. Held through one funding charge. Almost moved my stop — did not.

The number that teaches you something is the +2.1R, not the +1,231.80. Dollar PnL scales with account size; R-multiples are comparable across every trade you ever take, which is why the dashboard tracks both.

Spreadsheet vs automated trading journal

	Manual template	TMM (automated)
Logging trades	You type every fill by hand	Auto-imported from your exchanges
Crypto fees & funding	You look them up and add them	Pulled exactly, funding included
Live PnL	Only as current as your last entry	Realized + unrealized, always live
Multiple exchanges	One tab per account, manual totals	Aggregated across every connected account
Missed trades	Forget once and the data lies	Nothing is skipped — it syncs everything

The templates above work. They also have a ceiling, and you hit it faster than you expect. Manual journals fail in a predictable way: you log diligently for two weeks, miss a busy session, then a few more, and within a month the dashboard reflects a fiction. Crypto makes it worse — fees and funding payments quietly distort your true net PnL, and most people leave them out because looking them up by hand is tedious.

TMM removes the typing entirely. Connect your exchanges with read-only API keys and every fill imports automatically — fees and funding included — so the same dashboard you built by hand exists live, across all your accounts, without you logging anything. It computes PnL, win rate, and R-multiples from real fills, and it is free to start.

The template gets you journaling today. TMM keeps you journaling without the discipline tax.

Skip the spreadsheet

Auto-log every trade — TMM does this automatically.

How to start with this template

1Copy the template — duplicate the Notion page, copy the Google Sheet, or download the Excel file.
2Log each closed trade — entry, exit, stop, size, and fees; the PnL, R-multiple, and result columns calculate themselves.
3Review the dashboard weekly — check win rate, profit factor, and expectancy, and read the notes column for patterns.

Frequently Asked Questions

Trading plan Risk management Bybit