Historical IV Calculator
Historical Volatility template helps investor to gauge the risk exposure of the option with given strike and expiry date. The historical volatility can also be used as an input to Black Scholes Model to calculate the value of call/put option.

Created by: MarketXLS
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Call: 1-877-778-8358
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.
Get started today
Get started today