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 selectContinue reading “How to calculate implied volatility with excel”

How to make use of distribution in financial markets using excel

In this example I am going to make a resume for the last 20 years approx in S&P 500 Here we have the average return with the different percentages, some descriptive details, the distribution of the data, the standard deviation, the average profits and so on. For this first I used the data from financialContinue reading “How to make use of distribution in financial markets using excel”