Trading journal: what to record and how to analyze it

You have probably started a trading journal before. A spreadsheet with twenty columns, filled in seriously for ten days, then forgotten. The problem was not your motivation. It was the journal: too many fields to fill in, and no method to get anything out of it.

This guide gives you the 14 fields that actually matter, the format that fits the way you trade, and above all a 5-step review method, with a worked example, to turn your journal into decisions.

What is a trading journal?

A trading journal is a record of each of your trades, enriched with the context of your decision. Your broker’s history tells you what happened. Your journal tells you why.

It holds two kinds of information:

1. The trade data: date, asset, direction, size, entry and exit price, stop loss, result.
2. The decision context: the setup you followed, whether you stuck to your plan, your emotional state when you entered.

Your platform already produces the first part. The second part exists nowhere but in your journal, and it is what explains your results.

Why keeping a trading journal changes your results

Because you only fix what you measure. That is not a coaching slogan: it is a solid research finding.

In 2016, Benjamin Harkin and his colleagues published a meta-analysis of 138 studies covering 19,951 participants in the journal Psychological Bulletin. The conclusion: monitoring your progress significantly improves goal attainment, and the effect is stronger when the monitoring is written down or made visible. A trading journal is exactly that.

The stakes are real. According to ESMA, the European markets regulator, between 74% and 89% of retail accounts lose money on CFDs, with average losses of €1,600 to €29,000 per investor depending on the country (figures published in 2018). In France, the 2014 study by the AMF, France’s financial markets authority, covering 14,799 Forex and CFD clients, found 89% of them lost money. We break down the causes of these losses, figure by figure, in our analysis of why traders lose money.

And the margin between losing and winning is thin. The study by Brad Barber, Terrance Odean and their coauthors on Taiwanese day traders (Journal of Financial Markets, 2014) shows that less than 1% of them make money in a predictable, consistent way after fees.

When the gap between losing and winning comes down to a few repeated mistakes, the trader who can see them has an edge over the one who cannot.

What to record in a trading journal: the 14-field template

A good journal takes less than a minute per trade. Any longer and you will stop. Here are the 14 fields that are enough, ranked by usefulness.

The four fields in bold carry almost all of the journal’s value. Your MT4, MT5, cTrader or TradingView history already contains the first nine: do not type them again if you can import them.

Two rules to keep the journal useful:

1. A closed list of setups. Three to five names at most, always spelled the same way. “Breakout”, “H1 breakout” and “break” in the same column make any analysis impossible.
2. Fill in “plan followed” honestly. Nobody but you will read your journal. A convenient “yes” is false data that will cost you money.

Excel, Notion or an automatic journal: which format should you choose?

The best format is the one you will still be filling in three months from now. What matters is not the number of features but how long data entry takes and how easy the analysis is.

If you take a few swing trades a month, a spreadsheet is plenty. If you scalp or day trade, manual entry becomes the main reason people quit: automate the numbers and save your energy for the context.

How to analyze your trading journal: the 5-step method

Analyzing a journal means splitting your trades into groups and comparing the groups with each other. Once a month, block 30 minutes and follow these five steps.

1. Check that your data is complete. Every trade of the month is there, each one has a setup, an R and an answer to “plan followed”.
2. Compute your overall numbers. Number of trades, win rate, net result, profit factor and maximum drawdown. That is your baseline.
3. Split by setup. For each setup: number of trades, win rate, net result. One setup can drag everything else down.
4. Split by plan discipline and by time of day. Compare “plan followed” trades with the others, then your results by time slot and by number of trades in the day: that is the measure that reveals overtrading.
5. Write down a single decision. One rule to apply next month, not five. The month after, you check whether it worked.

A worked example of a monthly review

Take a trader with a €10,000 account who risks 1% per trade, so 1 R = €100. They took 40 trades during the month (illustrative example).

The month is positive, +€580, and the trader could stop there. The breakdown tells a different story. The 8 off-plan trades have a 25% win rate and an average loss of €130, or 1.3 R: the stop was widened along the way. They cost €540.

Without them, the month would have ended at +€1,120, almost double, with a profit factor of 1.66 instead of 1.23. The decision for the month writes itself: no trade without a setup from the closed list.

A word of caution: 8 trades is not much to judge a setup. But off-plan trades, taken outside any strategy, have nothing to validate. To compare two real setups with each other, wait until you have 20 to 30 trades per setup before concluding.

The questions to ask at every review

The mistakes that make a journal useless

Most journals fail for the same reasons:

• Too many columns. Every extra field lowers the odds you will fill it in tomorrow. Start with the 14 fields above and add only what you actually reread.
• Recording only winning trades, or only losing ones. A selective journal distorts every statistic. Every trade, no exceptions.
• Filling it in from memory at night. An emotion written down three hours later is not the same emotion. Write it right after entering.
• Never rereading it. Without a review, a journal is just a history that takes longer to produce. The monthly review is the part that pays.
• Changing five rules at once. If you change everything, you will never know what worked. One decision per month.

Keeping your journal without manual entry using TradeIA

The numbers in a journal are re-entry work: your broker already has all that data. TradeIA imports your MetaTrader 4, MetaTrader 5, cTrader or TradingView history directly and automatically computes your win rate, profit factor, drawdown and results by asset, by day and by hour.

For each trade, you can add the setup, notes, a screenshot, the mistakes you made, your emotional state and whether you followed your plan. The analysis also flags recurring patterns, such as a position size that grows during a losing streak or a risk that varies too much from one trade to the next.

The tool does not do the review for you. It saves you the time spent on data entry and calculations so the 30 minutes each month go into making decisions.

In short

A useful trading journal fits in 14 fields, and four of them do most of the work: setup, risk in R, plan followed, emotion. It takes a minute to fill in and gets reviewed once a month by splitting your trades by setup, time of day and plan discipline. Start tonight with your next trade, and block 30 minutes at the end of the month for your first review.