How to calculate implied volatility with excel

First we go and acquire de data.

On S we put the place for the stock or index or whatever we search for. In this case for example the price of S&P 500 it was 3009.05 today.

Then we select a1 month option with price close to ours, for example 3010

After that we select the interest rate for our risk free .

Finally we have to search for a sigma that makes our observed price igual t the black scholes option price.

When we finish with all then we can calculate the deviation and see how much it can go down and up our stock.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: