Trader journal template pro — 25 kolumn analytics

Jarosław Wasiński · Opublikowano: · 6 min czytania
Ostrzeżenie · YMYL Ten artykuł ma charakter wyłącznie edukacyjny i nie stanowi rekomendacji inwestycyjnej. Handel na rynku Forex wiąże się z wysokim ryzykiem utraty kapitału — według ESMA 74–89% rachunków detalicznych traci pieniądze.

Marek rok 1 trading: basic 5-column journal (date, pair, P/L, win/loss, notes). Mediocre wyniki 50% WR. Mies. 13: switched 25-column pro template. Filter analysis revealed: NFP scalping 25% WR (delete), H4 breakouts 72% WR (focus). Year 2: +€8k profit attributable journal-driven optimization. Tu pokazujemy 25-column framework.

Pro vs basic journal

10 core trade data columns

Mandatory trade fields
1. Date entry2025-03-15 14:30
2. PairEUR/USD
3. DirectionLong/Short
4. Entry priceActual fill
5. SL priceStop-loss level
6. TP priceTake-profit
7. Lot size0.1, 1.0, etc.
8. Exit priceActual exit fill
9. Date exitClose date + time
10. € P/LAfter spread + commission

5 risk metrics columns

  • 11. Risk %: % account at risk (standard 1%)
  • 12. R-multiple: P/L / initial risk (e.g. +2R, -1R)
  • 13. Drawdown %: current peak-to-trough
  • 14. Position % portfolio: relative to total open
  • 15. Correlation other positions: track exposure

5 setup analysis columns

  • 16. Setup type: breakout/pullback/reversal/scalp/news/range
  • 17. Timeframe: H1, H4, Daily
  • 18. Confluence factors: 0-5+ list confirmations
  • 19. News context: pre-NFP, post-FOMC, quiet day
  • 20. Emotional state: 1-10 calm scale entry

5 performance review columns

  • 21. Plan adherence: 1-10 (did I follow plan?)
  • 22. Mistake count: 0+ (what went wrong)
  • 23. Lessons learned: 1-2 sentence note
  • 24. Screenshot link: chart capture
  • 25. Monthly summary tag: rollup category

Marek filter analysis discovery

Marek setup performance breakdown
FilterSetup, TF, emotional state
NFP scalping M5WR 25%, R-mult -0.5 (LOSER)
H4 breakouts calmWR 72%, R-mult +0.8 (WINNER)
Daily pullbacksWR 65%, R-mult +0.6 (GOOD)
Revenge trades (emot <4)WR 30%, R-mult -1.2 (DISASTER)
ActionEliminate NFP + revenge, focus H4 + Daily
Year 2 result+€8k profit journal-driven

Tools comparison

Journal tools
Excel free5h setup, 80% functionality
Edgewonk€169 one-time, pre-built dashboards
TraderSync€30/mies., cloud + mobile
myfxbookFREE, MT5 integration native
Tradervue$25/mies., pro analytics
Year 1 beginnerExcel free wystarcza

Frequency maintenance

  1. Per trade: log w 5 min po closing
  2. Daily: 15 min review
  3. Weekly: 30 min summary + filter analysis
  4. Monthly: 2h deep-dive (expectancy, R-multiple, DD)
  5. Quarterly: 4h comprehensive strategy review
  6. Yearly: full day (tax PIT-38, annual report)

Total yearly: ~50h journal + analysis. ROI: -€5k year vs +€10k year często z optimization.

„25-column pro journal NIE bureaucracy — analytics framework. Filter analysis reveals truth: what setups profitable vs killers. Marek case: NFP scalping deleted (25% WR), H4 breakouts focused (72% WR) = +€8k year 2."

Expectancy + R-multiples

Monthly expectancy calculation:

  • Track 20+ trades w R-units (NIE just €)
  • WR % = wins / total trades
  • Avg win R-multiple, avg loss R-multiple
  • Expectancy = (WR × avg win R) - ((1-WR) × avg loss R)
  • Target expectancy > 0.3R per trade = profitable system
  • Example: 60% WR, +1.5R avg win, -1R avg loss = +0.5R expectancy

Wnioski

Pro trader journal = 25 columns, NIE 5 basic. Analytics framework data-driven optimization.

10 core: date, pair, direction, entry, SL, TP, lot, exit, date exit, P/L.

5 risk: Risk %, R-multiple, DD%, position % portfolio, correlation.

5 setup: setup type, TF, confluence, news context, emotional state.

5 review: plan adherence, mistakes, lessons, screenshot, monthly tag.

Marek case: 25-column rev, filter analysis revealed NFP loser, H4 breakouts winner. +€8k year 2.

Tools: Excel free (5h setup), Edgewonk €169, TraderSync €30/mies., myfxbook free MT5.

Frequency: per trade 5 min, daily 15 min, weekly 30 min, monthly 2h, quarterly 4h, yearly full day.

Total yearly time investment: 50h. ROI massive vs no journal.

Expectancy > 0.3R per trade target = profitable system confirmed.

Powiązane: Excel trading templates baseline, expectancy formula calculation, trading plan template complement.

Jarosław Wasiński
O autorze

Jarosław Wasiński

Redaktor naczelny MyBank.pl · Analityk finansowy i rynkowy

Niezależny analityk i praktyk z ponad 20-letnim doświadczeniem w sektorze finansowym. Twórca i redaktor naczelny portalu MyBank.pl, działającego od 2004 roku. Analiza fundamentalna rynków walutowych i makroekonomicznych od 2007 roku.

