fbpx

Is this the easiest way to calculate Implied Volatility with Excel?

(Last Updated On: September 17, 2014)

Is this the easiest way to calculate Implied Volatility with Excel?

I have always lke Bionic Turtle but it seems to be getting less popular which is a shame. This is always using Excel but do let me know if you think this is accurate. I am also looking for way to calculate with an option chain which can be downloaded from free Yahoo Finance.

According to this video description”

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 PRIE

Join my FREE newsletter to learn more about Imlied Volatility

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.
Scroll to Top