How to Create a Trading Journal: Step-by-Step Guide

By Lenka Rož Schánová · Operations & Risk, For Traders

To create a trading journal, choose a format (spreadsheet, notebook or app), build 18 fixed fields split across entry, exit and review, add formulas for R-multiple, expectancy and profit factor, attach an entry and exit screenshot to every trade, and run a weekly review that ends in one written rule change. Budget 90 seconds per trade and roughly 40-50 trades before the data says anything useful.

Key takeaways

• A trade log records what happened; a trading journal records why you did it and what you'll change — you need both in one file.
• Eighteen fields cover it: seven logged at entry, six at exit, five in the weekly review — anything more and you'll quit by week three.
• R-multiple (profit or loss divided by initial risk) is the only unit that makes a 12-pip XAUUSD scalp and a 300-pip swing comparable.
• Expectancy = (win rate × average win in R) − (loss rate × average loss in R); a 42% win rate at 2.1R average winner still returns +0.30R per trade.
• On a prop evaluation you need four extra columns: daily loss limit headroom, max drawdown consumed, days elapsed, and a rule-breach flag.
• Every weekly review must output exactly one written rule change — a review that changes nothing is just reading.

Watch: related video

Trade log vs trading journal: what you're actually building

A trade log is the objective record — instrument, direction, size, entry, exit, P&L. A trading journal is the decision record — why you took the trade, what you felt, what you'd change. Most traders quit journalling within a month because they're trying to keep both in separate places. Build one file, not two.

What a trade log captures

This is the part you can basically automate. If you trade on MetaTrader 5, your trade history export CSV already hands you the raw skeleton: open time, close time, symbol, type, volume, entry price, exit price, swap, commission, net P&L. Export it from the Account History tab, drop it into a spreadsheet, and you've got the objective side of the ledger without typing a single number by hand. That's the log. It tells you what happened — it will tell you, for example, that your last eleven XAUUSD longs lost money in aggregate. It won't tell you why.

What a journal adds on top

The journal is where the log turns into something you can act on. Same eleven XAUUSD trades — the journal fields reveal that nine of them were entered in the first ten minutes after the New York open, chasing a breakout against the prevailing daily trend. That's not visible in a CSV. It's visible in a line that says "entered on impulse, no confirmation, FOMO off the 5-minute spike." A journal that's worth keeping has, at minimum: the setup name, your confidence rating at entry, what you felt (bored, anxious, confident, revenge), a screenshot of the chart at entry and exit, and a one-line note on what you'd do differently next time.

Why you want them in one file, not two

Separate systems die separately. You stop exporting the CSV because it feels redundant with the broker statement, and you stop writing the journal because logging the numbers already felt like enough admin for one evening. Merge them: one spreadsheet, one row per trade, log fields on the left (instrument, direction, size, entry, exit, P&L), journal fields on the right (setup, emotion, screenshot link, lesson). You fill both halves in the same 90 seconds, right after the trade closes, and you never have to reconcile two sources later.

Step 1: Pick your format — spreadsheet, notebook, app or platform notes

Build your trading journal in Google Sheets first. It's free, it's flexible, and it forces you to write your own formulas — which means you actually understand what R-multiple and expectancy mean instead of trusting a black box. Move to a dedicated app only once you know which metrics you read every week.

Here's the honest trade-off, side by side, before you commit a weekend to building the wrong thing:

Google Sheets or Excel: the default for most traders

A trading journal excel file or a Google Sheet does one thing dedicated apps don't — it makes you build the formula yourself, so you know exactly how your profit factor is calculated instead of trusting a dashboard. Google Sheets wins on access (phone, laptop, shared with a mentor) and cost (zero). Excel wins if you're trading offline or want deeper pivot tables and conditional formatting without a login screen. Either way, start from a trading journal template with the 18 fields we cover in Step 2, not a blank grid — blank grids get abandoned by week two.

Notebook and pen: slower input, better recall

Don't dismiss this one. Writing your entry reason by hand forces you to articulate it in full sentences — the exact field most traders fake with a one-word tag in a spreadsheet ("breakout," no detail). The friction is the feature: a 90-second typed entry lets you skip the thinking; a handwritten paragraph doesn't. Pair it with a weekly digital summary if you want searchable data later.

Edgewonk, TraderSync and other dedicated apps

Edgewonk and TraderSync auto-import fills straight from MT5 and compute MAE/MFE (maximum adverse/favorable excursion) without you writing a single formula. That's real time saved if you're logging 15+ trades a week. The trade-off: $30-50/month, and the maths is hidden behind the dashboard, which matters if you're still learning what these numbers mean rather than just reading them.

