Sizing tools: software vs spreadsheet

The chapter ends with the tool

Every concept in this chapter — fixed fractional sizing, ATR adjustment, correlation penalty, portfolio heat, de-leveraging, scaling — lives or dies based on whether you can actually execute it under pressure. That means you need a tool. Pros use dedicated risk-management software. Retail traders need a spreadsheet. The difference matters less than you'd think.

What does the pro software do? Real-time risk dashboards, intraday correlation matrices, compliance gates that block oversized orders, value-at-risk monitoring across an entire book. It's beautiful, it's necessary at scale, and it costs more per month than a beginner trader's whole account. It's also massive overkill for anyone running fewer than 20 simultaneous positions.

What a working retail spreadsheet looks like. Five columns: Instrument, Entry, Stop, Account Equity, Risk %. Two computed columns: Stop Distance (= Entry - Stop), Position Size (= Account × Risk% / Stop Distance). One summary cell at the bottom: Total Heat (sum of risk amounts across all open rows, divided by account equity). That's it. Build it once, use it forever. The formula in the position-size cell is the exact formula from lesson one of this chapter — the entire toolkit collapses into one cell of math.

Layer in the chapter's other tools as needed. Add a column for ATR if you want volatility adjustment. Add a column for 'bucket' (Euro, tech, gold, etc) to apply correlation haircuts manually. Add a row at the top with your current de-leveraging tier so the risk% column auto-cuts when you're in drawdown. None of this requires software. It requires building the habit of opening the spreadsheet before every entry. Recap: dedicated software pays off past 20 simultaneous positions or six-figure accounts. Until then, the spreadsheet is the tool — and the discipline of using it is more important than the tool itself.