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.
Continue Reading
Premium Content
This tutorial is a part of the course Volatility. This is a premium course. The purchase options for the course are provided below. With this course, you get access to complete course content, source code, practical exercises, and all resources that are a part of the course.
Lifetime Premium Membership
$250
$179
Get unlimited access to all courses and premium content
What's Included:
Complete access to course content and updates
All downloadable resources
Interactive course quizzes
Practice exercises and sample code
Ad-free learning experience