Filling in a journal is the first half of the process. The second half — analysis — is where the actual improvement happens. Most traders who keep journals never get to this step. They accumulate entries, review individual trades reactively, but never extract the systematic patterns that are sitting in their data. This guide explains how to analyse 100+ trade entries to find those patterns.
When to Start Analysis
Meaningful pattern analysis requires enough trades to produce statistically relevant signal rather than noise. The minimum thresholds:
- 20 trades: Can identify which pairs or setups are consistently losing — enough to stop trading them
- 50 trades: Can calculate reliable win rate, average R, and expectancy with some confidence
- 100 trades: Full statistical picture — time-of-day patterns, emotional state correlations, setup-type performance
Do not wait until 100 trades to start reviewing. Weekly reviews from the beginning build the habit. But treat the 50-trade and 100-trade marks as formal analysis checkpoints.
The Five Core Statistics to Calculate
1. Win Rate
Wins ÷ Total trades × 100. Calculate separately for different categories: by pair, by session, by setup type, by emotional state before entry.
2. Average Winner (in R multiples)
Sum of all positive R multiples ÷ number of wins. This should exceed 1.0R for any viable system at normal win rates.
3. Average Loser (in R multiples)
Sum of all negative R multiples ÷ number of losses. Should be close to 1.0R if stop-losses are being respected. Significantly above 1.0R indicates stop-loss moving.
4. Expectancy
(Win rate × average winner R) − (loss rate × average loser R). This is the single most important number in your analysis.
Worked example: 48% win rate, average winner 2.1R, average loser 1.1R:
= (0.48 × 2.1) − (0.52 × 1.1) = 1.008 − 0.572 = +0.436R per trade
At R500 risk per trade (1% of R50,000), this is R218 average profit per trade. Over 50 trades per month, that is R10,900/month — a 21.8% monthly return. These numbers are illustrative but show how positive expectancy compounds.
5. Maximum Drawdown in R
The worst peak-to-trough sequence in R terms. If your worst losing streak was 8 consecutive losses, your drawdown was 8R. At 1% risk per trade, that is 8% account drawdown — recoverable. At 3% risk, it is 24% — a serious problem.
Google Sheets Analysis Template
The following columns capture everything needed for systematic analysis:
| Column | Description |
|---|---|
| Date | YYYY-MM-DD |
| Time | Entry time (SAST) |
| Pair | USD/ZAR, EUR/ZAR, etc. |
| Direction | Long / Short |
| Entry | Actual entry price |
| Stop | Stop-loss price |
| Target | Take-profit price |
| Exit | Actual exit price |
| Size (lots) | Position size |
| R at risk (ZAR) | Actual ZAR amount risked |
| Outcome R | Result in R multiples (+1.5R, −1R, etc.) |
| Outcome ZAR | Actual ZAR P&L |
| Emotion (1-10) | Pre-trade emotional state |
| Setup type | Your named setup (e.g., "EMA bounce", "breakout") |
| Rules followed | Yes/No |
| Lesson | One sentence |
With these columns, the following analyses become one-click pivot tables:
- Win rate by pair
- Average R by time of day
- Performance by emotional state rating
- Rules-followed vs rules-violated comparison
- Best and worst setup types
The Three Most Revealing Analyses
Analysis 1: Emotional state vs outcome
Group your trades by emotional state rating (1–3, 4–6, 7–8, 9–10) and calculate win rate and average expectancy for each group. The most common finding: trades entered at emotional state 4–7 (steady, neutral) outperform trades entered at 8–10 (overconfident or desperate) by a margin that surprises most traders.
Analysis 2: Rules-followed vs rules-violated
Calculate expectancy separately for trades where you followed your rules and trades where you deviated. In virtually every case, rule-following trades are more profitable than rule-violations — often by a ratio of 2:1 or better. This analysis, more than any other, makes the case for executing a process rather than improvising.
Analysis 3: Setup type performance
Which of your named setups actually has positive expectancy? Most traders are surprised to find that 2–3 setups carry their performance while 3–4 others drag it down. The response is to stop trading the losing setups — not to try to improve them immediately, but to concentrate on what is already working.
Red Flags That Require Immediate Action
Stop live trading and investigate if any of these appear in your analysis:
- Average loser significantly above 1.0R (e.g., 1.8R): You are moving stop-losses after entry or holding trades past planned stops. This pattern is more dangerous than a low win rate.
- Win rate above 60% but negative expectancy: Your average winner is much smaller than your average loser. Classic disposition effect — fix the exit process before worrying about entries.
- Consistent underperformance at specific times: If trades between 22:00 and 02:00 SAST consistently lose while other times are profitable, the solution is simple — stop trading those hours.
- Rules-violated trades showing positive results: This is the most dangerous finding. If rule violations are being reinforced by occasional wins, the pattern will continue until a catastrophic loss eventually arrives.
Moving from Analysis to Improvement
The analysis reveals problems. Fixing them requires choosing one item and addressing it specifically:
Week 1–4: Fix the one biggest issue identified (usually: stop-loss placement or not moving stops). Nothing else changes.
Week 5–8: Assess whether the fix worked. Calculate the same statistics over the new 20-trade sample. Move to the next issue only if the first one is resolved.
Trying to fix five things simultaneously produces regression to old habits under pressure. One specific, observable behaviour at a time is how the data translates into lasting improvement.
This is general information only, not financial advice. Trading forex and CFDs carries a high level of risk and losses can exceed your initial deposit.
Apply what you've learned with an FSCA-regulated ZAR account. Open FxPro account →
