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 PRIEFACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!