How to Create a Trading Journal (and What to Track)
A trading journal is the single highest leverage tool most traders never use properly. It is a structured record of every trade you take and, just as importantly, the thinking and the emotion behind it. Done well, a journal turns your trading from a blur of wins and losses into a body of evidence you can actually learn from. Done poorly, or not at all, you are left guessing about why your results look the way they do.
The hard truth is that most traders either never start a journal or abandon one within a couple of weeks. They log a few trades, find the process tedious, see no immediate payoff, and quietly stop. Then they go back to trading on feel and wonder why the same mistakes keep showing up. This guide is built to prevent that. It covers what a trading journal really is, why most of them fail, exactly what to track, the metrics that matter, how to review your entries, and how to turn the whole thing into a measurable edge rather than a chore.
What a trading journal actually is
Most people think a trading journal is a list of trades. That is only half of it, and it is the less valuable half. Your broker already keeps a list of your trades. What your broker does not keep is the reasoning, the context, and the emotional state that produced each one. That second layer is where almost all the value lives.
So think of a trading journal as having two layers. The first layer is the objective record: what you traded, when, at what price, in what size, and how it turned out. The second layer is the subjective record: why you took the trade, what the market looked like, what you were feeling, and how well you executed your plan. The objective layer tells you what happened. The subjective layer tells you why. You need both, but if you only ever build the first layer you will never understand your own behavior, and behavior is what determines whether you keep your gains or give them back.
A good journal answers questions like these over time. Which setups actually make me money, and which ones only feel exciting? What time of day do I trade well, and when do I just give back profits? What happens to my results after a loss? Which emotions show up right before my worst trades? Those answers are invisible in a P and L statement. They become obvious in a well kept journal.
Why most trading journals fail
Before getting into what to track, it is worth understanding why journaling so often falls apart, because the failure modes are predictable and avoidable.
The first reason is that people make it too complicated. They build a giant spreadsheet with forty columns, try to fill in every field for every trade, and burn out within days. Complexity is the enemy of consistency. A journal you keep imperfectly every day beats a perfect journal you abandon after a week.
The second reason is that they only log results, not behavior. If your journal is just entries, exits, and profit and loss, you have rebuilt your broker statement with extra steps. There is nothing in it to learn from beyond the numbers you already had.
The third reason is that they never review it. A journal you write but never read is a diary, not a tool. The value of journaling comes almost entirely from the review, from spotting patterns across many trades. Logging without reviewing is like recording game film and never watching it.
The fourth reason is that the payoff is delayed. Journaling does not improve today's trade. It improves next month's trading by showing you the patterns you cannot see in the moment. Traders who expect an immediate reward quit before the real benefit arrives. Knowing this in advance helps you push through the early weeks when it feels like busywork.
The fix for all four is the same. Keep the capture simple enough that you will actually do it daily, make sure you capture behavior and not just numbers, and commit to a regular review where the patterns reveal themselves.
What to track: the core trade data
Start with the objective layer. This is the data that describes the trade itself. For every trade, capture the following at a minimum.
Record the instrument or symbol you traded, the direction (long or short), your entry price and entry time, your exit price and exit time, your position size, and the result in both money and as a multiple of your risk. Include fees and commissions, because over a high volume of trades they matter more than most people admit.
The single most useful objective metric here is your result expressed in R, which is the multiple of the amount you risked. If you risked one hundred dollars on a trade and made two hundred, that is a plus two R trade. If you lost the hundred, that is a minus one R trade. Thinking in R instead of dollars normalizes your trades so you can compare them regardless of size, and it keeps your focus on risk rather than on the dollar amount, which is where discipline tends to break down.
This core data is the foundation. It is necessary, but on its own it is not enough to make you a better trader. It tells you the score without telling you how the game was played.
What to track: the context
The next layer is context. This is what was happening around the trade and why you took it. Capture the setup or strategy you were trading, so you can later separate your real edge from your random trades. Note the market conditions, whether it was trending, ranging, volatile, or quiet, because most strategies work in some conditions and struggle in others. Write down your rationale in a sentence or two: why did you take this specific trade at this specific moment?
Context is what lets you answer the question that actually improves your trading: not did I win, but should I have taken this trade at all? A losing trade that perfectly followed your plan in the right conditions is a good trade with a bad outcome. A winning trade you took on impulse in the wrong conditions is a bad trade with a lucky outcome. Without context you cannot tell the two apart, and you will end up reinforcing the lucky bad trades and doubting the disciplined good ones.
If you trade a specific market, your context fields can get more specific. Futures traders often track the session and the product, since the cash open trades nothing like the afternoon. Our futures trading journal guide goes deeper on this. Forex traders track the session overlap and major news, which our forex trading journal guide covers. Crypto traders track volatility and whether they were chasing a move, which is the focus of our crypto trading journal guide.
What to track: the behavior
Here is the layer almost every journal skips, and it is the most important one. Behavior is what separates traders who improve from traders who repeat the same mistakes for years.
For each trade, capture your emotional state before, during, and after. Were you calm, anxious, bored, overconfident, frustrated, or fearful? Note whether you followed your plan or broke it, and if you broke it, how. Did you enter early? Did you move your stop? Did you size up because you were sure? Did you exit out of fear rather than at your target? Be honest. The journal only works if you tell it the truth, even when the truth is embarrassing.
This behavioral layer is where the real patterns hide. When you tag your emotional state and your rule breaks consistently, you start to see things like this: your revenge trades cluster after a big loss and almost always lose, your best trades happen when you are calm and patient, and your worst days start with one impulsive trade in the first thirty minutes. None of that is visible in your profit and loss. All of it is visible once you track behavior.
If you want a deeper look at the specific behavioral mistakes to watch for, we cover the big ones in detail: how to stop revenge trading, how to recognize and cut overtrading, and how to beat FOMO. Tagging your trades for these patterns turns vague self awareness into hard data you can act on.
The metrics that matter
Once you have a body of journal entries, the metrics you compute from them are what turn raw data into insight. Here are the ones worth tracking, and what each one tells you.
Win rate is the percentage of your trades that are profitable. It is the most quoted metric and the most misunderstood. A high win rate means nothing on its own, because a trader who wins often but lets losers run can still lose money. Win rate only matters in combination with the size of your wins and losses.
Average win versus average loss, often called your reward to risk ratio, tells you how big your winners are compared to your losers. A trader with a fifty percent win rate who makes two R on winners and loses one R on losers is highly profitable. A trader with a seventy percent win rate who makes half an R on winners and loses two R on losers is bleeding out. This ratio is where most of the truth lives.
Expectancy combines win rate and reward to risk into a single number: how much you can expect to make per trade on average, expressed in R. Positive expectancy means your process makes money over time. Negative expectancy means it loses money, no matter how good a few individual trades felt. Expectancy is the number that tells you whether you have an edge at all.
Maximum adverse excursion and maximum favorable excursion, often shortened to MAE and MFE, track how far a trade went against you before it worked and how far it went in your favor before you exited. Over many trades, these reveal whether your stops are too tight, whether you are leaving money on the table by exiting early, and whether your entries are well timed.
Beyond these, the most powerful thing you can do is break every metric down by category. Look at your expectancy by setup, by time of day, by day of the week, by market condition, and by emotional state. This is where journals produce their biggest payoffs. You might discover that one of your three setups is carrying all your profit while the other two break even, or that your expectancy goes negative the moment you trade after eleven in the morning, or that every trade tagged anxious loses money. Those are the insights that change how you trade.
How to review your journal
Logging is only half the job. The review is where the learning happens, and it should run on three cadences.
The daily review is short. At the end of each session, look back over the day's trades while they are fresh. Did you follow your plan? Were there any trades you should not have taken? How did you feel, and did that feeling cost you anything? Five minutes is enough. The point is to close the loop on the day while you still remember it.
The weekly review is where patterns start to appear. Once a week, look across all your trades for the week and ask what your execution scores tell you, which setups worked, which rules you broke most often, and what single behavior would have improved your week the most. Pick one focus for the coming week. Not five. One. Behavioral change happens one habit at a time, and trying to fix everything at once fixes nothing.
The monthly review is strategic. Once a month, compute your metrics across the whole month and compare them to previous months. Is your expectancy improving? Is the behavior you focused on last month actually getting better? Are your best setups still your best? This is where you make larger adjustments to your strategy, your risk, and your routine.
The discipline to run these reviews consistently is itself a skill, and it is closely tied to the broader habit of executing your plan. We go deeper on that in trading discipline: why it beats strategy.
Spreadsheet, notebook, or app
A common question is what tool to use. The honest answer is that the best tool is the one you will actually keep using, but the options have real tradeoffs.
A paper notebook is frictionless to start and good for capturing your thinking and emotion in your own words. Its weakness is that you cannot compute metrics or spot patterns across many trades without copying everything into something else. It works as a thinking space, not as an analytics tool.
A spreadsheet is the classic choice. It is flexible, free, and lets you compute any metric you want. Its weakness is the manual effort. Building and maintaining a good spreadsheet takes real work, the behavioral tagging is tedious to enter and even harder to analyze, and most people eventually let it slide because the friction is too high to sustain.
A dedicated journaling app removes most of the manual work. The best ones import your trades, compute your metrics automatically, and let you focus your energy on the parts that actually need a human: the rationale, the emotion, and the review. The tradeoff is that you are relying on a tool built by someone else, so it matters that the tool tracks the things that actually make you better.
This is exactly where execution scoring comes in. Most journaling apps are strong at the objective layer, the trades and the statistics. Far fewer measure the behavioral layer directly. ExecutionIQ is built around that gap. It scores every trade across six behavioral dimensions, plan adherence, entry quality, stop discipline, emotional control, position sizing, and exit quality, and it detects the recurring patterns that hurt your results, so the behavioral layer that most journals leave to manual effort becomes automatic.
Common journaling mistakes to avoid
A few specific mistakes are worth calling out, because they quietly undermine even a well intentioned journal.
Only logging your big trades or your losses is a trap. Selective journaling gives you a distorted picture. You need every trade, including the small wins and the boring ones, because the patterns live in the full set, not the highlights.
Only logging numbers, as covered earlier, rebuilds your broker statement and teaches you nothing new. Always capture behavior alongside results.
Being dishonest with yourself defeats the entire purpose. If you log a revenge trade as a planned setup, you have corrupted your own data and you will draw the wrong conclusions. The journal is a private mirror. It only helps if you let it show you the truth.
Inconsistency is the silent killer. A journal with gaps cannot reveal reliable patterns. It is far better to capture a little for every trade than to capture everything for some trades and nothing for others.
Skipping the review wastes all the effort you put into logging. If you only do one thing well, make it the weekly review, because that is where the journal pays you back.
Turning your journal into an edge
The point of all this is not to have a tidy record. The point is to change how you trade. A journal becomes an edge when the loop closes: you log honestly, you review regularly, you identify the one behavior costing you the most, you focus on it until it improves, and then you move to the next one. Repeat that loop month after month and your trading improves in a way that no new strategy or indicator can match, because you are fixing the trader rather than chasing the next system.
That is the real reason behavioral journaling beats P and L tracking. Your profit and loss is an outcome. Your behavior is the cause. When you measure and improve the cause, the outcome follows. When you only track the outcome, you are forever reacting to results you do not understand.
If you want the behavioral layer handled for you, start journaling your execution with ExecutionIQ. It scores how well you trade your plan on every trade, surfaces the patterns hurting you, and gives you one clear behavior to improve each week, which is exactly the loop that turns a journal into an edge. Whatever you trade, from a day trading journal to a prop firm trading journal, the principle is the same: track the trader, not just the trade.