Historical Volatility Calculation

This page is a step-by-step guide how to calculate historical volatility. Examples and Excel formulas are available in the Historical Volatility Calculator and Guide.

Although you hear about the concept of historical volatility often, there is confusion regarding how exactly historical volatility is calculated. If you are using several different charting programs, it is quite likely that you will get slightly different historical volatility values for the same security with the same settings with different software. The following is the most common approach – calculating historical volatility as standard deviation of logarithmic returns, based on daily closing prices.

What Historical Volatility Is Mathematically

When talking about historical volatility of securities or security prices, we actually mean historical volatility of returns. It looks like a negligible distinction, but it is very important for the calculation and interpretation of historical volatility. Mathematically, historical volatility is the (usually annualized) standard deviation of returns. If you know how to calculate return in a particular period and how to calculate standard deviation, you already know how to calculate historical volatility. If you’re still not sure, detailed step-by-step guide follows.

Deciding the Parameters

There are 3 parameters we need to set:

I mostly use 1 day (day-to-day returns), 21 or 63 days (representing 1 month or 3 months), and 252 (as there are 252 trading days per year on average).

It is not as important whether you use 20 or 21 days, or 252 or 262 days. Much more important is that you use the same parameters consistently, so your results will be comparable.

Step 1: Calculating Returns

First we need to calculate the continuously compounded return of each period. In our case, we will calculate the day-to-day returns for each of the 21 days (our n=21):

Historical Volatility Formula 1

ln = natural log
Cn = closing price
Cn-1 = previous day closing price

Step 2: Standard Deviation of the Returns

Next we need to calculate the standard deviation of the returns we got in step 1. Standard deviation is the square root of variance, which is the average squared deviation from the mean (if you are not familiar with it, here you can see a detailed explanation of variance and standard deviation calculation).

First, calculate the average of the returns we got in step 1:

Historical Volatility Formula 2

Then, calculate the squared deviation from the average for each of the returns:

Historical Volatility Formula 3

Calculate the average of the squared deviations by summing them up and dividing by n-1 (in our case 21 – 1 = 20). We are dividing by n-1 rather than n, as we are calculating sample standard deviation (we are estimating the standard deviation from a sample – if not familiar, see the difference between population and sample standard deviation).

Historical Volatility Formula 4

Note: This is the variance of the returns.

Calculate standard deviation = square root of variance. The whole formula therefore is:

Historical Volatility Formula 5

Note: It may look scary, but we have just added a square root to the previous formula.

The number we got now (σ) is 1-day historical volatility.

Annualizing Historical Volatility

The only thing left is to annualize the volatility. We do that by multiplying the 1-day volatility by the square root of the number of (trading) days in a year – in our case square root of 252. The result is the annualized volatility.

Calculating Historical Volatility in Excel

In practice, calculating historical volatility manually would be very lengthy (and prone to errors). But it is very easy in Excel. In fact, you do the whole step 2 with the standard deviation function (use STDEV.S for sample standard deviation).

Historical Volatility Calculator

You can download the Historical Volatility Excel Calculator from sesyixo.ru. Besides the most popular HV calculation method described above, the calculator can also calculate HV using two other, alternative methods, including the zero mean (or non-centered) method. There is a user guide that comes with the calculator, which explains all the calculations in more detail.

Get the Historical Volatility Calculator + Guide now

Related pages

black scholes assumptionsdividend formula financesquaring negativesmsft stock historyhow to write ln in excelapple stock history graphvxx indexexponential moving average calculatorcboe options calculatorexcel volatilitysample variance formula excelgamma black scholessample kurtosisskewness valueshow to calculate implied volatility of a stockhow to calculate in excel formulahow to trade the vixaapl historicalskewness and kurtosis in statisticssvxyhow to draw a breakeven chart in excelwww.proshares.comstrike price exercise priceblack scholes tablemoving standard deviation excelbull call debit spreadstandard deviancemacd calculatorcalculating historical volatilitymacd indicatorvolatility in black scholesdefinition of sigma in statisticskurtosis and skewness pptcalculate annual rate of return in exceldownside risk calculationarbitrage fund meaningstandard deviation formula in wordcalculating rsicontinuously compounded returnshow to solve kurtosiscumulative function in excelmsft yhoofutures expiration calendarintrinsic value formula excelskewness factorvix 3x etfcalculate std devipath etfss&p 500 vixyahoo finance stock optionslong short equity hedge fundsatr volatilitypopulation variance and sample varianceintrinsic value of a call option formularealised volatilityfutures notional valueoptions straddle calculatorlist of all etfsannual rate of return calculator exceloptions on vix futuresfxy etfarithmetic mean roughnesspayoff diagram for optionshow to read rsi charthow to calculate intrinsic value of an optionskewness moments and kurtosisblack scholes pricing formulahow is vix calculatedhow to calculate average with weighted percentagescboe vix chartshort payoffvix averagenotepad stylescontango graphvix option chainhow to calculate the dow jones industrial averageshort the vix