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”

# Tag Archives: excel

## How to combine a spread trade with PMI

In this post I am going to show an example on how you can combine data from same industry/ different industries and compare it with ISM report to see if we can find some entries. We can apply this to any equities,indices, commodities and so on. In this case I am going to use JPContinue reading “How to combine a spread trade with PMI”

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