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