The Prop Firm Drawdown Calculator: How to Build a Session Risk Model in a Spreadsheet

The session risk model spreadsheet does one thing: it turns the abstract rules (trailing drawdown, daily loss limit, consistency ceiling) into specific, actionable numbers before each session begins. Not "$3,000 maximum drawdown" as a concept — but "today, given where my floor is and what I've already made this cycle, I can risk $47 per trade at 2% of cushion, my consistency ceiling is $892, and my internal daily stop is at $640 loss."

Concrete numbers, calculated before the first trade, updated before subsequent trades. That's what the spreadsheet provides.

Section 1: Account State (Update Daily)

The first section captures the current account state. These are inputs you update each morning before the session:

Section 2: Calculated Risk Parameters (Auto-Compute)

These cells calculate automatically from Section 1 inputs:

Current Cushion: =B2-B3
The actual risk capital available today. This is what you're risking against, not the nominal account size.

Cushion % Remaining: =((B2-B3)/B4)*100
Shows cushion as a percentage of original maximum drawdown. Below 60% = yellow alert. Below 33% = reduce position size.

Per-Trade Risk $: =(B2-B3)*B8
Dollar amount to risk on each trade at the configured risk percentage.

Internal Daily Stop $: =B6*B7
Your internal daily loss trigger — the amount at which trading stops for the session, before reaching the firm's limit.

Consistency Ceiling (Apex-specific): =IF(B5>0, (0.30*B5)/0.70, "N/A")
Maximum single-day P&L this session before triggering the 30% consistency rule. Shows "N/A" for firms without consistency rules or when cumulative profit is zero.

Section 3: Session Trade Log

As trades execute through the session, log them in the trade tracking section:

The Status column is the operational trigger. "NEAR STOP" at 80% of the internal daily stop is the yellow flag — start being more selective. "STOPPED" triggers the end-of-session lock. "NEAR CEILING" at 85% of the consistency ceiling triggers the contract size reduction that the consistency dilution framework describes.

Section 4: Pre-Session Decision Summary

The final section generates a one-line summary for each session. Before the first trade, this section should read something like:

Session Date: [date] | Cushion: $2,600 (87%) | Risk/Trade: $52 | Daily Stop: $750 | Consistency Ceiling: $1,457 | Status: NORMAL

Everything you need for the session in one line. Print it, screenshot it to a second monitor, read it before the opening bell. The numbers were calculated in a calm, analytical state — the version of you that operates before the market is open and moving. Those numbers govern the version of you that's making decisions in a live session.

The spreadsheet can't make you follow the rules. But it can make the rules impossible to ignore — they're right there, specific and current, staring at you from a corner of the screen. That combination of specificity and visibility is most of what the pre-session risk model is for.