TradingView notes and Notion as lightweight options

TradingView notes let you annotate directly on the chart where the trade happened — ideal if you think in price action, not rows. Pair that with a Notion page for weekly reviews and you've got a lightweight, mostly free system that suits discretionary traders over system traders counting fixed metrics.

Step 2: Build the 18 columns — the full field specification

A trading journal needs exactly 18 fixed columns — no more, no less — split 7 at entry, 6 at exit, 5 in your weekly review. This is the part most templates skip: they give you "notes" and "P&L" and call it done. That's a diary, not data. Here's the full field specification, copy-ready, whether you're building a forex trading journal, a day trading journal for futures, or a swing log for gold and indices.

Seven fields you log at entry (before the trade resolves)

Everything here gets written down before you know the outcome. This is what forces honesty — you can't retrofit a thesis once you've seen the result.

1. Date & session — timestamp plus London/NY/Asia tag, so you can later filter for session bias.
2. Instrument & direction — e.g. XAUUSD long, NSDQ short.
3. Setup tag — a fixed, short list you define once: breakout, pullback, range-fade, NFP-fade. Not a sentence — a tag.
4. Entry price — your actual fill, not the signal price.
5. Stop & target — both levels, recorded as a pair, before the trade moves a tick.
6. Size, planned risk ($), planned R:R — your position size, risk in account currency, and the R:R the setup was supposed to deliver.
7. Conviction score & emotional state — conviction 1-5, emotional state from a fixed tag list (calm, FOMO, revenge, tired).

Six fields you log at exit

Once the trade closes, you add the resolution data — the part that tells you whether the setup worked, not just whether you made money.

• Exit price
• Exit reason — stopped out, target hit, manual close, trailing stop.
• Result in currency
• Result in R — the number that actually matters for expectancy math.
• MAE / MFE — maximum adverse excursion and maximum favourable excursion, pulled from the chart. MAE tells you if your stop was too tight or too loose; MFE tells you if you left R:R on the table by exiting early.
• Screenshot link — entry and exit chart, every single trade, no exceptions.

Five fields you fill in during review, not live

These only get filled in your weekly session, with a cold head and the outcome already known.

• Rule followed — yes/no
• Mistake tag — from a fixed list: moved stop, oversized, chased entry, ignored news, no mistake.
• What the chart did after exit — did price keep running your direction? This single field kills more bad habits than any other.
• Lesson — one line, specific, not "be more patient."
• Rule change it feeds — which existing rule this trade updates, tightens, or confirms.

Conviction and emotional state are scored as numbers and fixed tags, not free text, for one reason: tags are filterable, prose is not. "Felt a bit rushed, market was choppy" can't be queried. A conviction score of 2 and an emotional-state tag of "FOMO" can — you can pull every trade tagged FOMO in Excel or Notion and see your win rate and average R collapse in front of you. That's the entire point of what to include in a trading journal: every field exists to be filtered, averaged, or sorted later.

Run the hard cap: if a field hasn't changed a single decision in three months, delete it. An 18-column trading journal template that nobody fills in consistently is worse than a 10-column one you actually complete every trade.

Step 3: Add the formulas — R-multiple, expectancy, profit factor and equity curve

A trading journal without formulas is just a diary. The moment you add R-multiple, expectancy and profit factor columns, your trading journal spreadsheet starts telling you whether your edge is real — and every number below pastes straight into Microsoft Excel or Google Sheets. Assume the layout from Step 2: column D = Entry, E = Stop, F = Exit, C = Direction (1 for long, -1 for short), G = Planned Risk in account currency, N = running Equity.

The R-multiple formula and why every result should be in R

Dollar P&L lies to you — a $400 win means nothing until you know you risked $1,000 to get it. R-multiple fixes that by expressing every trade as a multiple of what you risked. In column R, paste:

To convert that R-multiple back to currency for your P&L column: =R2*G2. Once every trade lives in R, a scalper's 15-pip gold scalp and a swing trader's 200-pip NSDQ breakout sit on the same scale.

Running expectancy, win rate and profit factor

These three numbers, read together, tell you if your system has an edge — not whether your last five trades felt good.

• Win rate:=COUNTIF(R:R,">0")/COUNT(R:R)
• Average win in R:=AVERAGEIF(R:R,">0") (mirror with "<0" for average loss)
• Expectancy:=(WinRate*AvgWinR)-((1-WinRate)*ABS(AvgLossR)) — a positive number means you're statistically profitable per trade over a large enough sample; negative means you're bleeding even on the trades that "feel" fine.
• Profit factor:=SUMIF(R:R,">0")/ABS(SUMIF(R:R,"<0")) — anything below 1.3 over 40-50 trades is a warning, not noise.

