- Calculate implied volatility from option prices in Excel
- One click – quick, easy and accurate – much better than the trial and error approach
- Model effects of IV changes on option prices and Greeks
- Works with both European and American options, dividends, 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
How It Works & Screenshots
Select call or put. Enter strike, underlying price and option price. You may also enter dividend yield and interest rate.
You can set time to expiration either as current and expiration date, or as number of days left to expiration. Intraday is fine – the calculator can work with fractions of days.
Click the big button and see implied volatility immediately. It is shown annualized, as well as per month, per week, per day and for the time period left to expiration. You can also see the Greeks for the given option price and IV.
With the chart you can model the effects of volatility changes on option price or individual Greeks.
The example below shows the effect of volatility changes on a (slightly-in-the-money) call option’s delta.
Volatility is the most important factor driving option prices and thereby option trading success. This calculator helps you better understand volatility and work with it effectively when making decisions.
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, also including Office 365 and Excel for Mac. 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 I can’t guarantee it and can’t provide support for software other than Microsoft Excel. Generally you need your software to support Excel formulas and macros.
How do I pay? Is it secure?
You can pay by credit/debit card or PayPal. All payments are processed by PayPal, but you don’t need a PayPal account to check out when paying with a card. Contact me for alternative ways to pay (wire transfer, bitcoin).
I have other questions / need more information.
Please contact me.
Related Calculators – Often Bought Together
Black-Scholes Calculator – Does the inverse – calculates option prices when given implied volatility and the other parameters.
Option Strategy Simulator – Does the inverse for multiple options, allowing you to simulate strategies such as condors, straddles, spreads or covered calls.