What is in the trading journal template
The template is a CSV file with 25 columns and two example rows: one planned futures trade that followed the rules and one impulse trade that didn't, so you can see how each column is meant to be filled in. Delete the examples and start with your next trade. The columns follow the three moments that matter: before the trade, after it, and the review.
| Column | What to write |
|---|---|
| Before the trade | |
| Date, Account, Symbol, Market | Keep each account (live, evaluation, paper) apart from day one. |
| Direction, Setup | Long or short, and the setup name from your playbook. "No setup" is a valid, telling entry. |
| Thesis | One or two sentences on why price should move your way. |
| Entry, Stop, Target, Size, Risk ($) | Exact prices, written before you click. Risk is what you lose if the stop is hit. |
| Checklist complete (Y/N) | Were all of your conditions true? Trades with N are usually the expensive ones. |
| After the trade | |
| Exit, Fees ($), P&L ($) | The facts. For futures, P&L uses the contract multiplier (MES is $5 a point, ES $50). |
| R multiple | P&L divided by the risk you planned. +2.0 means you made twice what you risked. |
| Changes during trade | Moved stop, moved target, early exit, and why. |
| The review | |
| Followed plan, Entry timing | Y / Partly / N, and Early / On time / Late. |
| Emotion, Mistake tag | One word each, from a short fixed list, so you can count them later. |
| Good trade? | Judge the decision, not the result. A planned loss can be a good trade. |
| Lesson, Screenshot link | One specific lesson, and a chart screenshot for the weekly review. |
How to open it: in Excel, use File, Open and pick the CSV; in Google Sheets, use File, Import, Upload. Then freeze the header row and add a filter so you can sort by setup or mistake tag.
Rather not maintain a spreadsheet? Nummius is a free trading journal that does all of this for you: the pre-trade plan locks when you click, the review asks these questions, R and statistics are calculated, and Plutus, the AI coach, finds the habit that costs you most. Free forever, no card.
Use the free trading journal insteadHow to keep a trading journal
Almost every trader has started a trading journal. Very few have kept one that changed how they trade. The usual story goes like this: a spreadsheet with entry, exit and P&L, updated for a few weeks, then skipped after a bad day, then forgotten.
The problem is not discipline. It is that most journals record the wrong things at the wrong time. A list of results tells you what happened. It cannot tell you why, and "why" is the only part you can change.
This guide shows how to keep a trading journal that does improve your trading: what to write before the trade, what to write after it, how to review it, and how to turn a pile of entries into one habit you fix at a time.
Why most trading journals fail
Three mistakes kill most journals:
- They start after the trade. If you only write things down once the trade is closed, your memory has already rewritten the story. A loser becomes "the market was manipulated", a lucky winner becomes "I read that perfectly."
- They grade on P&L. A trade that followed every rule and lost is a good trade. A trade that broke every rule and won is a bad one, and the most dangerous kind, because it teaches you to break rules. A journal that only scores profit rewards the wrong behaviour.
- They never get reviewed. Writing is half the job. Without a regular review, a journal is just a diary.
Fix those three and the rest is detail.
Step 1: What to write in a trading journal before every trade
The most valuable line in a trading journal is written before the trade exists. Before you enter, write down:
- Setup: which pattern from your playbook is this? If it isn't in your playbook, that is worth knowing too.
- Thesis: one or two sentences on why price should move your way.
- Entry, stop and target: exact prices, not "around the low".
- Position size and risk: how much you lose, in dollars and in R, if the stop is hit.
- Checklist: the conditions that must be true. For example: higher-timeframe trend agrees, level marked before the open, confirmation candle closed, risk under 1% of the account.
Then lock it. The point of a pre-trade plan is that you cannot quietly edit it later. If you move your stop during the trade, the journal should show the original stop and the new one, so the review is honest.
In Nummius Journal this is the pre-trade plan: entry, stop and target are drawn on the chart, size comes from your risk, and the plan locks when you take the trade. Pre-trade planning is free on the Duelist plan.
Step 2: Record the trade itself
During and right after the trade, capture the facts:
- Actual entry and exit prices and times
- Fees, slippage and partial fills
- Whether you took the trade only when the checklist was complete
- Anything you changed mid-trade (stop moved, target moved, early exit), and why
Typing fills by hand is where most journals die. Import them instead. Most platforms export trade history as CSV, and a good journal reads it directly. Nummius imports from Sierra Chart, Tradovate, Interactive Brokers, thinkorswim, Webull, TradingView exports, any CSV, or a screenshot (imports are part of Core).
Step 3: Review every trade against the plan (the trade journal review)
This is where a trading journal earns its keep. After each trade, answer a short, fixed set of questions. Keep it the same every time so the answers can be compared:
- Did I follow the plan? Yes, partly, or no.
- Was the entry on time? Early, on time, or late.
- Did I manage the trade as planned? Stop and target untouched, or changed.
- Was the size right? Within the risk rule or not.
- What did I feel? Calm, rushed, fearful, revenge, bored. One word is enough.
- Was this a good trade? Judge the decision, not the outcome.
- What was the mistake, if any? Name it in a few words, like "chased the breakout".
- One lesson for next time. Specific and actionable: "Scale a third at 1R into the 10:30 pause", not "be more patient".
Nummius uses an 8-step review like this and grades your judgement, not your P&L, so a well-executed loss can score better than a lucky win. Unlimited post-trade reviews are free.
Step 4: Tag setups, mistakes and emotions (your trading psychology journal)
Tags turn notes into data. Use a small, fixed vocabulary:
- Setup tags: opening range break, VWAP reclaim, pullback to the 20-day average
- Mistake tags: early entry, moved stop, oversized, no setup, revenge trade
- Context tags: trend day, range day, news day, first hour
- Emotion tags: calm, rushed, fearful, revenge, bored. Over a few weeks these turn your journal into a trading psychology journal: you can see which emotions come before your worst trades.
Resist inventing a new tag for every trade. Ten tags used consistently beat a hundred used once.
Step 5: Run a weekly review
Once a week, set aside 30 minutes and look at the week as a whole. The questions that matter:
- Which setup made money, and which lost it? Look at average R per setup, not just win rate.
- What is my most expensive mistake? Add up the R lost to each mistake tag. Often one habit (no-setup trades, early entries, moving stops) accounts for most of the damage.
- Did I follow the plan more or less than last week? Plan adherence is the leading indicator. P&L follows it.
- What were the key numbers? Win rate, average win and average loss in R, expectancy, largest drawdown.
Expectancy is worth understanding: it is (win rate × average win) − (loss rate × average loss). A setup that wins 40% of the time at +2.5R and loses 60% of the time at −1R has an expectancy of +0.4R per trade. A journal that tracks R makes this a one-line calculation.
Step 6: Fix one habit at a time
The review will usually show several problems. Do not try to fix them all. Pick the single most costly one, write it as a focus for the next week ("No trade without a marked level"), and check every trade against it. When it sticks, move to the next.
This is the part that a journal alone rarely does well, and where an AI coach helps. In Nummius, Plutus reads your journal and answers questions like "what is my most costly pattern?". It turns a bad day into one focus to hold for seven days, so you work on one habit at a time instead of a list of ten.
Step 7: Journal backtests and paper trades too
If you practise, through backtesting, bar replay, paper trading or a trading simulator, journal those trades the same way as live ones. Two reasons:
- Practice habits are live habits. If your practice entries are early three times in five, your live entries usually are too. Seeing the same mistake in both is strong evidence that it is a habit, not bad luck.
- You can compare. A setup that works in backtests but fails live points at execution, not the setup.
In Nummius, trades from backtesting and bar replay and duels in the Arena trading simulator get the same review and feed the same coach as live trades, and practice stays separate from your live results.
Trading journal template in Excel or Google Sheets, or a trading journal app?
If you want to start today on paper or in a spreadsheet, the free template at the top of this page has every column. In short:
| Before the trade | After the trade | Review |
|---|---|---|
| Date, symbol, direction | Actual entry and exit | Followed plan? (Y / partly / N) |
| Setup (from playbook) | Fees and slippage | Entry timing (early / on time / late) |
| Thesis (1–2 sentences) | Result in $ and R | Mistake tag |
| Entry, stop, target | Changes made mid-trade | Emotion (one word) |
| Size and risk ($, R) | Screenshot of the chart | Good trade? (judge the decision) |
| Checklist complete? | One lesson |
A spreadsheet is a fine place to start. Move to a dedicated trading journal once typing fills by hand or calculating R becomes the reason you skip entries.
Trading journal FAQ
Is a futures trading journal different?
The method is the same, but the numbers need care: P&L depends on each contract's multiplier, and risk is best tracked in R per trade. See the futures trading journal page for how Nummius handles futures and prop firm accounts.
How long should a journal entry take?
Two minutes for the plan, two for the review. If it takes longer, you will stop doing it. Imports and templates keep it short.
Should I journal losing trades differently?
No. Use the same questions for every trade. The point is comparison, and losing trades are usually where the lessons are.
How do day traders keep a trading journal?
Plan and review every trade, but keep the review to the fixed questions and do the deeper analysis in the weekly review. Day traders benefit most from tags, because patterns only show up across many trades.
Is there a free trading journal?
Yes. The Nummius Duelist plan is free forever with no card and includes pre-trade plans, unlimited post-trade reviews, playbook criteria, habit scores and a Trading Score. Core adds imports, deeper analytics and unlimited coaching, with a 14-day free trial.
The short version
- Write the plan before you click, and lock it.
- Import the facts instead of typing them.
- Review every trade against the plan, and grade the decision, not the result.
- Tag consistently, review weekly, and add up what each mistake costs.
- Fix one habit at a time.
- Journal practice trades the same way as live ones.
A trading journal is not a record of your trading. Kept this way, it is the tool that changes it. Start your trading journal free on Nummius.
Trading involves risk. This article is education, not financial advice.
Keep your journal in Nummius. Pre-trade plans, an 8-step review, habit scores and Plutus, the AI coach, free on the Duelist plan. Trading futures? See the futures trading journal.
Start your free trading journal