*Thresholds are general trading benchmarks, not guarantees — judge yours against your own 50-trade sample.

Equity curve and rolling max drawdown

Build your equity line trade by trade: =N1+R2*RiskPerTrade, dragged down column N. Chart it — a flattening slope before a challenge deadline tells you to cut size, not push harder.

For maximum drawdown, plain terms first: it's the biggest drop from a peak in your equity to the lowest point after it, before a new peak forms. Formula: =MIN(N2:N50)-MAX(N2:N50) run across the range to date, updated weekly. This is the number that maps directly to your daily loss limit and max DD rules on a Two-Step Challenge.

Conditional formatting that flags a rule breach in red

You shouldn't need to read a row to know it was a bad trade. Set two rules:

1. Red fill where Rule Followed (your Fixed tag column) = "No" — instant visual count of self-inflicted damage.
2. Amber fill where Planned R:R < 1.5 — flags setups you took anyway, before expectancy tells you why that week was flat.

Step 4: Build the notebook version if you hate spreadsheets

A handwritten trading journal works just as well as a spreadsheet, provided the layout is fixed before you write a single entry — the format matters more than the tool. If rows and conditional formatting make your eyes glaze over, grab an A5 dotted notebook, rule it once, and never redesign it again.

The one-page-per-day layout

One page, one day, no exceptions. Split the page into three horizontal bands using your ruler: a top band roughly 3cm deep for date, session (London open, New York overlap), and anything on the calendar — NFP, FOMC, CPI — plus your starting account balance. The middle band, taking up most of the page, holds your trades. The bottom third, roughly 2cm, is reserved for the day's one-line lesson. Rule a 2cm right-hand margin down the whole page before you write anything else — that margin is sacred and holds nothing but your R result, one number per trade, nothing else.

The fixed field order that keeps handwriting fast

The entire point of a handwritten trading journal is that your hand learns the order so you're not thinking about structure mid-trade. Use the same sequence every time: pair, direction, entry price, stop, target, reason for entry (one phrase — "pullback to 4H demand"), and exit price. Six to seven fields, written left to right, same order, every trade. Once your hand knows the sequence, logging a trade takes 20 seconds, not two minutes of deciding what to write where. This is also where you note session conditions — a trade taken 10 minutes before an NFP print behaves differently from the same setup on a quiet Tuesday afternoon, and your notebook should make that obvious at a glance months later.

How to run monthly totals without a calculator fight

Reserve the last two pages of the notebook as a back-page tally sheet. At month-end, copy every R result from the right margin of each day into a single column on the tally page, then add it up — the only arithmetic you'll ever do is summing a column of small numbers like +1.5, -1, +2.2, -0.8. No formulas, no spreadsheet, no error-prone mental math mid-month.

Be honest about the trade-off: a notebook can't filter by setup type, sort by R-multiple, or calculate profit factor for you. You're trading speed and tactile memory for flexibility. Compensate by photographing every page into a dated folder at month-end — you get a searchable backup without digitising the whole workflow, and you can still pull up Month 3 next to Month 8 side by side when you're deciding whether you're ready to push size on a Two-Step Challenge.

Step 5: Log each trade in under 90 seconds

If logging a trade takes more than 90 seconds, you'll stop doing it by week three. Split the work: roughly 30 seconds at entry, 30 at exit, and the review fields filled later, never live. That's the whole discipline of how to journal trades without it becoming a second job.

What gets logged before entry vs after exit

At entry, you fill seven fields and it takes 30 seconds because every answer is already decided — you set the stop before you clicked buy, you sized the position before you risked it. Log: date/time, instrument, direction, entry price, stop price, size, setup tag. You're not thinking here, you're recording a decision you already made.

At exit, six more fields, another 30 seconds: exit price, exit reason, R-multiple (let a formula calculate it), P&L, a 1-10 execution score, and a one-line note on what actually happened versus the plan. Review fields — the "what would you change," the pattern-spotting, the weekly rule tweak — never get filled in the heat of a live trade. That's Sunday's job, not Tuesday's.

Screenshot discipline: two charts, same timeframe, marked levels

