This free risk management checklist template for Google Sheets structures trade discipline into a three-phase gate system — pre-trade, in-trade, and post-trade — with specific numerical pass/fail thresholds built into every check. Unlike generic rule lists, it embeds a position sizing formula, a consecutive-loss circuit breaker, and a prop firm drawdown tracker so traders enforce risk limits at every decision point, not just at entry.
What’s Included
- Pre-Trade Gate — A top-to-bottom checklist confirming your daily loss limit is not already hit, no earnings or macro events (FOMC, CPI) are scheduled during the session, and you are not adding correlated exposure to existing positions.
- Position Sizing Calculator — Embedded formula: Position Size = (Account Risk $) ÷ (Entry Price – Stop Price). Enter two numbers, get your share count. No Excel expertise required.
- In-Trade Checklist — Tracks the 1:1 R partial profit trigger (sell 40–50% of position when gain equals initial risk), breakeven stop move confirmation, and max adverse excursion (MAE) for post-trade review.
- Post-Trade Review — Prompts a journal entry, updates a consecutive loss counter, and compares session P&L against the pre-session plan.
- Prop Firm Compliance Tab — Pre-configured with FTMO-style limits: 5% daily drawdown and 10% total drawdown. For a $100K account that is $5,000 and $10,000 hard stops. Remaining buffer calculates automatically after each entry.
- Circuit Breaker Row — Highlights in red after 3 consecutive losses, enforcing a mandatory pause before taking the next trade.
- Session Summary Tab — Daily trade count, win rate, gross P&L, commissions, and net P&L in one view.
How to Use
Step 1: Set Your Account Parameters
Open the Settings tab and enter your account balance in cell B2, your risk per trade as a percentage in cell B3, and your daily loss cap in cell B5. For a $25,000 account risking 1% per trade, B3 = 1% and B5 = $500 (2% daily cap). These values feed every other sheet automatically.
Step 2: Complete the Pre-Trade Gate Before Each Trade
Open the Pre-Trade sheet and work top to bottom before placing any order. Row 3 checks whether the session P&L has already hit the daily loss limit. Row 7 prompts a news calendar check — confirm no earnings release, Fed announcement, or CPI print is scheduled within your trading session. Row 11 asks whether you are already long or short a correlated instrument (e.g., holding SPY calls while adding AAPL longs doubles tech exposure). All three must pass before proceeding.
Step 3: Calculate Position Size
In the Position Sizing tab, enter your intended entry price in cell C2 and stop price in cell D2. Cell D3 runs =B2/(C2-D2) and returns your share count. Example: entry at $185, stop at $183, $250 risk → 125 shares. Round down to the nearest round lot if your broker charges per-order commissions.
Step 4: Track In-Trade Checkpoints
Once the trade is live, use the In-Trade tab. Mark column B when price reaches 1:1 R (e.g., $187 on the AAPL long entered at $185 with a $2 risk). At that point, sell 60 of the 125 shares and move the stop on the remainder to $185 (breakeven). Log the MAE in column E — the furthest the trade moved against you — to identify slippage and pattern problems over time.
Step 5: Complete the Post-Trade Review
After closing, return to the Post-Trade tab. Log the trade outcome in column C, update the consecutive loss counter in cell F8, and enter the session P&L in column G. If cell F8 reaches 3, the circuit breaker row highlights in red — the correct response is to close the platform and return the next session.
Step 6: Update the Prop Firm Tracker (If Applicable)
If trading a funded evaluation account, enter today’s net P&L in the Prop Firm tab. For an FTMO $100K challenge, the sheet compares your cumulative drawdown against the $5,000 daily and $10,000 total limits and displays remaining buffer in cells D4 and D5. Staying aware of these numbers before each session prevents rule violations that disqualify the account.
Key Benefits
- Numerical thresholds, not vague rules — Every check has a specific pass/fail value (2% daily loss, 3-loss circuit breaker, 1:1 R trigger) rather than subjective guidance like “manage your risk.”
- Embedded position sizing formula — Traders who calculate size manually before each trade make arithmetic errors under pressure; the formula removes that variable entirely.
- Prop firm compatibility — The FTMO-style compliance tab is absent from most free checklists; it is built directly into this template for traders in evaluations.
- Three-phase structure — Separating pre-trade, in-trade, and post-trade checks prevents the common mistake of reviewing risk only at entry and ignoring it once the position is open.
- Reduces overtrading — Research by Brad Barber and Terrance Odean (UC Davis) identifies overtrading as the primary cause of retail underperformance; the circuit breaker and daily trade count fields directly enforce session limits.
Template vs JournalPlus App
| Feature | This Template | JournalPlus App |
|---|---|---|
| Position Sizing Formula | Manual entry in Google Sheets cell | Auto-calculated from imported trade data |
| Trade Logging | Manual copy from broker platform | Automatic import from 50+ brokers |
| Consecutive Loss Tracking | Manual counter with conditional formatting | Automatic streak detection with alerts |
| Drawdown Monitoring | Manual session entry required | Real-time drawdown dashboard |
| Analytics Depth | Win rate, basic P&L, trade count | 30+ metrics including MAE, MFE, R-multiple distribution |
| Prop Firm Rules | FTMO limits pre-filled, manual tracking | Configurable rule-based alerts per account |
| Price | Free | $159 one-time, lifetime access |
This template is a complete, functional risk management system for traders who want structure without a subscription. When you are ready for automatic broker imports, real-time drawdown alerts, and deeper analytics like MAE/MFE tracking, JournalPlus picks up where the spreadsheet leaves off. The prop firm trading journal template and position sizing calculator are useful companions in the meantime.
Download
Download the free Risk Management Checklist Template and make a copy to your Google Drive. No account required — customize your account balance, risk percentage, and drawdown limits immediately.
Frequently Asked Questions
What should be on a trading risk management checklist?
A complete trading risk management checklist covers three phases. Pre-trade checks confirm your daily loss limit is not breached, no high-impact news is imminent, and your position size fits your risk parameters. In-trade checks trigger partial profit-taking at 1:1 R and a stop move to breakeven. Post-trade checks log the outcome, update your streak counter, and compare P&L against your session plan.
How do I calculate position size on a risk management checklist?
Use the formula Position Size = (Account Risk $) ÷ (Entry Price – Stop Price). For a $25,000 account risking 1% ($250) with entry at $185 and stop at $183, the calculation is $250 ÷ $2 = 125 shares. This template embeds the formula so you only need to enter your entry and stop prices. For more detail, see the position sizing worksheet.
Can I use this checklist for FTMO or other prop firm accounts?
Yes. The template includes a dedicated prop firm tab pre-configured with FTMO’s standard rules — 5% maximum daily drawdown and 10% maximum total drawdown. For a $100K account that translates to $5,000 and $10,000 hard limits. Enter your session results after each day to track your remaining buffer.
What is the 3-loss circuit breaker rule?
The circuit breaker rule stops trading after 3 consecutive losses in a session. Research on overtrading — including studies by Brad Barber and Terrance Odean at UC Davis — shows that emotional trading after a loss streak is a leading cause of retail underperformance. The template flags this threshold automatically so traders step away before compounding losses. The trading psychology tracker pairs well with this rule for longer-term pattern review.
Is this risk management checklist template free?
Yes, the Google Sheets risk management checklist template is free to download with no account required. Make a copy to your Google Drive and customize the account balance, risk percentage, and drawdown limits to match your own parameters. For traders who want automatic data entry and real-time monitoring, JournalPlus offers a one-time purchase at $159 with lifetime access.
