Home / Tools / Trade Journal

RRR Trade Journal Template

A spreadsheet template aligned to the Reveal-Retrace-Run framework. Log every trade with the RRR stages, track your R:R, and let the built-in formulas calculate win rate, expectancy, and your equity curve.

Download the Template

CSV format — opens in Excel, Google Sheets, or Apple Numbers. Add the formulas below after your first 10 trades to see your stats.

Download CSV Template

RRR-Aligned Columns

Every row captures the Reveal (what happened), Retrace (entry level), and Run (target) — so you can audit whether you actually followed the Protocol.

R:R Tracking

Planned vs. actual risk-to-reward on every trade. See if your targets are realistic or if you're cutting winners short.

Win Rate Formula

Add the formula to calculate your win rate from the Outcome column. Know your edge in 20 trades, not 200.

Expectancy & Equity Curve

Average R per trade and a running P&L total. The two numbers that tell you if the system is working.

Columns in the Template

Date — when the trade was taken
Instrument — ES, NQ, or custom
Direction — long or short
Reveal — what did the market show you?
Retrace — what level did you enter at?
Run — where was your target?
Stop Distance (pts)
Entry / Stop / Target Price
Position Size (contracts)
Risk $ — total dollar risk
Risk R / Actual R
R:R Planned / R:R Actual
Outcome — W / L / BE
P&L $
Notes — what did you learn?
Emotion Rating (1-5)
A+ Setup (Y/N)

Formulas to add after 10+ trades

Win Rate: =COUNTIF(Outcome_range,"W")/COUNTA(Outcome_range)
Expectancy (R): =AVERAGE(Actual_R_range)
Total P&L: =SUM(PnL_range)
A+ Win Rate: =COUNTIFS(A_plus_range,"Y",Outcome_range,"W")/COUNTIF(A_plus_range,"Y")

Open the Daily Checklist →