Two screenshots per trade, not one. Capture the chart at entry and again at exit, same timeframe, same template, with entry, stop, and target drawn on both. If you trade off a 15-minute chart on XAUUSD, both screenshots are 15-minute — not a zoomed-out daily at entry and a 5-minute scalp view at exit. Consistency is what makes trading journal screenshots useful in review; comparing mismatched timeframes tells you nothing. TradingView notes and screenshots work well for this because you can save the drawn template and reapply it in two clicks, so you're not redrawing levels every single trade.

Dropdowns and tags instead of typing

Typing "broke support, got stopped on the retest" takes 15 seconds and gives you an unsearchable sentence. Picking "Stopped — retest failure" from a dropdown takes 3 seconds and gives you a countable column. Build dropdown data validation for four fields: setup tag (breakout, pullback, reversal, range), exit reason (target hit, stopped, moved stop, discretionary close), mistake tag (none, oversized, chased entry, ignored news), and emotion tag (neutral, FOMO, revenge, hesitant). That's roughly five times faster than free text, and at review time you can filter 50 trades by "FOMO" entries in four clicks instead of re-reading every note.

If you're mobile when a trade closes, voice-note the reason into your phone — "stopped out, NFP spiked through, should've sized down before the print" — and transcribe it into the tag fields once a week. You lose nothing, and you never skip logging because you were standing in a coffee line when the stop hit.

Step 6: Track the metrics that actually change behaviour

Four numbers decide whether your trading journal is decoration or a decision-making tool: expectancy, profit factor, average R per trade, and maximum drawdown. Everything else — win rate, number of trades, longest streak — is interesting but doesn't tell you whether to keep trading the system.

Expectancy: the worked example with real numbers

Say your journal shows 100 trades: 42 wins averaging +2.1R, 58 losses averaging −1.0R. Expectancy per trade is (0.42 × 2.1) − (0.58 × 1.0) = 0.882 − 0.58 = +0.30R per trade. Risking 0.5% of account equity per trade, that's +0.15% expected per trade before spread, commission and slippage. Run that over 40-50 trades a month and the edge compounds — run it over five trades and it means nothing, which is exactly why Step 2's sample-size minimum matters.

Why win rate on its own tells you nothing

A 42% win rate with a 2.1R average winner beats a 70% win rate with a 0.4R average winner — and most new traders build the second system by accident, trailing stops too early and taking profit at the first green candle. Do the same expectancy maths on the 70%-win system: (0.70 × 0.4) − (0.30 × 1.0) = 0.28 − 0.30 = −0.02R per trade. That trader feels like a winner seven times out of ten and still bleeds the account dry. Win rate tells you how it feels; expectancy tells you if it works.

Average R per trade, profit factor and max drawdown

Profit factor is gross R won divided by gross R lost. Below 1.0 you're underwater. Above 1.3 is workable. Above 1.75 is a strong system worth scaling size on. Max drawdown should be logged two ways in your journal: in R (how many R-multiples did the worst losing streak cost) and in percent of account — because a 12R drawdown at 0.25% risk per trade feels nothing like a 12R drawdown at 1.5%.

MAE and MFE: the two columns that fix your stops and targets

Maximum Adverse Excursion (MAE) and Maximum Favourable Excursion (MFE) are the two fields traders skip and then wonder why their risk/reward ratio never improves. MAE logs how far a trade moved against you before it worked; MFE logs how far it moved in your favour before you exited. If your winners routinely show MAE of 0.3R maximum, a 1.5R stop isn't protecting you — it's donating 1.2R to every loser that hits it on the way to recovering. If MFE regularly prints 3R and your exit log shows you closing at 1.5R, your stop was never the problem — your target was.

Step 7: Run the review protocol — daily, weekly, quarterly

A trading journal without a review cadence is just a diary. The protocol has three speeds — a 3-minute daily close-out, a 45-minute weekly scan, and a quarterly audit — and each one produces exactly one defined output, not a vague feeling that you "looked at your trades."

The 3-minute daily close-out

End of session, fill the review columns for every trade you took — setup tag, MAE/MFE, exit reason — and write one line: what happened, no analysis. Close the file. That's it. Three minutes, no deep dive. The daily close-out exists to keep the data clean while it's fresh, not to generate insight. If you're spending twenty minutes per day "analyzing," you're front-running the weekly review and you'll burn out before week three.

The 45-minute weekly pattern scan

This is how to review your trading journal properly: sort last week's trades by setup tag, then by session (London, NY open, overnight). Compare expectancy per tag — a breakout tag running 1.4R expectancy next to a pullback tag running -0.2R tells you where to cut size before the sample grows. Pull your worst three trades and your best three, lay their entry and exit screenshots side by side, and look for the visual tell that separates them — a chased entry, a moved stop, a fill into a level that had already been tested twice.

