Risk management is everything. This free Excel spreadsheet provides the tools to protect your capital with proper position sizing, drawdown tracking, and risk metrics.
Why Risk Management Matters
Great traders are great risk managers:
- Survival - You can’t profit if you blow up
- Consistency - Proper sizing smooths your equity curve
- Psychology - Correct risk reduces emotional decisions
- Compounding - Capital preservation enables growth
This spreadsheet helps you manage risk systematically.
What’s Included
Position Size Calculator
Calculate proper position sizes instantly:
- Account size input
- Risk percentage (adjustable)
- Entry price
- Stop loss price
- Automatic size calculation
- Rupee amount risked
- Percentage of account
Risk-Per-Trade Analyzer
Track risk on every trade:
- Planned risk
- Actual risk (based on real exit)
- Risk efficiency score
- Historical risk tracking
Drawdown Tracker
Monitor your equity health:
- Running high watermark
- Current drawdown percentage
- Maximum historical drawdown
- Drawdown duration (days)
- Recovery tracking
Portfolio Heat Monitor
For multiple positions:
- Open positions list
- Risk per position
- Total portfolio risk
- Correlation warning
- Maximum heat threshold
Risk Metrics Dashboard
Key statistics at a glance:
- Average risk per trade
- Maximum risk per trade
- Risk-adjusted return
- Sharpe ratio (if data available)
- Win rate vs risk:reward balance
Monte Carlo Simulator
Stress test your strategy:
- Input your win rate
- Input your avg win/loss
- Simulate 1000+ scenarios
- See probability of drawdown levels
- Understand ruin probability
How to Use This Spreadsheet
Step 1: Download
Click the download button to get the Excel file.
Step 2: Set Your Parameters
Enter your account size and risk percentage in the Settings sheet.
Step 3: Calculate Position Sizes
Before each trade, use the calculator to determine proper size.
Step 4: Track Every Trade
Log trades to build your drawdown and risk history.
Step 5: Review Monthly
Monitor your risk metrics monthly to ensure compliance.
Position Sizing Formulas
Basic Position Sizing
Position Size = Risk Amount ÷ (Entry - Stop Loss)
Example:
- Account: ₹1,00,000
- Risk: 1% = ₹1,000
- Entry: ₹500
- Stop Loss: ₹490
- Stop Distance: ₹10
Position Size = ₹1,000 ÷ ₹10 = 100 shares
Percentage-Based Risk
Risk Amount = Account Size × Risk Percentage
Example:
- Account: ₹2,00,000
- Risk: 0.5%
- Risk Amount: ₹1,000
Risk Parameters Guide
| Parameter | Conservative | Moderate | Aggressive |
|---|---|---|---|
| Risk per trade | 0.5% | 1% | 2% |
| Max daily loss | 2% | 3% | 5% |
| Max drawdown | 10% | 20% | 30% |
| Portfolio heat | 3% | 6% | 10% |
Understanding Drawdown
Why Drawdown Matters
Recovery from drawdown requires outsized gains:
| Drawdown | Recovery Required |
|---|---|
| 10% | 11% |
| 20% | 25% |
| 30% | 43% |
| 50% | 100% |
| 75% | 300% |
This template helps you avoid deep drawdowns.
Drawdown Types
- Strategy drawdown - Normal variance in your approach
- Behavioral drawdown - Caused by rule-breaking
- Market drawdown - Caused by extreme conditions
Track which type affects you most.
Portfolio Heat Concept
What is Portfolio Heat?
Total risk across all open positions.
Example
- Position 1: 1% risk
- Position 2: 1% risk
- Position 3: 0.5% risk
- Total Heat: 2.5%
If all positions hit stop loss simultaneously, you lose 2.5%.
Correlation Warning
High correlation between positions = higher true risk. The spreadsheet flags when your positions might move together.
Monte Carlo Simulation
Why Simulate?
Past results don’t guarantee future outcomes. Monte Carlo shows the range of possible futures.
What You Learn
- Probability of 20%+ drawdown
- Probability of account ruin
- Expected equity curve range
- Worst-case scenarios to prepare for
Limitations of Spreadsheet Risk Management
Excel has constraints:
- Not real-time - Must update manually
- No alerts - Can’t warn you of risk breach
- No integration - Doesn’t connect to broker
- Calculation errors - Formula mistakes possible
- Historical only - Can’t project forward easily
Enhance Risk Management with JournalPlus
JournalPlus automates risk management:
- Automatic position tracking - Real-time portfolio heat
- Risk metrics dashboard - Always current
- Drawdown alerts - Warns before you breach limits
- Historical analysis - See risk patterns over time
- Indian broker support - Zerodha, Upstox integration
One-time payment. Protect your capital systematically.
Download Your Spreadsheet
Risk management is the foundation of trading success. Start managing your risk properly today.
