# Black-Scholes Calculator

• Instantly calculate call and put option prices in Excel
• Calculate and plot Greeks – delta, gamma, theta, vega, rho
• Analyse effects of different factors on option prices and Greeks
• Based on Black-Scholes model + Merton’s extension to account for dividends
• Works with both European and American options, also commodity/FX options
• Works in all versions of Excel from Excel 97 to Excel 2016
• Very simple navigation – start using it immediately
• Detailed user guide if you need to know more

\$25 one-time payment
Instant download

## How It Works & Screenshots

Enter parameters in the yellow cells: underlying price, strike price, volatility, interest rate, dividend yield. The user guide provides detailed explanation of each.

You can set time to expiration either as pricing date and expiration date, or as number of days remaining to expiration. The calculator also works with fractions of days to handle intraday pricing.

You will instantly see the resulting option price and Greeks. The Greeks, like delta, gamma, theta or vega, measure sensitivity of option prices to changes in the individual parameters and therefore are very useful for managing option positions. You can find detailed explanation of the Greeks in the user guide.

For even better understanding of your option’s exposure to different factors you can see the effects of changing underlying price, volatility or time to expiration in the charts.

For instance, the screenshot below shows the effect of time to expiration on a call option’s price and delta, demonstrating how this particular option will lose value as it gets closer to expiration.

You can control the charts in the chart settings area on the left.

The charts can display effects of any of the parameters on an option’s price and/or any of the Greeks.

You can also easily adjust the scale to zoom in or out.

The calculator helps you stay in control, understand the risks and behaviour of a position under any possible situation, and make faster and better decisions.

\$25 one-time payment
Instant download

## User Guide

Besides detailed step-by-step instructions for using the calculator, the guide also explains the assumptions and theoretical background of the Black-Scholes option pricing model, provides all the formulas for option prices and Greeks, and explains the particular Excel implementation.

### Black-Scholes Calculator Guide Contents

1. Quick Start …3
2. Main Sheet Overview …6
3. Calculating Option Prices …7
4. The Greeks …12
5. Simulations and Charts …16
6. Estimating Volatility …21
7. Option Pricing Model and Assumptions …24
8. Formulas Used …27
9. Calculation Area and Functions Used …29
10. Common Technical Problems …32
11. References …33
12. Contact and Terms of Use …34

More assistance is available via email support.

\$25 one-time payment
Instant download

## Frequently Asked Questions

Is it a one-time payment or monthly/recurring?
One-time payment, yours forever.

Does it work in my version of Excel?
The calculator works in all versions of Excel from Excel 97 to Excel 2016. It was developed in Excel 2010 and tested in other versions. For older versions you may need to use a different version of the calculator, which is also included.

Does it work in OpenOffice / LibreOffice / Apple Numbers / other spreadsheet software?
It may work in some, but unfortunately we can’t guarantee it and can’t provide support for software other than Microsoft Excel.

Are the formulas freely available?
Yes. The calculator only uses the basic built-in Excel formulas or their combinations. Everything is freely available, nothing hidden or password protected. You are free to change any formulas and customize the calculator.

How do I pay? Is it secure?
You can pay by credit/debit card or PayPal. All payments are processed by PayPal, which provides world-class security and buyer protection. You don’t need a PayPal account to check out when paying with a card.

I have other questions / need more information.
Please contact us.

\$25 one-time payment
Instant download

## Related Calculators – Often Bought Together

Implied Volatility Calculator – Does the inverse of the Black-Scholes Calculator: Calculates IV from option prices and helps you understand the essential volatility input.

Option Strategy Payoff Calculator – Good to learn about individual option strategies and their payoffs at expiration. Draws payoff diagrams; calculates max profit, max loss, risk-reward ratios and break-even points.

## Related pages

short vxx etfbutterfly spread payoff diagramvolatility calculation black scholesrho greekscoefficient of skewbasic black scholesvariance formula grouped dataoption straddle calculatorscholes option pricing modelproshares.comfinding the median calculatorreverse straddlevolatility calculatorfinance.yahoo.com historical priceshow to use the normdist function in excelfinance tvixexcel median calculationsp500 vixcontinuous dividend yield formulavix optionsannualized daily returnvix futures cboeeuro currency etfwhat is kurtosis and skewness in statisticsvix short termtheme notepad how to solve kurtosisannualizing volatilityshort straddleblack scholes model definitiongood sharpe ratiocalculate moving average exceldifference between population variance and sample variancemacd indicator settingsvix future priceshort call payoffbreak even volatilityvix hedgeproshares etf listimplied volatility wikidisadvantages of medianpayoff diagramcalculators with negativesblack scholes options calculatorsample mean calculatorput option strike pricestraddle option strategymean and variance calculatorhow to calculate weighted average of percentagescall options for dummiesformula for ungrouped databear put spread examplerealised volatility formulawacc formular2x s&p 500 etfat yahoo.com symbolvix futurestraddle calculatorbull put spread strategyhedge fund macro strategystoxx 50 europestd dev calculatorcalculating stock volatilityblack scholes analysisblack scholes standard deviationipath s&pmacd crossover indicatorcost accounting sumscovered call payoff diagramindexation calculatorskewness formula for ungrouped data