Trading Journal Template: What to Record and Review
Copy a practical trading journal template. Record initial risk, net R, costs and rule adherence, then use a twenty-minute review to find useful patterns.
A useful trading journal lets you answer three questions: what did I intend to do, what did I actually do, and what happened after costs? Start with a small, consistent template. Add fields when they help answer a real question about your trading.
The table below works for a spreadsheet or a dedicated journal. It also works for historical replay, provided you label simulated trades clearly and keep them separate from other results.
A template you can copy
| Field | Example | Why it matters |
|---|---|---|
| Date, time and timezone | Example session, 09:45 New York | Lets you compare comparable periods |
| Instrument and mode | MNQ, historical replay | Distinguishes instruments and simulated results |
| Setup and direction | ORB v1, long | Keeps one experiment separate from another |
| Entry, initial stop and quantity | Recorded before the outcome | Establishes the original risk |
| Net result in R | +1.4R after modeled costs | Makes risk-adjusted outcomes easier to compare |
| Rules followed? | No: entered before confirmation | Separates execution from the written method |
| One observation | “Entered on a forming candle” | Gives the next practice session a purpose |
Use consistent setup names. “ORB v1” and “ORB v2” should represent different written rules, not different moods. Keep the old version's results when you change the strategy.
If your software already stores fills and quantity, your note can link to that record instead of copying it by hand. Preserve enough information to reconstruct the calculation.
Calculate R from the initial risk
Suppose your original planned price risk was $100 and the net outcome was +$140. That is +1.4R. A net loss of $108 is -1.08R. Moving a stop after entry does not change the original denominator.
For instruments with a tick value or multiplier, use those specifications to calculate the planned monetary risk. A ten-point move has a different monetary effect on NQ and MNQ. The futures calculator can help with supported contracts.
R does not remove every difference between markets. Keep instrument, session and rule version available when comparing rows.
Record costs once
Write down whether your result already includes spread, commissions or an execution adjustment. Add only the costs that are missing.
If a backtest uses midpoint prices, its cost treatment will differ from a record based on bid/ask execution. If an assumed stop fill is uncertain because of a gap or coarse candle, mark the row instead of giving it an unexplained exact result.
Your record should distinguish observed prices, simulator fills and hypothetical cost adjustments. That distinction is especially useful when investigating why two platforms report different outcomes.
An example review of four trades
These are invented rows for arithmetic, not a TestMax performance claim:
| Trade | Setup | Rules followed? | Net R |
|---|---|---|---|
| A | ORB v1 | Yes | +1.8 |
| B | ORB v1 | Yes | -1.1 |
| C | ORB v1 | No | -1.4 |
| D | ORB v1 | Yes | +0.3 |
Total net result is -0.4R and average result is -0.1R. The rule-following subset totals +1.0R; the one violation lost 1.4R.
That is a useful reason to inspect trade C. Four trades cannot establish that the strategy is profitable or that rule violations always explain losses. Keep both the full record and the subsets, then gather more observations under unchanged definitions.
Review the journal in twenty minutes
First, check completeness. Reconcile the trade count with your platform. Add no-trade sessions and explicit skip reasons where they matter. Missing losing days can make every later calculation misleading.
Next, review one setup. Calculate average net R and inspect the sequence. Note the largest decline from an earlier equity peak, not just the largest single loss. The drawdown explanation covers the recovery arithmetic.
Then, read the exceptions. Were losses ordinary valid trades, execution mistakes or ambiguous outcomes? Avoid rewriting every losing trade as a mistake after seeing the result.
Finally, choose one next action. For example: “In the next five replay sessions, I will record the signal candle's closing time before placing the order.” That is specific enough to evaluate.
Use win rate with average outcomes
A 45% win rate does not settle whether a method has positive expectancy. You also need average winners, average losers and costs. The win-rate and risk-reward guide explains the relationship, and the win-rate calculator helps check it.
Treat small groups cautiously. Splitting twenty trades into ten sessions and five setup names can produce persuasive-looking percentages from almost no evidence. Keep the sample counts visible next to every statistic.
What changes for a forex journal?
Record the pair, conventional pip size, position units, account currency and price basis. A pips-only result is incomplete when size or currency conversion changes between trades.
Keep timezone labels explicit. Two entries marked “08:00” are not comparable if one is UTC and the other is New York time. If you test the same rule on several pairs, preserve the pair-level results before combining them.
The same journal structure works; these details explain the numbers in each row. Avoid creating a separate collection of inconsistent sheets for every instrument.
Start with a manageable replay record
TestMax combines historical replay with trade review, notes and tags. You can use a spreadsheet alongside it for any custom fields or cost scenarios your analysis needs. Do not assume every calculation described here is a built-in report.
Create a TestMax account and log your next ten simulated trades, including losses and mistakes. Use an eligible forex or spot instrument for Free access within its recent history window; supported exchange futures require Pro. Check current plans before selecting a market.
After those ten entries, review whether the template helped you identify one repeatable improvement. That is the first job of the journal. Larger performance claims need a much broader record.