Historical volatility with a pencil and ten prices

Ten closing prices, starting at £100 and finishing at £111. That's all the one-page volatility guide works with, and it's enough to get to an annualised figure of 24.5 per cent without opening a spreadsheet.

It's the first of three posts on volatility here, one a week, following the video series of the same name.

The prices run 100, 102, 101, 103, 105, 107, 110, 108, 109 and 111. Each neighbouring pair gives a log return, the natural log of today's price over yesterday's. Nine of them: 1.98, −0.99, 1.96, 1.92, 1.89, 2.77, −1.83, 0.92 and 1.82 per cent.

They average 1.16 per cent a day. Far too high for anything real, and on purpose: a series that climbs keeps the arithmetic tidy. With a year of real closes the daily mean comes out close to zero.

Then the spread around that average. Take the mean off each return, square what's left, add the nine squares and divide by eight, not nine. The square root of that is 1.54 per cent a day. Dividing by eight is the usual small-sample correction; with only nine returns it lifts the answer from 1.46 to 1.54.

To get to a year, multiply by the square root of 252, the trading days in a year. Variance adds up over time, so its square root is what scales. 1.54 × √252 comes to roughly 24.5 per cent.

I'd do this once by hand even though software does it instantly. The arithmetic isn't where the judgement sits. It sits in the choices around it: thirty days or a year of data, daily or weekly closes, 252 or 365 for a market that trades at weekends.

Next Friday: the volatility the options market expects, set against what then happened.

The one-page guide, free to download on SlideOrbit: slideorbit.com/Caio1
The full article: Historical volatility: how to calculate it, with a worked example
The video version (7:31) is on YouTube.

Comments

Popular posts from this blog

The crack spread, cut down to one page

Where the code from my articles lives now