← Back
Free trading journal template
A real spreadsheet, downloaded directly — Excel, Google Sheets, and CSV. No email wall, no signup, no “template” that turns out to be a lead form.
What's inside
- Trade Log — date, symbol, side, quantity, entry, exit, stop, fees, then computed P&L and R multiple, plus setup tag, pre-trade thesis, an A–F grade, mistake tag, and lessons. Formulas are pre-filled for 500 rows — you only type the trade.
- Dashboard — win rate, net P&L, expectancy, profit factor, average R, and a per-setup breakdown that fills in as you tag trades.
- Honest math — every stat is denominated on closed trades only. An open position shows a blank P&L, not $0, and a trade without a recorded stop gets no invented 0R. (The same rules our product enforces.)
How to use it
- Excel: open the .xlsx and start typing on the first empty row. The three example trades show every formula working; delete them when you're ready.
- Google Sheets: File → Import → Upload → pick the .xlsx. Sheets converts the workbook and all formulas keep working. (The CSV is the plain log for anything programmatic — CSV can't carry formulas.)
- Notion: there's no one-click Notion file, and we won't pretend otherwise — create a table database and add the same columns (the CSV imports directly via Notion's CSV import; you'll rebuild P&L as a Notion formula:
if(prop("Side") == "SHORT", prop("Entry") - prop("Exit"), prop("Exit") - prop("Entry")) * prop("Qty") - prop("Fees")). - Weekly: the template earns its keep in the review, not the logging — once a week, sort by setup and read your own lessons column. That habit is the whole point.
When you'll outgrow it
A spreadsheet is genuinely fine under ~30 trades a month. Past that, manual entry becomes the reason journals get abandoned: at 100 trades a month you're doing 5–6 hours of data entry that broker auto-import does in zero.
TradeFlow Quantum is the same journal discipline with the typing removed — auto-import from 25+ brokers, the analytics this dashboard approximates (plus day-of-week edges, drift grading against your pre-trade plan, prop-firm rule tracking), for $15/month with a 7-day trial. The template is yours either way.
See what the automated version does →Questions
- Is the trading journal template really free?
- Yes. Both files download directly from this page with no email address, account, or card. TradeFlow Quantum is a paid trading journal ($15/month), and this template is the honest free alternative for traders who prefer a spreadsheet.
- Does the template work in Google Sheets?
- Yes. In Google Sheets choose File → Import → Upload and select the .xlsx file — Sheets converts the workbook and every formula (P&L, R multiple, win rate, profit factor, expectancy, per-setup stats) keeps working. The CSV variant is the plain trade log only, since CSV cannot carry formulas.
- How is P&L calculated in the template?
- Side-aware: LONG is (exit − entry) × quantity − fees; SHORT is (entry − exit) × quantity − fees. A trade with no exit shows a blank P&L — an open position is "no result yet", never $0 — and the R multiple divides realized P&L by planned risk (|entry − stop| × quantity), staying blank when no stop was recorded.