Psychology

Trading Journal Template: What to Track and How to Review

A complete trading journal template – the 12 fields to log per trade, the weekly review protocol, and the mistakes that turn journals into graveyards.

Published Updated 11 min read NEOM Funded Editorial NEOM Funded Research
Trading journal spreadsheet open next to a chart showing annotated trades
A journal is only useful if you review it. A spreadsheet you never open is a diary of regret.Own work

01Why a journal is the highest-leverage habit in trading

Anders Ericsson's 1993 study on expertise – the paper that launched the "10,000 hours" idea – showed that the quantity of practice alone does not produce mastery. The practice must be deliberate: aimed at specific sub-skills, accompanied by immediate feedback, and continuously recalibrated based on that feedback. For traders, a journal is the feedback loop.

Without a journal, every month is a fuzzy impression of "I think I did OK". With a journal, you have the raw data to answer concrete questions: which setup has the best R-multiple? Which instrument costs me most in slippage? When in the session do my execution errors spike? Those are answerable only when you have logged the data to support them.

A second function: the journal disciplines the trader. Knowing you will have to write one honest line about a trade changes the trades you take. Many marginal setups that would have been taken on a whim do not get taken once the trader has to justify them in writing ten minutes later.

02The 12 fields every trade entry should have

You can use a spreadsheet, a Notion database, Edgewonk, Tradervue, or a plain text file – the tool matters less than the fields. Size each trade first with a position-size calculator so the risk-dollar and R-multiple fields you log are accurate. The twelve below are the ones that pay back the time you spend on them. Fewer than twelve and you lose resolution on execution-vs-plan analysis; more than twelve and most traders abandon the journal within a month because the friction becomes too high.

A rule that experienced prop traders follow: if a field has not driven a single behaviour change after two months of logging, delete it. A journal is a living tool – prune it.

12-field trade log template
FieldExampleWhy it matters
1. Date & time2026-04-18 09:42 ESTReveals session-of-day performance skew
2. InstrumentEUR/USD (or MES, BTC/USDT)Per-symbol edge analysis
3. Setup nameBull engulfing at 50-EMAEdge analysis by strategy
4. SideLong / ShortDirectional bias audit
5. Planned entry1.0820Comparison vs actual – slippage & discipline
6. Actual entry1.0821Measures chasing
7. Stop (price & $)1.0800 / -$200Risk taken
8. Target (price & $)1.0860 / +$400Planned reward / R ratio
9. Actual exit1.0852 / +$320Reality vs plan
10. R-multiple+1.6 RNormalised outcome
11. Execution rating4/5Subjective self-grade on discipline
12. One-line lesson"Held through the pullback as planned."Forces reflection

03The qualitative entries that matter as much as the numbers

The numeric fields answer "what happened". The qualitative fields answer "why". Three additions pay back strongly:

  • Pre-trade emotion (1–5). Calm = 1, mildly anxious = 2, chasing = 4, tilted = 5. Track this field for a month and you will find – as most traders do – a strong correlation between high emotion and low execution rating.
  • Screenshot. Annotate entry, stop, target, exit. Future-you reviewing the trade at the weekend needs the visual, not just the numbers.
  • Planned vs actual. Did you hold to target? Did you move the stop? Did you add to the loser? The gap between your trading plan and your executed behaviour is the single most actionable data point in the entire journal.

04The weekly review: a 60-minute protocol

Journaling without reviewing is busywork. Book a fixed 60-minute slot every Saturday or Sunday and run this protocol:

  1. 0–10 min – numbers recap. Total R, win rate, expectancy per setup, average R win vs average R loss. Note any outlier trade.
  2. 10–25 min – best trade of the week. Why did it work? Did you follow the plan? Could the size have been larger? Replicate the conditions in your notes.
  3. 25–40 min – worst trade of the week. Was the loss the result of a broken setup (edge failed, acceptable loss) or broken discipline (moved stop, sized too large)? The two demand different responses.
  4. 40–50 min – "plan vs actual" audit. How many trades matched your pre-written plan? Any trades you took that you did not plan? Any plans you refused to execute?
  5. 50–60 min – one commitment for next week. Single, specific, measurable. Not "trade better" but "do not move any stop away from entry this week".

05Monthly and quarterly aggregate metrics

The weekly review catches execution errors fast. The monthly and quarterly views catch strategic drift.

  • Monthly. Expectancy per setup, R-multiple distribution, equity curve. Any setup with < 20 trades in the month is statistically noisy – do not drop it based on a month of data. Track it and let another month accumulate.
  • Quarterly. Strategy-level retrospective. Which setups have the sample size and expectancy to be trusted? Which are statistical noise? Which should be retired or scaled? This is the layer at which an evaluation-style prop-firm trader decides whether to keep the current book or pivot.
  • Annual. Equity curve, Sharpe (or Sortino), maximum drawdown, and the single most-valuable habit formed this year. A concise 500-word write-up becomes your trading CV for yourself.

