Working with Strike Price in the Black-Scholes Calculator

This page demonstrates how to enter the strike price input in the Black-Scholes Calculator and how to draw charts showing effects of strike selection on option prices and Greeks.

Entering Strike Price Input

Strike price is one of the six inputs required for option price calculation under the Black-Scholes model (the others are underlying price, volatility, interest rate, dividend yield, and time to expiration). All the inputs are set in the yellow cells in the upper left corner of the main sheet.

Enter strike price in the yellow cell C6.

Setting Strike Price Charts

The calculator can model effects of strike price selection on call or put option prices or any of the Greeks. To display a strike price chart, select “Strike price” in the combo box in cell C27. This selection decides which of the inputs will the on the X-axis, which is the same for both charts.

In the combo box in cell C25, select if you want to see the charts for a call or put option.

There are two charts (the upper chart with green line and lower chart with blue line). Both share the same X-axis and can display different values (option prices or the individual Greeks) on the Y-axes. To select each chart’s Y-axis, use the combo boxes in cells C33 and C35.

For example, you can select the upper chart to display delta for each strike and the lower chart to display theta for the same strikes. This can be useful when deciding which strike to use for a particular trade and allow you to consider both the option’s sensitivity to underlying price changes (delta) and the speed of time decay (theta) at the same time.

The chart’s scale is automatically calculated to cover the entire range of realistically possible strikes and show markers at round numbers. If you want to zoom in and explore a smaller area in more detail, you can override the automatic X-axis range in the yellow cells C29 (chart start – lowest strike displayed) and C30 (increment).

More Information

Detailed instructions for using all the calculator’s features are available in the user guide.

For more screenshots and overview of all features, see Black-Scholes Calculator main page.

If you have any questions, please feel free to ask.

Related pages

yahoo finance indicesweighted average method accounting formuladisadvantages of arithmetic meanmerits and demerits of arithmetic meanoption stradlecollar payoffsharpe ratio formula excelhow to calculate 95th percentile in excelwhat is rsi in stock marketarithmetic formulas in excelcompute implied volatilitymacd crossoversleptokurtic graphexplain skewnessexcel formula standard deviationgreeks gammadefinition of sharpe ratioimplied volatility black scholesmeaning of option contracthow to calculate ror in excelghi stockwhat is the meaning of skewnessstraddle positionsynthetic straddlecalculate sample mean in excelfinding the median calculatorstatistics median calculatoraapl earnings historydelta formulasetf correlationcalculation of market capitalizationblack scholes gammawhat is rsi in stock marketcumulative distribution function excelskewness calculationmomentum formulasdow jones weighting2x etf listimplied volatility calculationema excelshort put payoff diagramblack scholes excel formulaadvantages and disadvantages of measures of central tendencysharpe ratio explainedcosting accounting formulasstraddle deltaberkshire hathaway holdings changesswiss currency etfcalculate skewonline black scholes option calculatorcovariance calculation in excelsma calculatorweighted average costingformula for profit and loss in excelcalculating mean in excelestimating population mean calculator13f filings databaseskewness statistics definitionexcel formula square roottrading macd crossoverdef varianceultra short vixstandard deviation of a sample calculatormomentum indicator formulaoptions long straddlevixx etfhow to calculate variance using excelrisk not in varaapl implied volatilitydelta hedging formulavxz ipathoptions long straddlehedge fund forex strategys&p etf short