A trading journal becomes useful when it explains why results occurred and what should change next. This weekly review checklist shows how to calculate core trading journal metrics, tag mistakes consistently, compare setups, and turn observations into specific rule adjustments without overreacting to a small sample.
Overview
Recording entries and exits is only the first step. A proper weekly trading review connects each trade with its setup, market conditions, execution quality, and adherence to the plan. The objective is not to prove that every winning trade was good or every losing trade was bad. Instead, separate decision quality from outcome quality.
For example, a trade can follow the plan and lose because the setup failed. Another can make money despite breaking a rule. Treating both outcomes as simple wins or losses can reinforce poor behavior. A journal review should identify which process produced the result and whether that process is repeatable.
Before reviewing, export or gather the same fields each week: symbol, direction, entry price, exit price, quantity, entry and exit time, fees, stop level, target level, setup type, market or sector context, and a short pre-trade thesis. If a broker export uses different column names, map them to a consistent spreadsheet or journal format. Consistency matters more than the specific tool.
A practical weekly sequence
- Import trades and check that fills, quantities, fees, and timestamps are accurate.
- Calculate results in both dollars and risk units, such as multiples of the initial planned risk.
- Review screenshots or notes for every trade, not only the largest winners and losers.
- Group trades by setup, time of day, holding time, direction, and rule violations.
- Write one or two changes for the next review period and define how they will be measured.
Risk units can make comparisons clearer. If the planned loss at the stop was $100 and the trade made $200 after costs, the result was approximately +2R. If the trade lost $100, it was -1R. The exact amount of risk should be based on the plan before entry, not adjusted afterward to make the statistics look better.
Checklist by scenario
1. Review the whole account first
Start with the account-level picture before judging an individual strategy. Record net profit or loss after fees, total number of trades, gross gains, gross losses, largest winning trade, largest losing trade, and the peak-to-trough drawdown during the review period. Also compare planned risk with actual risk. A profitable week with excessive size may still reveal a serious risk-management problem.
| Metric | How to calculate or define it | What it helps identify |
|---|---|---|
| Win rate | Winning trades divided by total closed trades | How often the approach produces a profitable outcome |
| Average win | Total winning-trade profit divided by winning trades | Typical payoff when the trade works |
| Average loss | Total losing-trade loss divided by losing trades | Typical damage when the trade fails |
| Expectancy | (Win rate × average win) − (loss rate × average loss) | Estimated average result per trade before considering sample uncertainty |
| Profit factor | Gross winning profit divided by gross losing loss | Relationship between total gains and total losses |
| Drawdown | Decline from an equity peak to a later trough | Potential psychological and financial strain |
| Holding time | Exit timestamp minus entry timestamp | Whether results vary by trade duration |
| Rule violations | Count and type of broken plan rules | Whether behavior, rather than strategy, is driving losses |
Use the same treatment of fees and partial exits every week. Expectancy is especially sensitive to calculation errors. If average loss is recorded as a negative number, write the formula carefully so the loss rate and loss magnitude are not accidentally double-counted. For small samples, describe the result as an observation rather than proof that a strategy works.
2. Compare setup types
Give every trade one primary setup label, such as breakout, pullback, reversal, trend continuation, earnings reaction, or another definition that matches your plan. Avoid assigning several labels to make a trade fit multiple categories. For each setup, compare trade count, win rate, average win, average loss, expectancy, profit factor, and maximum drawdown.
A setup with a lower win rate may still be valuable if its average winner is substantially larger than its average loser. Conversely, a high win rate can conceal occasional losses that are too large. Review the distribution, not just the headline percentage.
3. Compare time of day and holding period
Group trades into consistent windows, such as the opening period, midday, and final trading hours, if those categories are relevant to the strategy. Then compare average result, slippage observations, and rule adherence. For swing trading, use holding-period bands instead. The purpose is not to assume one time window is always better; it is to discover whether your own execution changes under different conditions.
4. Review rule violations separately
Create a mistake-tagging system that is short enough to use consistently. Useful tags include late entry, oversized position, moved stop, no valid setup, revenge trade, ignored news or earnings risk, early exit, missed exit, and technical execution error. Add a brief note describing the trigger and the consequence.
Count each tag and calculate its financial impact where possible. If three oversized trades caused most of the week’s losses, the appropriate response may be a position-sizing control rather than a new trading strategy. For additional risk controls, compare your process with the guidance in Position Sizing for Day Trading.
What to double-check
- Data integrity: Match broker fills against the journal. Check partial fills, commissions, borrowing costs where applicable, dividends, and adjusted prices.
- Open positions: Do not mix unrealized results with closed-trade statistics without labeling them. Mark-to-market results can change before the next review.
- Sample size: A single week may contain too few trades to support a strategy change. Use the weekly review to identify questions, then test them across a larger sample.
- Market context: Note whether results occurred during an earnings event, broad market selloff, unusually low liquidity, or a strong trend. A setup may behave differently across conditions.
- Costs and execution: Include commissions, spread, slippage, and data or platform costs that affect the strategy. The guide to trading bot fees and costs is also relevant when reviewing automated execution.
- Rule definitions: Make sure “valid setup,” “planned risk,” and “early exit” have written definitions. Vague labels produce inconsistent statistics.
A reusable review template
Copy this structure into a spreadsheet or journal tool:
Period: [start date–end date]
Net result after costs: [amount and R]
Trade count: [number]
Win rate / average win / average loss: [values]
Expectancy / profit factor: [values]
Maximum drawdown: [amount and percentage]
Best setup: [label, sample size, expectancy]
Weakest setup: [label, sample size, expectancy]
Most frequent mistake: [tag and count]
Largest avoidable loss: [trade and reason]
Next-period experiment: [one measurable change]
Common mistakes
Changing the strategy after one bad week. A losing sequence can occur within a sound process. First determine whether the losses followed the rules and whether the market environment changed.
Optimizing for win rate. Win rate is only one input. Pair it with average win, average loss, expectancy, drawdown, and costs.
Removing losing trades from the sample. A trade should not be excluded because it was unusual or inconvenient. Tag unusual conditions instead.
Using hindsight labels. Do not classify a trade as a better setup merely because it later produced a profit. Use the information available at entry.
Confusing activity with progress. Adding more indicators, tags, or dashboards does not automatically improve decisions. Keep fields that support a specific question or control.
Ignoring automation and operational errors. If a trading bot, alert, scanner, or broker connection contributed to an execution issue, record it separately from the market thesis. A trading bot monitoring checklist can help distinguish system health from strategy performance.
When to revisit
Perform a short review after each trading week and a deeper review at the end of each month or meaningful sample period. Revisit the journal immediately after a large drawdown, a change in position size, a new broker or platform, a new strategy, or a change from paper trading to live execution. The paper-to-live transition checklist can help separate process changes from market results.
Update the journal fields when your broker changes its export format, when fees or execution conditions change, or when you add an automated strategy. Recheck formulas after moving from a spreadsheet to a dedicated journal platform. Before each seasonal planning cycle, compare the latest results with prior periods and decide whether your rules still match your schedule, capital, and risk tolerance.
End every review with one controlled action: reduce size for a defined period, prohibit a specific mistake, narrow a setup definition, or collect more data before changing anything. Write the action and its success measure in the next journal period. That final step turns review into a feedback loop rather than a retrospective exercise.
