Here is the failure mode. A trader opens a spreadsheet, adds columns for date, pair, direction and profit, fills it in for three weeks, then stops because it tells him nothing. Of course it tells him nothing. Every one of those columns already exists in his account statement. The journal duplicated the broker's records and skipped the only data the broker cannot capture: what he was thinking when he clicked, and whether that reason was any good.
A journal earns its keep when it makes the invisible part of trading visible. That means writing before the entry, not after the exit.
The pre-trade fields
Write these while the trade is still hypothetical, because once you are in a position your memory of why you entered starts editing itself in real time. Four lines is enough.
The setup name comes first. If you cannot name it in two words, using a vocabulary from your own trading plan, you probably do not have a setup. "London breakout retest" is a setup. "Looked bullish" is a feeling with a chart attached.
Then the invalidation: where the stop goes and what price action would prove the idea wrong. Then the target and the resulting ratio, which is the number that decides whether the trade is worth taking at all. A setup that only offers 0.8 to 1 has to win an uncomfortable share of the time before it breaks even, which is the arithmetic behind risk to reward ratios. Then risk in percent of the account, not in lots, because lots mean nothing across different stop distances.
| Field | When | What it exposes later |
|---|---|---|
| Setup name | Before entry | Which of your setups actually pays and which you keep taking out of boredom |
| Entry reason, one sentence | Before entry | Whether you traded a plan or a reaction to a candle |
| Stop and target levels | Before entry | Moved stops, cut winners, targets set where price was never going to reach |
| Risk as a percent | Before entry | Size creep after wins and size cuts after losses |
| Chart screenshot | Before entry | The context you will not remember in six weeks |
| Exit reason | After close | Plan followed, plan abandoned, or an exit invented mid-trade |
| Rule break, yes or no | After close | The single most useful column in the sheet |
The screenshot is not decoration
Capture the chart at entry with your levels drawn on it, and capture it again after the exit. Six weeks later the numbers in a row will mean nothing to you, but the picture will bring the whole session back. Pattern recognition is visual, and a folder of a hundred annotated setups trains your eye faster than any amount of reading about support and resistance.
Name the files by date and setup so they sort themselves. This sounds trivial until you try to answer the question "show me every failed breakout I took in March" and discover your screenshots are called Screenshot 2026-03-14 at 09.41.22.
The column that does the real work
Add one binary field: did I follow my own rules, yes or no. Not "was it profitable". A rule-following loss is a good trade. A rule-breaking win is a dangerous trade, because it teaches you that breaking rules pays, and you will do it again with a larger position at a worse moment.
Sort by that column at the end of the month and the picture is usually brutal. Traders who think they have a strategy problem often have a compliance problem: the strategy is fine and they take it correctly six times out of ten. Everything else is improvised. This is where revenge trading shows up in the data, clustered in the twenty minutes after a loss.
Do not compute your own profit and loss by hand. Pull it from the account statement. A journal with hand-typed results drifts from reality within weeks, and once the numbers disagree with the broker you will stop trusting the whole sheet.
Reviewing it so it changes something
Weekly, spend twenty minutes on behaviour. Read every rule break, look for what they have in common, and pick one thing to do differently next week. One. A list of eight corrections is a list you will abandon by Wednesday.
Monthly, look at structure instead. Group by setup and by session and check where the money went. It is common to find that one setup carries the account and another quietly gives it back, or that everything you take in the first thirty minutes of the New York session is negative. That is actionable in a way "trade better" never is. It also tells you whether your drawdown is coming from ordinary variance or from a specific habit.
Be careful with small samples. Twelve trades of one setup is not evidence, it is a hint. Give it forty before you delete anything from your plan, and be honest that a run of losses on a sound setup feels identical to a broken setup while you are inside it.
Spreadsheet or software
A spreadsheet with the fields above beats any app you do not open. Start there. The moment manual entry starts costing you more than five minutes a day, or you begin skipping trades because logging is tedious, move to a dedicated tool that imports from your platform and lets you tag trades in bulk. We compare the options in trading journal apps.
Whichever you pick, keep the pre-trade note manual. The value is in writing the sentence, not in storing it. An importer can pull your fills, your commissions and your holding time. It cannot tell you that you entered because you were annoyed about missing the move an hour earlier, and that is the entry you most need to read back to yourself on Sunday.
"Write the reason before you click. If the sentence embarrasses you while you are typing it, that is the journal doing its job before the market has to."
— Alex Onta, Executive Director, SINGUARD
Key Takeaways
- Log setup, reason, stop, target and risk percent before entry; the statement already holds the outcome.
- A yes or no rule-break column reveals more than any profit metric in the sheet.
- Review weekly for behaviour and monthly for structure, and change one habit at a time.
- Annotated screenshots at entry and exit train pattern recognition better than rows of numbers.
Frequently Asked Questions
What should a trading journal actually contain?
The setup name, the reason for entry written before you clicked, the planned stop and target, the risk in percent, a chart screenshot, and after the exit the reason you closed and whether you followed the plan. Profit and loss comes from your statement, so it does not need to be typed by hand.
How often should I review my journal?
Weekly for behaviour and monthly for structure. The weekly pass looks for rule breaks and repeated mistakes while you still remember the sessions. The monthly pass looks at whether a setup or a session is consistently costing you money, which needs a larger sample than a week provides.
Is a spreadsheet good enough or do I need journal software?
A spreadsheet is enough for most traders, and the habit matters far more than the tool. Dedicated journal apps earn their place when you trade often enough that manual entry breaks down, since they import trades from the platform and tag them automatically.