Evaluation of a Stock

Analysis Goals

• Highest Price ever
• Lowest Price ever
• Standard deviation
• Highest Price Movement
• Lowest Price Movement
• Daily volatility + Average daily volatility

Functions

• Standard deviation ------ to predict the future price range of this stock.

=STDEV.P(C2:C272)

• Calculate the absolute value of change%. =ABS()

         Why use absolute value? Because 1% is higher than -10%. But the goal is to calculate the biggest movement.   -10% movement is bigger than 1%. 
  

• Daily volatility + Average daily volatility ----- Difference between the highest price and lowest price