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

(Last Updated On: September 17, 2014)
Learn the Secret

Get  our 2 Free Books

Get these now which land directly to their inbox.
Invalid email address

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!
This entry was posted in Quant Analytics on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at