Using Excel's Goal Seek Function to Estimate Implied Volatility
Premium
In this video, you will learn how to estimate implied volatility. Using the market price for an option on Google's stock, the video demonstrates how to use Excel's GOAL SEEK function to estimate implied volatility. Implied volatility is a reverse-engineering exercise: we find the volatility that produces a Model Value = Market Price.
Unlock Premium Content
Upgrade your account to access the full article, downloads, and exercises.
You'll get access to:
- Access complete tutorials and examples
- Download source code and resources
- Follow along with practical exercises
- Get in-depth explanations