Pricing
Book a Demo
Features
Find opportunities
Real-time quotes in Excel
Options pricing
Option Profit Calculator
Historical data
Screener
Stock Ranks
ETF Database
Analyze and optimise portfolios
Economic Indicators
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
1000+ Functions
Portfolio Report Builder
Templates
Guru screens
Track & manage
Real-time quotes in Excel
Analyze and optimise portfolios
Historical data
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
Option Profit Calculator
Options pricing
Collaborate
Spreadsheet Builder
Share watchlists
Share Screens
Share Templates
Learn
Blog
Videos
Templates
Public screens
Functions
Templates
Pricing
Help
Questions? Call us Toll-Free
Knowledge Library
Functions
Templates
Frequently Asked Questions
Video Tutorials
Discord
Blog
Contact Us
Blog
1-877-778-8358
Book Demo
← Back to Templates
Historical IV Calculator
Created by MarketXLS
Last updated: 6/23/2025
Description
Template Screenshots
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? Watch Demo
Download Template
Similar Templates
How to use QM_List function to get OptionChain and Interval Data
Real-time RSI calculator excel
Annual Financial Snapshot Template
MarketPulse Dashboard
Volatility Calculator
Related Formulas
ƒ(x)
Historical IV (Options)
Returns the implied volatility (IV) for an option on a speci...
ƒ(x)
Accounts Receivable (Historical)
Returns the amount of money due to a company in the short-te...
ƒ(x)
Accumulated Other Comprehensive Income (Historical)
Returns the total unrealized gains and losses on investments...
ƒ(x)
Basic EPS From Cumulative Effect Of Accounting Chg (Historical)
Returns the company's earnings per share (EPS) specifically ...
ƒ(x)
Cash And Equivalents (Historical)
Returns the value of cash and cash equivalents, which are hi...
ƒ(x)
Cash and Equivalents USD (Historical)
Returns the value of cash and cash equivalents in USD. Cash ...
ƒ(x)
Cash From Disc Financing Activities (Historical)
Returns the cash flow generated from terminated financing ac...
ƒ(x)
Cash From Disc Investing Activities (Historical)
Returns the cash flow generated or consumed from discontinue...
ƒ(x)
Cash From Disc. Financing Activities (Historical)
Returns the cash from discontinued financing activities for ...
ƒ(x)
Cash From Disc. Investing Activities (Historical)
Returns the cash proceeds generated by a company from its di...