Volatility

The Volatility measures the risk or stock variability. It’s calculated using standard deviations on daily returns. When volatility increases, the risk increases as bigger changes in the stock price areexpected.

Syntax:

Volatility
Volatility()
Volatility(“Period”)
Volatility(“OutPutStartCell”, ”Period”)

Inputs:

'Close' column values

Parameters:

• Period (default=14)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

Volatility
Volatility()
Volatility(“14”)
Volatility(14)
Volatility(10)
Volatility(“G2”,”14”)
Volatility(“G2”,14)
Volatility(G2,”14”)
Volatility(G2,14)