Utilities

Navigation:  Available Functions >

Utilities

Previous pageReturn to chapter overviewNext page

 

The FinOptions analytics library has a comprehensive set of utility functions to leverage and enhance derivative evaluation that can be used in conjunction with the various option functions. The FinOptions library includes functions for evaluating historic volatility and interpolation of data points.

 

 

Utility Functions:

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.