Using the market price for an option on Google's stock, I 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. For more financial risk videos, visit our website! http://www.bionicturtle.com
