I want to start with a question that changed the way I trade: "If you had a coin that lands heads 60% of the time, how much would you bet on each flip to grow your bankroll as fast as possible without going broke?"
Most traders answer "as much as possible." The mathematically correct answer is exactly 20% of your bankroll — never more. Bet too little and you leave compounding on the table. Bet too much and a natural losing streak will wipe you out even though you have a genuine edge.
This is the core of position sizing. And it's the skill that separates traders who survive long enough to become profitable from the 80% who blow their accounts within two years — not because their strategy was wrong, but because they never learned how much to risk.
After years of trading, teaching, and watching students make the same avoidable mistakes over and over, I built the PRO Position Sizing Suite for Excel — 14 interconnected worksheets that handle every piece of risk math you need, automatically, every single time you open a position.
This guide is going to walk you through every section — what it does, why it matters, and exactly how to use it. Even if you're brand new to trading, by the end of this post you'll understand position sizing at a professional level.
Part 1: Why Position Sizing Is The #1 Skill in Trading
Most trading education focuses on entries — which indicator to use, which pattern to look for, which news catalyst to trade. Very little time is spent on what happens after you enter: how much of your account is at risk, and what happens to your account over time given that risk.
Here's the brutal math that most new traders don't understand:
Look at that chart carefully. Lose 10% and you need 11% to recover — manageable. But lose 50% and you need to double your remaining account just to get back to where you started. Lose 60% and you need 150% gains on a depleted account. The math doesn't work in your favour once drawdowns get large.
This is why professional traders obsess over risk management first, entries second. The best entry in the world can't save you if you're risking 10% of your account on each trade.
"The golden rule of trading is simple: if you don't know exactly how much you're risking on every trade — calculated as a percentage of your account — you are gambling. Position sizing is what transforms gambling into a business."
Part 2: What Exactly Is Position Sizing?
Position sizing answers one question: "How many shares (or contracts) should I buy for this specific trade?"
The answer depends on three inputs you control:
Your total trading capital. This is the base from which all risk percentages are calculated.
The percentage of your account you're willing to lose if this trade hits your stop loss. Typically 0.5%–2% for most traders.
The distance in price from your entry to your stop loss. The tighter the stop, the more shares you can buy with the same dollar risk.
The formula is straightforward:
Simple enough on paper. But in practice, traders also need to factor in commissions, slippage, whether they're trading futures (where the math involves ticks and contract multipliers instead of dollars-per-share), ATR-based stops, multiple entries, and how all of this affects total portfolio risk across all open positions simultaneously. That's where having a dedicated tool becomes essential.
Part 3: Introducing the PRO Position Sizing Suite
The PRO Position Sizing Suite is a single Excel workbook with 14 interconnected worksheets. Every sheet is dark-themed, professionally formatted, and built so that the only cells you ever need to touch are highlighted in blue. Everything else calculates automatically.
Let me walk you through every single sheet in detail.
📊 The Stocks & Equities Calculator
This is your primary trading calculator for stocks and ETFs. Enter six values in the blue cells and everything else populates automatically in under a second:
- Account Size — your total capital ($50,000 for example)
- Risk Per Trade % — the percentage you're willing to lose (1% means $500 at risk on a $50k account)
- Entry Price — where you're getting in
- Stop Loss Price — where you exit if you're wrong
- Target Price(s) — up to 3 profit targets (T1, T2, T3)
- Commission — your broker's fee per side
The calculator instantly returns: exact share count, total position value, % of account deployed, commission cost, max risk in dollars, and — critically — the Reward:Risk ratio and break-even win rate for each target.
If your trade has a 2:1 reward-to-risk ratio, your break-even win rate is 33.3% — meaning you only need to win 1 in every 3 trades to break even. A 3:1 ratio means you only need to win 25% of trades. Understanding this number tells you whether a trade setup is mathematically worth taking before you enter it.
The sheet also calculates Expected Value (EV) — the average dollar amount you can expect to make (or lose) per trade when multiplied by your historical win probability. A positive EV means the trade has edge. A negative EV means you're giving money to the market even if you win sometimes.
📈 The Futures Calculator — Tick Math Made Simple
Futures trading is fundamentally different from stocks when it comes to position sizing. Instead of dollars-per-share, you're working with tick values, contract multipliers, and margin requirements. Many traders — especially those coming from equities — get this badly wrong and end up with far more risk than intended.
Here's what the terms mean:
The minimum price movement of the contract. For ES (E-mini S&P 500) this is 0.25 points. Each 0.25-point move is one "tick."
The dollar value of each tick. For ES, one tick = $12.50. So a 4-tick ($1 point) move = $50 per contract.
For ES, each full point = $50. So the multiplier is $50. A 10-point move = $500 per contract.
The deposit required to hold one contract overnight (initial margin) or intraday (often lower). ES initial margin is ~$12,000.
The Futures Calculator lets you enter all these specs and calculates: exact contract count based on your dollar risk, notional value of the full position, margin required, and how much of your account that margin represents. It also includes a hard check: maximum contracts allowed by margin, so you can never accidentally open a position you can't afford to hold.
The Futures Specs Reference sheet (Tab 14) lists the tick size, tick value, multiplier, and margin for 25+ common contracts so you can look up ES, NQ, CL, GC, 6E, ZB and more without leaving the spreadsheet.
📡 ATR-Based Position Sizing — The Professional Method
Most position sizing calculators ask you to enter a stop loss price. But how do most traders set that stop? Usually by guessing, drawing a line on a chart, or placing it at a round number. That's not a strategy — that's hope.
Professional traders size positions using the Average True Range (ATR) — a volatility measure that tells you the average distance price moves in a typical session. Instead of placing a stop at "$2 below entry because that looks right," you place it at "2 × ATR below entry" — meaning your stop is always calibrated to current market conditions.
When a stock is in a calm, low-volatility phase, ATR is small and your stop can be tight — allowing you to take a bigger position. When volatility spikes (earnings season, macro events), ATR expands and your stop widens — automatically reducing your position size to compensate. This is the way professionals manage position sizing dynamically.
The ATR sheet includes a built-in OHLC data calculator — enter up to 30 days of high, low, and close prices and the ATR calculates automatically (using the proper Wilder formula with True Range = MAX of High-Low, High-PrevClose, Low-PrevClose). You can then link that calculated ATR directly to the input cell so everything updates in real time.
There's also a multiplier sensitivity table — showing you what happens to your share count and R:R if you use a 1×, 1.5×, 2×, 2.5×, or 3× ATR multiplier side by side, so you can make an informed decision rather than a gut-feel one.
🔺 The Scale-In / Pyramid Calculator
A pyramid trade (also called scaling in) is when you add to a winning position as the trade moves in your direction. Done correctly, it's one of the most powerful ways to compound gains on strong moves. Done incorrectly, it turns a winning trade into a losing one.
The core challenge is that every time you add to a position, your blended entry price changes, your total dollar risk changes, and your actual R:R ratio is different from what it was on your first entry. Most traders don't track this in real time — they just feel like they're "in a good trade" and keep adding.
Enter up to 5 entry levels with individual stop levels. The sheet automatically calculates the weighted blended entry price, total dollar risk across all legs (using the final stop), true blended R:R ratio, and exact P&L if the target is hit or the stop is triggered. The sizing uses an equal-risk-per-entry method by default, allocating 1/5 of your total risk budget to each potential entry.
The sheet also includes a strategy guide explaining six common pyramid methods, and a 7-rule checklist with the non-negotiables — including the most important rule: never add to a position that is currently at a loss.
📈 The Compounding Growth Projector
This is the sheet that makes traders truly understand why consistent risk management matters — not just in theory, but in dollar terms they can see.
Enter your win rate, R:R ratio, risk per trade, and starting balance. The sheet projects your account balance over 500 trades under three scenarios simultaneously: conservative (−5% win rate, −0.5R), your base strategy, and aggressive (+5% win rate, +0.5R). A live embedded chart shows all three growth curves.
What this chart reveals is profound: a small difference in win rate or R:R ratio — just 5% and 0.5R — creates a massive divergence in outcomes over 500 trades. The aggressive scenario ends up with several times more capital than the conservative one, starting from the exact same place.
The sheet also shows: trades needed to double your account, trades needed to 10× your account, a milestone tracker for custom target balances (your custom goals), and the expected gain per 100 trades under each scenario.
📉 The Drawdown Recovery Calculator
Every trader experiences drawdowns. The question isn't whether you'll have a losing period — it's whether you understand the math well enough to trade through it intelligently.
The Drawdown Recovery sheet addresses three critical questions that most traders can't answer about their own accounts:
Enter your starting balance, current balance (or just type in a drawdown percentage), your win rate, R:R, and risk per trade. The sheet calculates: the exact gain percentage needed to recover, how many dollars that represents, estimated number of trades at your strategy's expected value, probability of your worst-case consecutive loss streak occurring in your next 100 trades, and the account balance after that streak.
It also generates recommended daily and weekly loss limits — circuit breakers based on your risk settings that prevent one bad day from becoming a catastrophic week. The full 16-row asymmetry reference table shows every drawdown level from 5% to 90% with the recovery % needed, colour-coded by severity.
💀 The Risk of Ruin Calculator — Advanced Traders Only
Risk of Ruin (RoR) is the statistical probability that your trading account will fall below a defined "ruin threshold" before reaching your profit goal. It's one of the most important numbers in professional trading — and almost no retail traders know theirs.
The formula used is the Vince/Tharp normalised-edge method:
The sheet shows your RoR as a large number at the top (for example, "3.2%" at 1% risk / 55% WR / 2R), plus four stress test scenarios showing what happens to ruin probability if your win rate drops 5%, your R:R compresses to 1.5R, you cut risk in half, or you double your risk. These stress tests are critical — they show you whether your strategy is robust or fragile.
| WR ↓ / Risk% → | 0.5% | 1.0% | 1.5% | 2.0% | 2.5% | 3.0% |
|---|---|---|---|---|---|---|
| 40% | 78.4% | 96.1% | 99.1% | 99.8% | ~100% | ~100% |
| 50% | 12.1% | 38.4% | 62.7% | 79.5% | 89.2% | 94.6% |
| 55% | 0.8% | 3.2% | 9.8% | 21.4% | 38.6% | 56.2% |
| 60% | <0.1% | 0.3% | 1.1% | 3.9% | 11.4% | 24.8% |
| 65% | <0.01% | <0.1% | 0.1% | 0.4% | 1.6% | 5.9% |
Look at that grid carefully. At 55% win rate risking 3% per trade, your probability of ruin exceeds 56%. At 1% risk, it drops to 3.2%. That is the difference between a trading career and a blown account. The sheet shows this matrix live — updated in real time as you change any input — with a safe zone finder telling you the exact maximum risk percentage to keep your ruin probability below 1% and below 5%.
🔥 Portfolio Heat Monitor — Total Exposure at a Glance
Here's a scenario that happens constantly: a trader carefully limits each individual trade to 1% risk. But then they have five positions open simultaneously — all in tech stocks, all in the same direction. Total exposure: 5% of account. If the sector drops, all five positions hit their stops at once. The trader thought they were being disciplined. They were actually overexposed.
Portfolio heat is the total percentage of your account at risk across all open positions at any given moment. Professional traders set a maximum heat — typically 4-6% — and never exceed it regardless of how good individual setups look.
The Portfolio Heat Monitor tracks up to 10 open positions. Enter symbol, direction (LONG/SHORT), entry, stop, and share/contract size for each position. The sheet auto-calculates dollar risk per position, percentage heat per position, and total portfolio heat against your user-defined maximum. Status warnings appear automatically: ✓ OK, MODERATE, ⚠ HIGH, and 🚨 OVER LIMIT.
📐 The Kelly Criterion — What the Math Says
The Kelly Criterion is a mathematical formula developed by John Kelly at Bell Labs in 1956. It answers the question we started with: given a known edge, what fraction of your bankroll should you bet to maximise long-term geometric growth?
32.5% sounds shockingly high — and it is. Full Kelly produces maximum theoretical growth but also severe drawdowns that most humans can't handle psychologically. That's why professional traders use Half-Kelly (50% of the full Kelly value), which in this example would be 16.25%.
But even Half-Kelly at 16% is aggressive for most traders. The Kelly Criterion is best used as a ceiling — if your Kelly value is 5%, you know for certain you should never risk more than 2.5% per trade. The sheet shows both Full Kelly and Half-Kelly dollar amounts, a win-rate reference table, and includes an important caution: Kelly assumes accurate knowledge of your win rate and R:R — in practice, these estimates are noisy, which is another reason to trade below Kelly, not at it.
📅 The P&L Calendars — Track What You Can't Manage
There's an old management principle: you can't manage what you don't measure. The monthly and annual calendar sheets turn your trading history into something you can actually see and analyse at a glance.
The Monthly P&L Calendar builds automatically for any month and year. Enter daily P&L and trade count in a simple table to the right, and the entire calendar grid populates. Days turn green when profitable, red when not. Weekly totals appear on the right edge. Stats at the bottom — win rate, profit factor, best day, worst day, average win, average loss — calculate automatically.
The 12-Month Year View shows all 12 months simultaneously in a 4×3 tile grid. Each tile shows P&L, trade count, win/loss day breakdown, win rate, and best/worst day. The same green/red colour logic applies. Two embedded bar charts — one for monthly P&L, one for win day rate — update live as you enter data. This is the sheet you screenshot at year-end.
📓 The Trade Journal — Where Improvement Lives
Journaling is the single most underrated practice in trading education. Every professional trader journals. Most retail traders don't — and that gap is one of the primary reasons the performance gap exists.
The Trade Journal logs 20 trades per page (expandable) with: date, symbol, instrument type, entry, stop, target, exit price, share/contract size, setup name, and notes. For each trade it auto-calculates: dollar P&L, percentage return, R multiple achieved, and WIN/LOSS/BREAKEVEN status.
At the bottom, seven performance statistics update automatically: total trades, winners, losers, win rate, total P&L, average R achieved, and profit factor.
Profit factor = total gross profit ÷ total gross loss. A profit factor above 1.0 means you're profitable. Above 1.5 is considered good. Above 2.0 is excellent. It's a single number that captures both your win rate and the size of your wins relative to losses — far more useful than win rate alone.
Part 4: How All 14 Sheets Work Together
The PRO Position Sizing Suite isn't just a collection of independent calculators — it's a complete trading risk management workflow:
Part 5: Who Is This For?
Start with professional habits. Most traders learn position sizing the hard way — after a blown account. This tool lets you skip that lesson.
Funded account rules are strict. Know your maximum heat, daily loss limit, and drawdown recovery path at all times — before the firm enforces it for you.
Move faster with a pre-built calculator that handles tick math, ATR stops, and heat monitoring simultaneously — so you spend time on setups, not spreadsheet math.
Tick values, contract multipliers, and margin — it's all handled. The Futures Specs Reference lists 25+ contracts so you never have to look it up again.
- Microsoft Excel 2016 or newer
- Excel 365 (Windows or Mac)
- No macros required
- No add-ins required
- No internet after download
- Google Sheets: not recommended
Final Thoughts
The best entry in the world doesn't protect you from over-sizing. The most accurate technical analysis means nothing if one bad trade can wipe out months of gains. Position sizing is the unsexy foundation that makes everything else work — and it's the skill that almost every successful long-term trader cites as their most important edge.
The PRO Position Sizing Suite gives you 14 tools in one file: everything from basic share-count calculation to the probability your account hits ruin. Whether you're just starting out or you've been trading for years and want to get systematic about risk, this spreadsheet will change how you approach every trade.
Open it. Change the blue cells. Trade with precision.
Get the PRO Position Sizing Suite
14 worksheets · 868+ live formulas · Stocks + Futures · One-time purchase
Instant digital download · No subscription · Yours forever
Day trader, trading educator, and creator of the PIK indicator suite. Teaching traders to protect capital and compound gains systematically since 2018.
Disclaimer: Trading involves substantial risk of loss and is not appropriate for all investors. Past performance is not indicative of future results. The content in this post is for educational purposes only and does not constitute financial advice. Please read our full risk disclosure at PriceIsKing.com before trading.