This Google Sheets weekly trade review template gives active traders a structured framework to evaluate performance beyond simple P&L — covering execution quality, setup-level expectancy, emotional patterns, and risk compliance. Download it free and use it every Sunday to turn raw trade data into actionable improvements.
What’s Included
- Trade Log sheet — Enter each closed trade with symbol, setup type, entry, stop, exit, and size. R-multiple calculates automatically in column H using (exit - entry) / (entry - stop).
- Execution Quality Score (EQS) column — A 1-10 daily self-grade that separates process quality from trade outcome. Scores below 7 prompt a notes field to document what went wrong.
- Setup Audit sheet — A QUERY-powered breakdown of win rate, total R, and profit factor grouped by setup type. Identifies which strategies have positive expectancy and which are subsidized by others.
- Emotional Review tab — Count FOMO entries, revenge trades, and missed setups by hesitation for the week. Four-week totals appear automatically.
- Risk Compliance checker — Flags trades where realized loss exceeded the max-loss-per-trade limit set in Settings. No manual comparison needed.
- 4-week rolling averages — Win rate, profit factor, and average R calculated across the trailing 28 days to smooth out single-week noise.
- Weekly Summary tab — Consolidates all review sections with a single cell (B12) for writing the one improvement goal for next week.
How to Use
Step 1: Log Each Trade as You Close It
Enter each closed trade into the Trade Log sheet. Required fields are date, symbol, setup type (e.g., opening-range breakout, trend continuation, earnings fade), entry price, stop price, exit price, and position size. The R-multiple column (H) calculates automatically. Setup type is critical — leave it blank and the Setup Audit sheet cannot segment your results.
Step 2: Grade Your Execution Quality Score
At the end of each trading day, score your execution 1-10 in the EQS column. A 10 means the trade was entered and exited exactly per your pre-trade plan. Deduct points for entering more than 0.5% above your planned level, widening a stop after entry, sizing up following a loss, or exiting before your target out of impatience. Grade the process — not whether the trade made money.
Step 3: Run the Weekly Setup Audit
On Sunday, open the Setup Audit sheet. Trades are grouped by setup type showing win rate, total R, and profit factor for each. A profit factor below 1.0 means that setup lost money net for the week. A profit factor above 1.5 meets the baseline threshold for a viable strategy. Look for setups where you took 5 or more trades — small samples are noise.
Step 4: Complete the Emotional Log
On the Emotional Review tab, mark trades where you felt FOMO before entry, entered after a loss to recover, or saw a valid setup and didn’t take it. A single emotional trade in a week is not a crisis. A pattern across four weeks — say, six revenge trades per week — is a behavioral problem that requires a specific rule change, not more willpower.
Step 5: Check Risk Compliance
The Risk Compliance sheet flags trades where dollar loss exceeded your max-loss-per-trade rule. Set your limit in cell B2 of the Settings sheet. For a $30,000 account with a 1% risk rule, that’s $300 per trade. Review every flagged trade to determine the cause — incorrect stop placement, oversizing, or holding past the stop.
Step 6: Set One Goal for Next Week
In the Weekly Summary tab, cell B12, write one specific improvement goal. Not “be more disciplined” — something measurable and bounded, like “pass on trend-continuation setups if I miss the entry by more than 0.5%.” One goal executed well is worth more than five goals ignored.
Key Benefits
- Process-outcome separation — The EQS makes it possible to have a losing week with excellent process, or a winning week with poor process. Knowing the difference is what drives actual improvement.
- Setup-level visibility — A 45% win rate with a 2:1 reward-to-risk ratio produces positive expectancy, but that average hides which setups are doing the work. The setup audit reveals it.
- R-multiple normalization — Dollar P&L conflates skill with position size. R-multiple (Van Tharp’s system) lets you compare a 200-share AAPL trade to a 500-share trade in SPY on the same scale.
- 4-week trend detection — A single bad week is noise. A rolling 4-week decline in profit factor from 1.8 to 1.1 is a signal — the kind that’s invisible without tracking it consistently.
Template vs JournalPlus App
| Feature | This Template | JournalPlus App |
|---|---|---|
| Trade Entry | Manual entry per trade | Auto-import from 50+ brokers |
| R-Multiple Tracking | Formula-based in column H | Automatic with stored risk parameters |
| Setup Audit | Weekly QUERY pivot | Real-time breakdown by setup tag |
| Execution Quality Score | Manual self-grading | Manual grading with trend chart |
| 4-Week Rolling Averages | Pre-built formulas | Automatic across any date range |
| Emotional Log | Weekly manual notes | Per-trade tagging with aggregate stats |
| Price | Free | $159 one-time |
This template is a complete, functional weekly review system. When manual entry becomes the bottleneck — or when you want setup performance tracked in real time rather than in Sunday batches — JournalPlus picks up where the spreadsheet leaves off.
Download
Download the free Weekly Trade Review Google Sheets template and start your first structured review this Sunday. No account required — make a copy directly to your Google Drive.
Frequently Asked Questions
What should a weekly trade review include?
A thorough weekly trade review should cover win rate, profit factor, average R-multiple, an Execution Quality Score separate from P&L, a breakdown of results by setup type, an emotional state log, and one specific improvement goal. Reviewing only dollar P&L misses the process-level information required to improve over time.
How do I calculate R-multiple for my trades?
R-multiple is (exit price - entry price) / (entry price - stop price) for long trades, and the inverse for shorts. A trade that gains twice your initial risk is +2R. This system, developed by Van Tharp in “Trade Your Way to Financial Freedom,” normalizes performance across different position sizes and instruments so trades of any size can be compared fairly.
What is a good Execution Quality Score?
A score of 7 or higher is a reasonable target for a disciplined week, even in a losing week. If your EQS is consistently above 7 but P&L is declining, the strategy’s edge may need examination. If your EQS is low (below 5) and P&L is positive, the results are likely unsustainable — profitable setups are covering for poor execution habits that will eventually cost more than they earn.
How is a weekly trade review template different from a trading journal?
A trading journal records individual trades in real time as they happen. A weekly trade review template is a structured retrospective — it aggregates a week of trades to score execution quality, audit setup performance, identify emotional patterns, and produce one concrete change. They serve different but complementary functions, and serious traders use both.
What is profit factor and what is a good number?
Profit factor is gross winning trades divided by gross losing trades for a given period. A profit factor of 1.0 means breakeven before commissions. A profit factor above 1.5 is widely cited as the minimum threshold for a viable strategy — below that, transaction costs and drawdowns make it impractical to trade at scale. The trading edge tracker template includes a dedicated profit factor chart for longer-term tracking.
