# Technical Studies Reference

### Historical Volatility Ratio

This study calculates and displays the Historical Volatility Ratio of the Close Prices.

Let $$C$$ be a random variable denoting the Close Price, and let $$C_t$$ be the value of the Close Price at Index $$t$$. Then we compute the Logarithmic Return (which is defined in the Volatility - Historical study) of $$C$$ for $$t > 0$$ as follows.

$$\displaystyle{LR_t(C) = \ln\left(\frac{C_t}{C_{t-1}}\right)}$$

Let the Inputs Short Length and Long Length be denoted as $$n_S$$ and $$n_L$$, respectively, and let $$LR$$ be a random variable denoting the Logarithmic Return for $$C$$. The Standard Deviations of $$LR$$ with Lengths $$n_S$$ and $$n_L$$ at Index $$t$$ are denoted as $$\sigma_t\left(LR,n_S\right)$$ and $$\sigma_t\left(LR,n_L\right)$$, respectively. $$\sigma_t\left(LR,n_S\right)$$ is calculated for $$t \geq n_S$$, and $$\sigma_t\left(LR,n_L\right)$$ is computed for $$t \geq n_L$$.

The Historical Volatility Ratio at Index $$t$$ for the Closing Prices and the given Lengths is denoted as $$HVR_t\left(n_S,n_L\right)$$, and we compute it in terms of these Standard Deviations for $$t \geq n_L$$ as follows.

$$\displaystyle{HVR_t\left(n_S,n_L\right) = \frac{\sigma_t\left(LR,n_S\right)}{\sigma_t\left(LR,n_L\right)}}$$

#### Spreadsheet

The spreadsheet below contains the formulas for this study in Spreadsheet format. Save this Spreadsheet to the Data Files Folder.

Open it through File >> Open Spreadsheet.

*Last modified Friday, 09th February, 2018.