## How to make use of the peg ratio

In this post I am going to explain the steps to make use of the peg ratio for a stock. I choose APPLE for this example We take first the data, using only the close price (financial yahoo for example to download). Next we go on ychart and download the peg ratio for Apple AndContinue reading “How to make use of the peg ratio”

## How to calculate ATR

The Average True Range (ATR) of an asset is a historical volatility indicator that calculates the average of a number of previous True Range values. The True Range (TR) of an asset can be defined as follows: ATRx = (TRt + … + TRt-x) / Opent-x Where: ATRx – Rolling x-day Average True RangeTRt –Continue reading “How to calculate ATR”

## 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”