MarketXLS

Implied Volatility 90 Day

Returns the 90-day implied volatility (IV) for a given stock symbol. This represents the market's expectation of price movement over the next 90 days (approximately one quarter).

What is 90-Day IV?

The 90-day implied volatility is derived from options prices with approximately 90 days to expiration. It's commonly used for:

  • Quarterly earnings plays
  • Medium-term options strategies
  • Volatility term structure analysis

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
StartDate No Historical date to retrieve IV from

Notes

  • IV is expressed as a decimal (0.25 = 25%)
  • Useful for quarterly options strategies
  • Compare across time periods to understand term structure

Syntax

=ImpliedVolatility90d(Symbol, [StartDate])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

startDatedate

Optional historical date to get IV from that date

Returns

number

90-day implied volatility as a decimal

Examples

=ImpliedVolatility90d("AAPL")
Current 90-day IV for Apple
=ImpliedVolatility90d("TSLA")
Current 90-day IV for Tesla
=ImpliedVolatility90d("QQQ")
Current 90-day IV for Nasdaq ETF
=ImpliedVolatility90d("AAPL", DATE(2024,1,15))
Historical 90-day IV
=ImpliedVolatility90d(A1)
Symbol from cell reference

When to Use

  • Quarterly volatility analysis
  • Options strategies spanning 3 months
  • Earnings season volatility assessment
  • Volatility term structure comparison
  • Risk management for quarterly positions

When NOT to Use

Scenario Use Instead
Need shorter-term IV ImpliedVolatility30d() or ImpliedVolatility60d()
Need longer-term IV ImpliedVolatility6m() or ImpliedVolatility1y()
Need actual price movement HistoricalVolatility()
Need specific option IV Option_IV()

Common Issues & FAQ

Why am I getting "NA"?

Check that:

  • The symbol is valid and has options trading
  • The stock has sufficient options liquidity at 90-day expiration
  • For historical dates, options data exists for that period

How does 90-day IV compare to 30-day IV?

90-day IV typically differs from 30-day IV due to term structure. Usually:

  • In normal markets, longer-term IV is slightly higher
  • Before earnings, shorter-term IV may spike above longer-term

How do I interpret the value?

The value is a decimal representing annualized volatility. Multiply by 100 for percentage (0.30 = 30% expected annual move).

Related Formulas

More MarketXLS Options formulas you can use in the same worksheet:

See ImpliedVolatility90d used in a complete workbook: Implied Volatility Data MCP: Pull Live IV, IV Rank and Term Structure Into Excel and Any AI Assistant

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Implied Volatility 90 Day and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions