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
Examples
=ImpliedVolatility90d("AAPL")=ImpliedVolatility90d("TSLA")=ImpliedVolatility90d("QQQ")=ImpliedVolatility90d("AAPL", DATE(2024,1,15))=ImpliedVolatility90d(A1)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
Q: Why am I getting "NA"? A: 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
Q: How does 90-day IV compare to 30-day IV? A: 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
Q: How do I interpret the value? A: The value is a decimal representing annualized volatility. Multiply by 100 for percentage (0.30 = 30% expected annual move).
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?