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

dow jones vixexcel normdistsquare root of 3.24bull call spread graphformula for kurtosis in statisticsusing natural log in excel14 day rsiwacc meaningvelocityshares tvixwhat is straddle positiondirectional options strategiesvix exchangeaverage true range formulavariance formula derivationstandard deviation without calculatormerits and demerits of central tendencyoption profit loss calculatorrsi oscillatorblack scholes theorywhat is sampling variationcalculation of waccvix option chainoptions futures and other derivatives solution manualnegative kurtosisstock option intrinsic valueoption spread calculatormacd divergencecanadian currency etfhow the vix is calculatedsell straddleatr average true rangeexcel formulas explainedreverting meansnotepad themesblack scholes model calculatorvariance and std deviationcalculate the sample varianceweighted average cost of capital formula examplecalculator with negative signshow do you calculate standard deviation on excelblack scholes model explainedexcel implied volatilitycalculating standard deviation on a calculatorstock price volatility formulasqrt rulesrho calculationcalculating std deviationcalculating volatility of stockunbiased variance formuladelta hedging options examplebackwardation curvesec hedge fund filingscalculating option deltavar value at risk calculationvix futures pricesleveraged etfs listhedge fund definition examplecurrency etfsoptions on vixcalculating standard deviation excelexcel formulas for stock tradingj welles wilderweighted average cost formula inventoryrsi meanssvxy etfdelta adjusted exposure calculationshort payoff definitioncalculate sharpe ratio excelwhen do vix options expireweighted average method calculatorblack-scholes option valuation modelcalculating the sample variance