Historic Volatility

There are four calculation models to evaluate the historical annualized volatility of an asset based on historic price samplings. The Historical Volatility is a statistical calculation that calculates how rapid price movements have been over a given time frame using the Standard Deviation method.

The FinOptions XL function VolatlityCloseToClose calculates the Historic Volatility given a range of closing prices.

The FinOptions XL function VolatilityHighLow calculates the Historic Volatility given a range of high and low prices.

The FinOptions XL function VolatilityHighLowClose calculates the Historic Volatility given a range of High, Low and closing prices.

The FinOptions XL function VolatilityHighLowOpenClose calculates the Historic Volatility given a range High, Low, Open, and closing prices.

Interpolation

Calculating the Y value based on an X value given a range of known X and Y values can be determined with the interpolation function. The interpolation function can be used in conjuction with the various option models.

The FinOptions XL function Interpolation can be used to interpolate between various data points with either a linear or cubic-spline approach.