Trading Journal Template: How to Track Every Trade (Free Framework)

Why a Trading Journal Changes Everything

Most traders fail for the same reason: they repeat the same mistakes without realizing it. They take revenge trades after losses, size too large when overconfident, cut winners too early, and hold losers too long — but because they never wrote it down, they never see the pattern.

A trading journal fixes this. It creates a feedback loop between your decisions and their outcomes. After 50 trades in a journal, patterns emerge that are invisible in your head. After 200 trades, your edge — or lack of one — is objectively measurable.

Professional traders and every serious quantitative fund maintain detailed trade journals. The difference between a hobbyist and a professional is not intelligence or capital — it’s the discipline to review and improve.

The numbers are stark: Research shows that only about 13% of day traders are profitable over a six-month period, and just 1% sustain profitability beyond five years. The traders who survive are overwhelmingly those who track, review, and systematically eliminate their losing patterns. A trading journal is not optional — it is the primary tool that separates the 1% from the 99%.

The Essential Fields: What to Track for Every Trade

A good trading journal captures three types of data: setup, execution, and outcome.

Pre-Trade (Capture Before Entry)

Post-Trade (Capture After Close)

Optional Advanced Fields

• MFE (Maximum Favorable Excursion): How far the trade moved in your favor before closing. High MFE with low capture = you’re exiting too early.
• MAE (Maximum Adverse Excursion): How far the trade moved against you before reversing. High MAE winners suggest your stop placement is too tight.
• Emotional state: Rate 1-5. Anxious entries and overconfident sizing are trackable patterns.
• News catalyst: Was there a specific catalyst (earnings, upgrade, news)?
• Session: Pre-market, regular hours, after-hours.

Free Trading Journal Template (Spreadsheet Format)

Here is a Google Sheets-compatible template you can copy directly. The key formulas calculate your R-multiples and win rate automatically.

Row Structure

Column A: Date
Column B: Ticker
Column C: Direction (Long/Short)
Column D: Setup Type
Column E: Entry Price
Column F: Stop Loss
Column G: Target
Column H: Shares
Column I: Exit Price
Column J: P&L ($) = (I2-E2)*H2 for long, (E2-I2)*H2 for short
Column K: Risk ($) = ABS(E2-F2)*H2
Column L: R-Multiple = J2/K2
Column M: Exit Reason
Column N: Trade Grade
Column O: Notes

Tracking Formulas

• Win rate: =COUNTIF(L2:L1000,">0")/COUNTA(L2:L1000)
• Average win: =AVERAGEIF(L2:L1000,">0",L2:L1000)
• Average loss: =AVERAGEIF(L2:L1000,"<0",L2:L1000)
• Profit factor: =SUMIF(L2:L1000,">0")/ABS(SUMIF(L2:L1000,"<0"))
• Expectancy: =AVERAGE(L2:L1000) (average R per trade)

A profit factor above 1.5 and a positive expectancy means you have an edge. Below 1.0 means you’re losing money even if your win rate is above 50%.

What to Review (The Weekly Review Process)

The journal only works if you actually review it. Here’s the review process used by consistently profitable traders:

Daily (5 minutes)

• Log every trade before you close the platform
• Write one line about your emotional state during the session
• Note any deviations from your rules

Weekly (30-60 minutes)

• Review all trades from the week
• Calculate win rate, average R, profit factor
• Sort trades by grade — study your A trades and your D trades separately
• Identify one concrete thing you did well and one specific mistake to fix

Monthly (2-3 hours)

• Look for patterns: which setups performed best? Which times of day? Which market conditions?
• Compare your backtested expectations to live performance
• Adjust strategy rules based on data, not feelings

The Most Revealing Journal Metrics

Once you have 50+ trades logged, these metrics reveal whether you have an edge:

Expectancy (most important): Average R per trade. Positive = you’re a net winner. Calculate it at 50, 100, and 200 trades. If it’s improving, your learning is working.

Win rate vs. R-multiple relationship: A 40% win rate with +2.5R average wins beats a 60% win rate with +0.8R average wins. Many traders focus too much on win rate.

MFE/MAE ratio: If your average MFE is 3x your average MAE on winners, your stops and targets are well calibrated. If MFE is only 1.5x MAE, you’re barely surviving before the trade works.

Performance by setup type: Break out your journal by setup category. You may discover that your momentum trades are highly profitable but your mean-reversion trades are dragging down the overall numbers.

Time-of-day analysis: Many day traders are most profitable in the first 90 minutes and worst in the 12-2pm lunchtime grind. Your journal will show you exactly when to trade and when to stay flat.

Manual Journal vs. AI-Powered Journal

Traditional journals require discipline and time. The problem: most traders fill in the post-trade fields quickly and incompletely because it feels like work after a long trading session.

AI-powered trade journals solve this by automatically capturing:

• Exact entry and exit prices from your broker
• Market conditions at time of entry (VIX level, SPY trend, sector performance)
• Technical indicators at entry (RSI, VWAP relationship, RVOL)
• News catalysts from financial data feeds
• Post-trade reflection using AI analysis

Tradewink’s built-in trade journal automatically logs all executions from connected brokers and generates post-trade reflections using AI. After each closed trade, the system analyzes what worked, what didn’t, and surfaces patterns across your full trade history. Lessons learned are fed back into the AI’s conviction scoring for future trades.

Common Trading Journal Mistakes

Not logging losers completely. The trades you least want to review are the ones with the most to teach you. Force yourself to write more notes on bad trades, not less.

Grading yourself too generously. A trade that hit your target is not automatically an A. Grade execution quality, not outcome. A trade where you followed your plan perfectly but lost money can be an A. A lucky trade where you broke your rules and happened to win is a C.

Waiting to log trades. Memory degrades fast. Log immediately after closing the position while the context is fresh. Never batch-log at the end of the week.

Tracking P&L in dollars instead of R-multiples. Dollar P&L varies with position size and doesn’t tell you if your edge is working. R-multiples normalize for size and show whether your risk-reward is playing out as designed.

No review process. Logging without reviewing is filing without reading. The journal only works if you complete the weekly and monthly review cycle.