YouTrade24

Build an options trade and see its payoff before you place it

A free Excel workbook that combines options and stock into a strategy, graphs the profit and loss, and prices every leg. Try a simplified version beside this text.

Get the free workbook

Free. Enter your name and email and it is sent to you.

Try a strategy builder

A $100 share, 45 days to expiry. Pick a strategy and see what you could make or lose at expiry.

Strategy
Profit and loss at expiry for the chosen strategy A payoff chart showing profit above the zero line and loss below it, for share prices from 50 to 150 at expiry. 0 $50 $75 $100 $125 $150
You pay
–
Most you can make
–
Most you can lose
–
Break-even at expiry
–

Per share (multiply by 100 for one contract). Simplified: European options, no dividends, no commissions. Option prices are theoretical Black-Scholes values.

What is in the workbook

Three tabs, built around how option prices and payoffs respond to price, volatility and time.

  • Strategies Combine options and stock, up to ten components, and see how the whole position behaves.
  • PayoffGraphs Profit and loss profiles for buying or selling calls and puts, with settings you can change.
  • Basic Prices a single call or put, shows delta, gamma, theta, vega and rho, and solves for implied volatility from a market price.
  • Open for you to edit Two custom functions, OTW_BlackScholes and OTW_IV, work in your own sheets, and the VBA code is unlocked.

Get the workbook

It is free: enter your name and email and it is sent straight to you. The workbook includes macros, so Excel will ask you to enable them.

Get the free workbook