The trading journal: the tool that turns mistakes into skill

If you want to improve at any activity, you have to measure what you do. In trading, almost nobody does: you remember the trade that went well, forget the ugly one, and end up thinking you're better (or unluckier) than you really are. The trading journal is the simplest and most powerful tool to break out of that loop. It's boring, it takes discipline and... it's what separates those who improve from those who repeat the same mistakes for years.

What it's really for

• Seeing the real data: win rate, average R, drawdown: not feelings.
• Discovering your patterns: at what hours you lose most, which setups make money, when you break the rules.
• Keeping emotions in check: writing how you feel before and after makes you aware.
• Learning from mistakes: reviewing screenshots you see what you hadn't noticed.
• Knowing whether you have an edge: only with a documented sample can you say whether your method works.

What to record for each trade

The bare minimum:

1. Date, time and session.
2. Instrument and direction (long/short).
3. Reason for entry in one sentence (which setup, which conditions).
4. Entry price, stop loss, take profit.
5. Size and risk as a % of the account.
6. Expected risk/reward ratio.
7. Result in pips, money and R.
8. Screenshot of the chart before entry and after exit.
9. Whether you followed the plan (yes/no) and, if not, why.
10. State of mind before, during, after (1-5 or one word).

For a richer analysis you can add: timeframe, setup type, market conditions (trend/range), scheduled news, any mistake made.

How to do it in practice

You don't need expensive software: a spreadsheet (Excel, Google Sheets) is perfect. One row per trade, one column per data point. Some tips:

• Fill it in right away, not at the end of the week: details get lost.
• Use fixed categories (e.g. setup types: "bounce off support", "breakout", "pullback to average") so you can filter.
• Save the screenshots in a folder with the date.
• Be honest. The journal works only if it also records the ugly trades and rule violations.

How to analyse it: the weekly review

Once a week (say on Saturday), dedicate 30 minutes to a review:

1. Statistics: number of trades, win rate, average R of wins and losses, expectancy, profit factor, the week's drawdown.
2. By setup: which setup type did best? Which is losing?
3. By hour/day: in which slots do you do better or worse?
4. Plan violations: how many times and why? How much did lack of discipline cost?
5. Emotions: are there recurring patterns (for example mistakes after a loss)?
6. One single improvement for the following week: not ten, one.

The key metrics to calculate

Typical mistakes in keeping the journal

• Filling it in only when you win.
• Not recording emotional states.
• Changing rules midway through a sample.
• Never rereading it: a journal that's never reread is just an archive.
• Wanting to measure everything and giving up after two weeks: better a few columns kept up than twenty forgotten.

In short

• The journal shows you the real data of your results and patterns.
• Record every trade: reason, levels, size, R, screenshots, plan adherence and emotions.
• A spreadsheet is enough; consistency matters more than tools.
• Do a weekly review: statistics, setups, hours, violations, emotions.
• Each week eliminate one mistake: improvements compound.

Practical exercise

1. Create your journal sheet today with the columns listed.
2. Record your next 10 demo trades, with screenshots and state of mind.
3. Set a fixed weekly 30-minute appointment for the review.