Options Strategy Payoff Calculator (Excel)

About this course

See exactly how an options trade makes or loses money before you place it. Enter up to six legs — calls, puts or futures — and the sheet draws the payoff, finds the breakevens and calculates the Greeks.

What's inside

• Builder — spot, lot size, days to expiry, IV and interest rate; six legs with include switch, type, buy/sell, strike, lots and optional market premium.
• Results — net premium, max profit, max loss (or 'Unlimited'), reward:risk, up to three breakevens and P&L today.
• Greeks — per leg and total position Delta, Gamma, Theta per day and Vega per 1% IV.
• Chart — payoff at expiry vs today across a ±% price range; 61-point payoff table.
• Strategy Library — 20 strategies (spreads, straddles, strangles, iron condor, butterfly, ratio spreads and more) with market view, legs, max profit/loss and when to use them.
• Loaded with a Nifty iron condor example (lot size 65).

Who it's for

• Nifty, Bank Nifty and stock options traders
• Students learning options strategies
• Anyone trading US or crypto options

Accuracy

Prices and Greeks use the standard Black-Scholes model; results were cross-checked against an independent calculation. Margin is not calculated — use your broker's margin calculator.

Format

Works in Microsoft Excel (2010 or later), Google Sheets and LibreOffice Calc. Instant download after payment — available any time in your account.