Then write exactly one rule change in a dated changelog tab. One. This is the part most traders get wrong — a weekly trading review that produces three rule changes produces none, because next month you can't attribute the improved result to any single one of them. You changed your entry trigger, your size, and your time filter all at once — which one worked? You don't know, and neither does your journal. One change, one week, one attributable result.

The three questions to ask of every losing trade

1. Was the setup valid at entry? If no, that's an edge problem — tighten the criteria.
2. Was the risk correct? If no, that's also an edge problem — fix the sizing formula.
3. Did I exit for the reason I planned? If no, that's not an edge problem. That's a trading discipline problem, and it doesn't get fixed by changing your strategy — it gets fixed by changing your process, cutting size until the behavior stops, or stepping away from the screen when you feel the urge to override the plan.

Conflating these two categories is how traders "optimize" a system that was never broken, while the actual leak — moving stops, cutting winners early, revenge-sizing after a loss — goes untouched for another quarter.

The quarterly deep review and system audit

Every quarter, pull the changelog tab and audit whether each rule change actually moved average R, not just whether it felt right. If a change you made eight weeks ago didn't shift expectancy, reverse it — don't let it quietly survive because you're attached to it. Kill the dead columns too: any field you've filled in for three months straight without ever referencing it in a review isn't tracking discipline, it's tracking busywork.

Journalling a prop firm evaluation: the four extra columns

On your own account, the only thing that ends a trade idea is your own patience. On a For Traders Two-Step Challenge, two numbers end it for you regardless of how clean the setup was: the daily loss limit and the maximum drawdown. A trading journal for a prop firm challenge has to track both in real time, or it's just a diary of trades you took on an account that was already dead.

Add four columns to the 18 you're already running. They take ten extra seconds per entry and they're the difference between knowing you're close to the daily loss limit and finding out the hard way.

Daily loss limit headroom and max drawdown consumed

The headroom-in-R column is the one that actually changes behavior. If you've got 1.4R of daily headroom left and you're sizing up a 1R trade, the journal is telling you plainly: one more loss and the day is over. Log it before entry, not after — the whole point is seeing it while you can still choose not to take the trade. Track max drawdown consumed as a running percentage too. A trade that looks fine in isolation looks reckless once you see you've already burned 70% of your max DD allowance for the phase.

Rule-breach flags and days elapsed

A simple yes/no breach flag turns your weekly review into a filter instead of a memory exercise — sort by "yes" and you see every rule violation in the phase in one view, no scrolling required. Pair it with days elapsed in the phase. Traders don't usually blow an evaluation on day 2; they blow it on day 18 when the deadline is close and position size creeps up to compensate for lost time. The column makes that creep visible before it becomes a breach.

Session tags for XAUUSD, US100 and CME futures around NFP and FOMC

XAUUSD is the most-traded instrument on the platform, and it trades like a different instrument in the 60 minutes around an NFP print or an FOMC statement than it does in the Asian session — wider ranges, faster reversals, worse fills. US100 NSDQ and CME futures contracts split the same way. Tag the session on every entry (Asian / London / NY, plus a separate NFP/FOMC flag) and you can finally answer the question with data instead of a hunch: are your news-window trades funding the account or draining it?

If you're on For Traders Instant Funding instead of a staged evaluation, the daily loss limit and max drawdown tracking still apply — there's no evaluation phase, but the drawdown rules don't disappear. Keep all four columns regardless of route. And remember what you're journalling toward: simulated profits convert to performance rewards, not guaranteed income — the journal's job is to get you there with fewer avoidable breaches, not to promise the payout.

Build your own journal or pay for an app?

Pros

• A self-built Sheets or Excel journal is free, and writing the R-multiple formula yourself forces you to understand what it measures
• You control the setup tags and mistake tags, so they match how you actually trade rather than a generic taxonomy
• Dedicated apps like Edgewonk and TraderSync auto-import fills from MT5 and compute MAE/MFE without manual entry
• Apps give you instant per-setup and per-session breakdowns that take an afternoon to build in a spreadsheet

Cons / risks

• A DIY spreadsheet takes 2-3 hours to build properly and will break the first time you paste a column wrong
• Manual entry means losers get skipped — the exact trades you need most
• Apps cost a recurring fee that eats into early-stage capital and hide the maths behind a dashboard
• Auto-imported data captures what you did, not why — you still have to type the reason, which is the part that matters

Frequently Asked Questions