What is a trading journal and why do you need one?
A trader's memory is selective: winning trades feel like they were meant to work, losing ones feel like bad luck. A month later you can no longer honestly say how many times your favorite setup worked or at what time of day you make the most mistakes. A journal solves exactly that problem: it replaces impressions with data.
A journal does three jobs:
- statistics — win rate, average result in R and expectancy for each setup;
- finding mistakes — which rule violations keep repeating and what they cost;
- a library of situations — screenshots of past trades you can go back to when a similar picture shows up on the chart.
In our 2025 year-in-review post (in Russian), the author boiled down his advice to his beginner self to a formula: "discipline + statistics = results". You can't have statistics without a journal.
What should you record in a trading journal?
The minimum set of columns we use and recommend:
| Column | What to write | Why |
|---|---|---|
| Date and time | Day of the week and entry time | Find your best and worst days and hours |
| Session | Asia, Frankfurt, London, New York | See which session your setup works in |
| Instrument | GER40, NAS100, JP225 | Compare instruments |
| Direction and HTF bias | Long or short, and whether it matches the higher timeframe | Check what countertrend trades cost you |
| Entry factors | "test bisi 4h + 3m BOS + 0.5 OTE" | Group trades by setup |
| Entry, stop, target | Prices or points | Recalculate R and check stops |
| Risk, % | 0.3–1% | Make sure you stay within your limits |
| Result, R | +2R, −1R, 0R | Compare trades regardless of account size |
| Screenshots | Before entry and after exit | Learn from the chart, not from memory |
| By the rules? | Yes or no | Separate system errors from execution errors |
| Takeaway | One sentence | Turn experience into a rule |
It's handy to log entry factors as short tags, the same way we write them in our channel reports. After a couple of months, filtering by the tag "sibi 1h" will give you exact stats for that setup.
How to keep a trading journal: a routine
A journal only works if it's built into your trading day. Our routine:
- Before the session. Screenshot your plan: zones, liquidity, direction. That's your "before entry" column.
- Right after closing a trade. Fill in the numbers, take a screenshot of the result and write a one-sentence takeaway. While it's fresh, it takes five minutes.
- Once a week. Go over every trade from the week, including skipped setups. Answer three questions: what worked, what rules I broke, what I'm changing.
- Once a month. Calculate metrics by setup and session. Decide what to cut from your trading and what to do more of.
Skipped trades need their own entries. "Saw the setup, didn't enter because…" is valuable information: your best trades, the ones you're afraid of, are often hiding in what you skip.
Excel, Google Sheets or Notion: where should you keep your journal?
| Tool | Strengths | Weaknesses |
|---|---|---|
| Excel | Formulas, charts, works offline | Awkward for storing screenshots and notes |
| Google Sheets | Everything Excel does, plus phone access and sharing | Needs internet, slows down with thousands of rows |
| Notion | Tagged databases, screenshots, review pages | Weaker at calculations and charts |
| Journaling apps | Automatic trade import from your broker | Paid, and don't always support prop firms |
Our choice is Notion for reviews with screenshots and a spreadsheet for the numbers. In spring 2026 we posted a link to our Notion journal with a video walkthrough (in Russian) in the channel. But there's only one rule that matters: the best journal is the one you actually fill in every day.
Where can you download a trading journal template?
We're preparing a free Fix Pips journal template; it will live at /en/journal. It will include the columns from the table above, entry-factor tags and ready-made formulas for win rate, average R and expectancy. Until the template launches, build your own table from the list above: structure matters more than nice formatting.
What does a journal entry look like?
Here is a filled-in row for a real trade from our channel on October 21, 2026:
| Field | Value |
|---|---|
| Session | Frankfurt → London |
| Instrument | GER40 / DAX |
| Direction | Long, with the HTF bias |
| Factors | test bisi 4h + test 0.5 + DAX OTD (test VA + single print) |
| Result | Take profit, closed before the target |
| By the rules? | Yes |
| Takeaway | SMT with EU50 against the position was a valid reason to exit early |
Look at the last row. The takeaway isn't "good trade" but a specific observation you can test on your next trades.
What questions should you ask in a weekly review?
A weekly review takes 30–60 minutes. We go through the same list every time:
- How many trades followed the rules and how many didn't? How many R did each group make?
- Which setup performed best and which performed worst?
- Were there skipped trades that met the rules? Why did I skip them?
- Where did I exit earlier or later than planned, and what did that cost in R?
- Did I break my per-trade or daily risk limits?
- What is the one change for next week?
The last item matters more than all the others. One specific change a week adds up to more over a year than a dozen "I need to be more disciplined" resolutions.
How does a journal help with trading psychology?
Most emotional mistakes — revenge trading after a loss, fear of entering after a losing streak, sitting on winners too long — grow from the same root: the trader doesn't know their own stats and judges the system by the last three trades. A journal gives you something solid to stand on. When you can see that your setup has positive expectancy over a large sample, and that streaks of four or five losses have happened before and ended, the next stop is much easier to take calmly.
It also helps to record your state: whether you slept well, whether you were trading after a break, whether your mind was elsewhere. After a couple of months it often turns out that your worst trades happen under the same circumstances.
How does a journal help you find trades?
A journal isn't just a record of the past. A well-kept journal becomes a library of situations you can turn to in the middle of a session.
Trade from the channel
There were two plans that morning, a short and a long. Before entering, the author remembered a similar day, opened the journal and found it: May 18, also a Monday, a bearish narrative, Asia in accumulation, a manipulation at the Frankfurt open. The scenario repeated: a sweep of the Asian low, a 3m BOS, a 15m inversion — long.
Trade in the journal (RU)This only works if the journal has screenshots and a short description of the context. Numbers without a chart won't help you recognize a situation.
How should you review losing trades in your journal?
Every stop raises one question: did the trade follow the rules? If yes, it's a normal part of your stats, and a "by the rules" mark in the journal is enough. If not, you need a specific description of the mistake, not "bad luck".
Trade from the channel
After a strong selloff we expected a correction and got one, but price never reached the target. A sweep of the 30-minute fractal, a break of structure on the 3m, a test of a 3m BISI. The journal records a specific mistake: there was no second confirmation.
Trade in the journal (RU)Notes like "no second confirmation", "entry against a higher-timeframe zone" or "held past the first target" add up within a month to a list of your personal mistakes, each with its cost in R. That's the most useful document a trader can have.
What metrics should you track in your journal?
- Win rate — the share of winning trades. On its own it means little without R.
- Average win and average loss in R.
- Expectancy = win rate × average win − loss rate × average loss. If expectancy is positive over 50+ trades, the system makes sense.
- Maximum drawdown and the longest losing streak, so you know what to be ready for.
- Breakdowns: by setup, session, day of the week, instrument, and "by the rules or not".
The last breakdown is usually the most sobering: trades that break the rules almost always have negative expectancy.
How many trades do you need for meaningful stats?
Ten trades is randomness: any setup can produce five winners or five losers in a row. The minimum sample for cautious conclusions is about 50 trades under the same rules. For confident conclusions about a specific setup or session, you need 100 or more.
Hence the practical advice: don't change your rules more often than once every 30–50 trades. If you change the system after every bad week, your journal will never build up a sample, and you'll never know whether any of the versions actually worked.
Common trading journal mistakes
- Logging only winning trades. A journal without stops is an advertisement, not statistics.
- Filling it in after the fact once a week. Details and emotions fade within a day.
- Skipping screenshots. Without the chart, you can't review a trade a month later.
- Making the journal too complicated. Nobody fills in thirty columns. Start with ten.
- Not drawing conclusions. A journal nobody rereads is just an archive.
- Not logging skipped setups. Without them you can't see what fear of entering costs you or which trades you consistently miss.
- Counting in money instead of R. Changes in account size break the comparison between trades.
The journal is step eight in our trading learning plan and the best way to test the rules from our guide to risk management.
FAQ
Where can I download a free trading journal template?
The free Fix Pips journal template will be available at /en/journal. It includes the columns from this article plus formulas for win rate, average R and expectancy. Until it's live, build the table yourself from the column list below; it takes about 15 minutes.
Is Excel or Notion better for a trading journal?
Excel and Google Sheets are better for calculations and equity curves. Notion is better for screenshots, tags and written reviews. Many traders keep the numbers in a spreadsheet and the chart reviews in Notion. Consistency matters more than the tool.
How do I keep a trading journal if I don't take many trades?
Log the setups you skipped as well: what you saw, why you didn't enter and how it played out. Your stats build up faster that way, and you can also see whether fear is making you skip your best trades.
Should I journal my demo trades?
Yes, from day one. A demo journal shows whether your system works before you put money at risk. Moving to a live account makes sense after 50–100 logged trades taken under the same rules.
How often should I review my trading journal?
Briefly after every trade, in depth once a week, and a summary once a month. The weekly review matters most: a week gives you enough trades to spot a pattern while the mistakes are still fresh.
This material is for educational purposes only and is not investment advice. Trading financial markets carries a high risk of losing capital; past trades do not guarantee future results.