Implied Volatility Calculator

  • 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
Implied Volatility Calculator
  • Works with both European and American options, dividends, commodity/FX options
  • Works in all versions of Excel (from Excel 97 to Excel 365), Excel for Mac, Google Sheets, LibreOffice, OpenOffice and other spreadsheet software (see available versions)
  • Very simple navigation – start using it immediately
  • Detailed user guide if you need to know more
Download Now

$39 one-time payment
Instant download

How It Works & Screenshots

Select call or put. Enter strike, underlying price and option price. You may also enter dividend yield and interest rate.

enter prices

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.

time to expiration

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.

iv results

With the chart you can model the effects of volatility changes on option price or individual Greeks.

chart settings

The example below shows the effect of volatility changes on a (slightly-in-the-money) call option's delta.

iv effect on 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.

Download Now

$39 one-time payment
Instant download

Available Versions

All users get access to all these versions:

  • IVC.xlsm = default version, for Excel 2010 or newer, also including Excel for Mac
  • IVC_for_Excel_97-2007.xls = for Excel 2007 or older
  • IVC_ODF.ods = open document format version, for Google Sheets, LibreOffice, OpenOffice, and similar apps which don't support Excel VBA and macros

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 the latest, 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?
There is also an open document format (ods) version, which has been tested in Google Sheets, LibreOffice, and OpenOffice, and should work in all spreadsheet software which supports the ods format. All users get access to all versions.

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.

Download Now

$39 one-time payment
Instant download

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.

By remaining on this website or using its content, you confirm that you have read and agree with the Terms of Use Agreement.

We are not liable for any damages resulting from using this website. Any information may be inaccurate or incomplete. See full Limitation of Liability.

Content may include affiliate links, which means we may earn commission if you buy on the linked website. See full Affiliate and Referral Disclosure.

We use cookies and similar technology to improve user experience and analyze traffic. See full Cookie Policy.

See also Privacy Policy on how we collect and handle user data.

© 2024 Macroption