The World's First Pro Black-Scholes-Merton 10x Leg Option P/L Strategiser

The BSM 10x Leg Option P/L Master Strategiser Numbers Spreadsheet: Unlock the full potential of your trading strategy whilst tracking your open net Profit and Loss on up to 10 Option Legs, while mastering key Greeks — Delta, Gamma, Theta, Vega, and Rho — along with cumulative Greek calculations for comprehensive risk analysis. Gain insights into each position's Breakeven point, Cumulative Breakeven for multiple positions, and Expected Moves along with critical metrics like OTM (Out of the Money) probabilities.

The Strategiser features 10 dedicated Black-Scholes-Merton (BSM) calculators, each working independently to deliver accurate option pricing. With intuitive chart drop-down menus, you can quickly generate charts that display Option Price and Profit & Loss data live at the current moment (@Now) and at expiry (@Expiry) — both for individual legs and cumulatively for up to 10 legs.

In addition to detailed price and P&L analysis, the calculator includes Greek charting to help you monitor key risk metrics. A separate sheet also offers 30 individual BSM calculators (organised into 3 rows of 10), the top two mirroring the Initial and Scenario positions and a lower row to calculate new trades enabling precise P&L forecasting across multiple positions.

The Apple Numbers BSM Option Master Strategiser Spreadsheet can handle up to 10 different option or underlying asset positions/legs. Despite the size of the spreadsheet, you actually only need to open the spreadsheet large enough to display the top two tables and lower blue chart to gain all the relevant info you need on your strategy. If you want a quick assessment of the Greeks you can scroll right to the green charts and display Greeks data as well. You can "look under the hood" because the sheet is unlocked and customisable.

The top tables allow for easy input of values like Strike, DTE, and I.V. in the blue fields. It then calculates the Premiums, Fees, and Profit & Loss results, displaying them in the green fields for easy reference. A full set of instructions is included in the workbook along with an Options Strategy List.

Using the sophisticated Black-Scholes-Merton model (factoring in dividends) for precise option pricing you can stay ahead with a clear understanding of your Maximum Profit and Maximum Loss potential.

Note: Although there are 6x initial Strategy and 6x Scenario Strategy Charts, only the top two left tables and one blue and green chart are necessary to display a multi-legged strategy.

There are two BSM input tables: The top left blue bordered "Initial" table accepts BSM inputs such as Strike, DTE, I.V., etc. in the blue fields and calculates the Premiums, Fees, and Profit & Loss results, which are displayed in the tables green fields. The Initial table tracks your original Option Legs. In addition to the tables calculating the Greeks and BSM Option Prices (with Merton derived Dividends), there are fields to enter your own Option Prices if your Broker is offering a very different premium to the BSM derived Option Price. This allows Profit and Loss calculations in the next brown bordered table (to the right of the Scenario table) to be made as usual.

Any changes to the Implied Volatility (I.V.) can also be updated and the tables and charts will integrate the change, as it will for any of the other normal BSM input (Underlying Asset Price, IR's, DTE) adjustments.

The top right green bordered "Scenario" table allows you to model "What if" Scenarios by changing any of the BSM input data (including closing an Initial e.g. Short Call Option and opening an e.g. Long Call position). There are 6x blue charts showing the Initial Option Legs and 6x green charts displaying the Scenario Option Legs, allowing you to directly compare Profit and Losses resulting from e.g. a Scenario 20% crash in Underlying Asset Prices or if you need to "Roll Out" your Initial Option Legs in time by changing the Expiry Dates in the Scenario table.

Note the Underlying Asset Price can be coded to provide the Yahoo Finance live prices too. Look out for yellow triangle Comments that instruct and educate.

Six Chart Drop Down Controllers allow for quick simple Drop Down selection and plotting of any instrument whether the Underlying Asset (for Hedges against open Option Legs), Long or Short Option Legs, or Greek derivatives, with 6 Charts available. Look for the orange >> arrows to know which Drop Down cells to select.

Legs are additive or accumulative. This means if you want to plot a Jade Lizard (Sell to open a Short "Out the Money" Call and Put and open to buy a Long Call above the Short Call), then as long as the top blue bordered Initial Table has Leg #1 set to a Long Call, Leg #2 set to a Short Call and Leg #3 set to a Long Call, you would go to Controller: "Leg1-3 Price/P&L" and plot the Price @Now and @Expiry (or the P/L @Now and Expiry) on the Chart.

Note the Controller automatically displays the Option Type and Strike for (Leg) L1, L2 and L3 at the top along with the number of contracts (1 contract in this example).

Drop-down menus allow for rapid plotting of real-time and expiry-based P&L, giving you the clarity you need to make informed decisions quickly. I designed this tool to be more than just a calculator — it's a strategic asset. You'll get full Greek analysis, comprehensive risk metrics, and a separate sheet with 30 BSM calculators, 20 of which mirror the Option Legs in the Initial and Scenario Tables and Controllers to forecast potential outcomes with confidence.