How to keep a trading journal that actually improves your process

Most trading journals die in the second week. They start as a detailed spreadsheet, grow into a chore, and get abandoned the first time a bad day makes them painful to open. The journals that last are short, consistent and focused on decisions you control. This article lays out a simple method. It's about process and record-keeping, not about what to trade.

Journal decisions, not just results

Profit and loss is the noisiest number you have. A good trade can lose and a bad one can win. If the journal only tracks P&L, it mostly teaches you to feel good on green days and bad on red ones. A process journal asks a different question: did I do what my plan said? That's something you control, and something you can improve.

Before the trade (30 seconds)

Write these down before you click buy:

• Setup: one line on why. Use the same words each time so you can sort later.
• Entry, stop and size: the planned price, the stop, the share count and the dollars at risk.
• Which limit decided the size: your per-trade risk or your position cap.
• Plan for exit: target, time stop or the condition that ends the trade.

Writing first is the point. It forces a decision while you're calm, and it gives you something to compare against later.

After the trade (60 seconds)

• Actual entry, exit, fees and result.
• Did I follow the plan? Yes or no, and if no, what changed.
• Mistake tag (if any): pick from a short fixed list, such as moved stop, oversized, chased entry, early exit, broke the daily limit.
• One sentence: what you'd repeat or change.

A five-question process score

At the end of each session, answer five yes/no questions:

1. Did I check the quote and my account before the first trade?
2. Did every trade stay inside my size limits?
3. Did I make a clear decision (buy, sell, hold or skip) rather than drift?
4. Did I journal every trade?
5. Did I honor my daily loss limit?

Your score is the share of yes answers. A session where you skip every trade and follow every rule scores 100%. Over 30 sessions the score tells you more about your habits than the P&L does.

The weekly review (20 minutes)

1. Count mistake tags. Which one shows up most? That's next week's single focus.
2. Compare planned risk with actual losses. Losses much bigger than planned point to gaps, slippage or moved stops.
3. Sort by setup. Look at rule-following by setup, not just results, and note where you hesitate or force trades.
4. Write one rule change, or none. Changing everything at once makes it impossible to see what helped.

An example entry (fictional)

Here's what one complete entry might look like for a made-up ticker, XYZ:

This was a losing trade and a good entry. The plan was written first, the size matched the rules, the stop was honored and the difference between planned and actual loss is explained. Over time, entries like this are what make a weekly review useful: you can separate "the idea didn't work" from "I didn't follow my process," and only the second one needs fixing.

Fields that save hours at tax time

A journal is also your best record for taxes. A few extra columns make year-end much easier:

• Lot ID for every purchase, so partial sales are clear.
• Account (taxable, IRA, spouse), because wash sales can cross accounts.
• Cost basis including fees, and proceeds after fees.
• Buy and sell dates, for short- versus long-term.
• Possible wash-sale flag when you buy back within 30 days of a loss.
• Notes for your CPA, written when you remember the details.

Keep it small enough to keep

The best journal is the one you still use in month six. If a field never changes a decision, cut it. If reviewing takes more than 20 minutes a week, simplify. Consistency beats detail.

If you'd rather start from a ready-made spreadsheet, the Trading Journal & Risk Toolkit includes a position-size calculator, a daily loss fuse, a tax-aware journal with these fields, a day-trade counter and a 30-session process scorecard, for Excel and Google Sheets.

What a journal can't do

A journal won't tell you what to buy, and better records don't guarantee better results. What it can do is make your own behavior visible, so the next decision is a little more deliberate than the last.

More on this topic: the Journal & Risk category lists every related tool, including what’s coming soon. Or browse all 7 categories.