Źródła i bibliografia

  1. Brett Steenbarger Daily Trading Coach · journal psychology traderfeed.blogspot.com ↗
  2. Edgewonk Pro journal software · industry standard www.edgewonk.com ↗
  3. Van Tharp Institute R-multiple journal framework · methodology vantharp.com ↗

Najczęstsze pytania

Core trade data 10 columns?

Core trade data = 10 columns minimum every trade: (1) Date entry: trade open date + time (e.g. 2025-03-15 14:30). (2) Pair: EUR/USD, GBP/USD, etc. (3) Direction: Long/Short. (4) Entry price: exact fill price (NIE quote — actual fill, may differ z slippage). (5) SL price: stop-loss level placed. (6) TP price: take-profit level (lub multi-targets dla scaling). (7) Lot size: position size w lots (0.1, 1.0, etc.). (8) Exit price: actual exit fill (TP hit, SL hit, manual close). (9) Date exit: trade close date + time. (10) € P/L: realized profit/loss after spread + commission. Why all 10 critical: enables calculation expectancy, R-multiple, holding period, win rate. Skipping any one = incomplete analysis. Polish trader specifics: P/L wartości w EUR lub PLN (depends broker base currency). Consistency essential — NIE switching currency mid-journal. Spread + commission inclusion: P/L should include ALL transaction costs. Some brokers separate — sum dla net P/L. EUR/USD 1 lot fee: ~€7-10 commission ECN + spread €1-3 = €8-13 total cost per trade entry+exit.

Risk metrics 5 columns?

Risk metrics = 5 columns beyond P/L. Critical dla pro analysis. (11) Risk %: % account at risk per trade. Standard 1%. Compute: (Entry - SL) × pip value × lot size / account balance. E.g. EUR/USD 1 lot, SL 30 pips, €10k account = (30 × €10) / €10,000 = 3% (too high). Re-size 0.33 lot = 1% standard. (12) R-multiple: P/L / initial risk. +€100 profit on €50 risk = +2R. -€50 loss = -1R. Standardizes performance across position sizes. Track over 100 trades = expectancy w R-units. (13) Drawdown %: current peak-to-trough drawdown. Tracks DD progression. Max DD historical = key metric. (14) Position % portfolio: per individual position relative to total open positions. NIE overconcentrate single trade. (15) Correlation other positions: if multiple open. EUR/USD long + GBP/USD long = +0.90 correlation = effectively 2× single trade exposure. Track correlation matrix. Pro insight: most retail track only P/L. Pro tracks R-multiples + DD + correlation = portfolio view. Expectancy in R-units > absolute P/L (size-agnostic comparison). Example monthly review: 20 trades, +5R total = +€500 (if €100 = 1R). WR 60%, avg win 1.5R, avg loss -1R. Expectancy = 0.5R per trade. Positive system.

Setup analysis 5 columns?

Setup analysis = 5 columns categorizing trade type. (16) Setup type: categorical — "breakout", "pullback", "reversal", "scalp", "news", "range". Enables filter analysis. E.g. "Are my breakouts profitable?" Aggregate filtered by setup. (17) Timeframe: H1, H4, Daily, etc. Enables TF performance comparison. E.g. "Do I perform better Daily than H1?" (18) Confluence factors: list multiple confirmations. E.g. "RSI divergence + trend line break + 200 EMA". 0-5+ scale. Higher confluence = higher win rate hypothesis. Verify against journal. (19) News context: any major news affecting trade. "Pre-NFP", "Post-FOMC", "ECB meeting", "Quiet day". Distinguishes news-driven vs technical-driven trades. (20) Emotional state: 1-10 calm scale entry. 10 = perfect calm. 1 = anxious/tilted. Correlates emotional state with performance. Pro insight: 70% retail traderów performance drops dramatically gdy emotional state < 5. Filter analytics example: filter journal "breakout + H4 + emotional state 8+" = subset 25 trades. WR 72%, R-multiple +0.8 avg. Setup A profitable. Filter "scalp + M5 + emotional state < 5" = WR 35%, R-multiple -0.3. Setup B loser. Action: more setup A, eliminate setup B. This is THE PURPOSE of pro journal — reveal what works vs what doesn't. Data-driven optimization.

Tools + frequency?

Tools + maintenance frequency: Tools comparison: (1) Excel free: 5h setup, 80% functionality, full control. Best dla learning. (2) Edgewonk €169 one-time: pre-built dashboards, automatic analytics, mobile sync. (3) TraderSync €30/mies.: cloud, real-time analysis, mobile-first. (4) myfxbook free: MT5/MT4 native integration, automatic logging, community features. (5) Tradervue $25/mies.: pro analytics, P/L attribution, tag system. Recommendation: beginner year 1 = Excel. Year 2+ = combined Excel + Edgewonk lub myfxbook. Pro = TraderSync lub Tradervue. Frequency: Per trade: log w 5 min po closing. Latency = forgotten details (emotional state, confluence). Real-time best. Daily: 15 min review last day trades. Tag patterns, identify mistakes. Weekly: 30 min summary. Filter analysis (setup performance). Notes lessons learned. Monthly: 2h deep-dive. Expectancy calculation, R-multiple tracking, DD analysis, correlation review. Strategic adjustments. Quarterly: 4h comprehensive. Strategy review, goal tracking, year-over-year comparison. Yearly: full day. Tax reporting (PIT-38 Polska), annual report, next year goals. Total time investment: ~50 hours yearly journal + analysis. Worth it: difference between -€5k year vs +€10k year often comes from journal-driven optimization.

Pogłębij temat · pełny przewodnik

Czytasz Trader journal template pro — 25 kolumn analytics