06Tools: spreadsheet vs dedicated platform

The trade-off is friction vs depth.

  • Google Sheets / Excel. Free, infinitely customisable, zero vendor lock-in. The down-side: data entry is manual, which many traders give up on after four weeks.
  • Notion / Obsidian. Good for the qualitative side – screenshots, notes, linked setups – but weaker for aggregate analysis.
  • Tradervue / Edgewonk / TraderSync. Paid platforms that import trades directly from broker statements, auto-compute expectancy and R-multiple, and support pattern tagging. Pricing $20–40/month in 2026. Worth it once you are taking 20+ trades/week.
  • Custom code. A Python notebook that reads broker CSVs into a pandas DataFrame and charts expectancy by setup is a one-weekend project for a programming trader. Maximum control, zero recurring cost.

The best journal is the one you actually fill in. Start with a spreadsheet; upgrade only if the data volume exceeds what the spreadsheet handles cleanly.

07Five common mistakes that turn a journal into a graveyard

  1. Journaling only losers. You need the winners to identify what works. A journal that is 80 % losing trades creates a selection bias toward self-criticism.
  2. Too many fields. Twenty-five fields per trade is aspirational; you will abandon the journal within a month. Twelve is the sweet spot.
  3. Writing before reviewing. Dumping raw data without reflection is data collection, not learning. The review is the forcing function.
  4. No pre-trade plan. If you do not write down what you intended before the trade, you cannot measure the gap between plan and execution – the most important field in the journal.
  5. Rating every trade 5/5. Self-grading honestly is hard. If your execution ratings don't include 1s and 2s, you are either perfect or lying to yourself.

08Connecting the journal to psychology

Terrance Odean's 1998 study documented the disposition effect: traders sell winners too early and hold losers too long. That effect is invisible from inside the trade; it is glaringly obvious across 100 journal entries. Tracking "planned exit" vs "actual exit" across a quarter will show you, explicitly, how much money you leave on the table by booking winners too soon or how much you bleed by refusing to accept losers.

The journal is also where you turn a bad day into a learning event instead of a spiral. Writing the post-mortem of a losing day forces cognitive re-engagement, and the act of committing the lesson to writing measurably reduces the probability of repeating the same mistake in the following week. See the trading psychology guide for the full framework.

Sources & further reading

Citations are checked against primary regulators and academic sources. External links open in a new tab; we're not responsible for third-party content.

  1. The Role of Deliberate Practice in the Acquisition of Expert Performance Ericsson, Krampe & Tesch-Römer – Psychological Review 100(3), 1993 · accessed Apr 18, 2026
  2. Are Investors Reluctant to Realize Their Losses? Terrance Odean – Journal of Finance 53(5), 1998 · accessed Apr 18, 2026
  3. Enhancing Trader Performance (2006) Brett N. Steenbarger – Wiley · accessed Apr 18, 2026
  4. Behavioral Finance: The Second Generation CFA Institute Research Foundation · accessed Apr 18, 2026

Frequently asked questions

How long should I spend on the journal each day?

Five to ten minutes for the end-of-day log entries. Then a 60-minute weekly review. Anything beyond that is probably overfitting – writing about trading instead of improving trading. The weekly review is where the edge is built.

Should I journal every trade or only the meaningful ones?

Every trade, during your first six to twelve months. Once you have a sample size per setup of 100+ trades, you can switch to logging only "exceptional" trades (best wins, worst losses, and any trade that broke the plan). Until you have that sample size, logging selectively creates a biased picture of your edge.

Is a screenshot really necessary?

It is the single most valuable qualitative field. Numbers tell you the outcome; the annotated chart tells you the context – where price was, what the setup looked like, which level was being tested. Two months later, the screenshot lets you re-evaluate the trade with fresh eyes. Every serious prop-firm trader I know keeps them.

What should I do if I realise I cheated on my plan?

Log it honestly – that is the entire point of the "planned vs actual" fields. Self-deception is the failure mode; accurate recording is the correction. If the gap is persistent, consider shrinking the book: reduce risk per trade by half until discipline is restored. Then scale back up.

Can I automate trade logging?

You can automate the quantitative fields. Platforms like Tradervue import executions from broker statements and fill in price, size, P&L and time automatically. You cannot automate the qualitative fields: pre-trade emotion, execution rating, lesson. Those require you, the trader, to write them – and the writing is where the learning happens.

How do I keep the habit of reviewing?

Calendar block it. Same day, same time, every week. Treat it as part of the job, not as optional homework. Most traders who "don't have time for a review" spend three times as long scrolling Twitter about trading. The review is the trading.

Start Today

Pass the Evaluation Up to $150K –Start in Minutes

Pass one evaluation. Trade a simulated funded account. Earn up to a 90% Reward Coefficient on your simulated performance. Receive your Performance Reward in ~8 hours on average.

  • One-time fee
  • Refundable on second Performance Reward
  • No subscription