Mathestate Logo


Volatility Measured from Daily High / Low

On the volatility page, we showed the graph below depicting the relationship to stable gamma and the VIX.  The calculation of the stable gamma from one-minute intra-day prices, requires access to a lot of data that generally isn't available in historical data bases for long time frames.  We have found that the same information may be obtained from the daily high and low prices which are available for many years in the past.

Graphics:VIX - Blue SPY Stable γ - Red

The plot below shows the logarithm of the ratio of the intra-day high price to the intra-day low price.  This information is readily available from historical databases going back for many years.  Also on the plot in red is the same Stable γ plot, rescaled to be consistent with the Log[High/Low].  The Stable γ plot is below the Log[High/Low], so it is somewhat obscured by the slightly higher variability of the Log[High/Low] data, but the information is clearly the same.

Graphics:Log[High/Low] - Blue SPY Stable γ - Red

Below is an autocorrelation plot for the two measures and indeed they both show the same high degree of serial dependence.

Graphics:Log[High/Low]  -- Blue Stable γ  -- Red

Despite the significant serial dependence in the structure, we looked at the histogram of the data and a generalized extreme value (GEV) fit. The log[high price/low price] represents a maximum of the Log[price] - Log[low price] for each price of a day, what is lost is the order of prices, so this represents a maximum price range of many prices during the day; consequently extreme value analysis seems appropriate.

Graphics:SPY Log[High/Low] GEV Fit

GEV parameters {μ , σ, ξ}
{0.013831, 0.00756971, 0.355292}

Below is a GEV fit to the Stable γ, which on other pages we have modeled with a lognormal distribution, without much rationale.  It may well be that the GEV is a better model.  Note that the shape parameters, ξ, for the two plots are quite close and that they differ only by location and scale parameters, μ and σ.  The ξ parameter of less than 0.5 indicates that these are light tailed distributions.  Thus we think the Log[High/Low] should be an excellent measure of volatility, which is easily accessible.

Graphics:SPY Stable γ GEV Fit

GEV parameters {μ , σ, ξ}
{0.000275401, 0.000133989, 0.329263}

The measure can also be sampled different intervals below it is shown at weekly intervals.

Graphics:Weekly Log[High/Low]

The fit below shows the weekly results (a much smaller sample) for the same time interval.  The ξ parameter is a little lower.  In general, we expect that these should be self-similar distributions and that they should scale according to the sampling interval.  Since these distributions seem to be consistently in the Frechet maximum domain of attraction, we expect that the GEV parameters should scale according to HighLowVolatility_7.gif= μ HighLowVolatility_8.gif and  HighLowVolatility_9.gif= σ HighLowVolatility_10.gif where n is the  sampling interval.

Graphics:SPY Weekly Log[High/Low] GEV Fit

GEV parameters {μ , σ, ξ}
{0.0355549, 0.0173166, 0.294231}

Below is a look at a long term plot of weekly volatility.

Graphics:SPY Weekly Log[High/Low]

We have been working on an experimental site to do calculations on volatility on individual securities.  It may not always be operational, but when it is you may try it: click here.


© Copyright 2011 mathestate    Tue 8 Feb 2011