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 sholeetc etftrading hedge fundsinventory average cost methodhedge fund categorieswhat does a negative kurtosis meansharp ratio definitionvix futures curveblack and scholes modeldow jones vixhedge fund tradeswiki sharpe ratiotheta of optionsharpe ratio examplefutures roll dateshistorical volatility vs implied volatility13f filingslogarithmic rate of returnvix options settlementrsi meaningcalculating the sample variancefinance yahoo msftrelative standard deviation calculatoradvantages and disadvantages of measures of central tendencyvix shortwhat is implied volatility how can it be calculatedvolatility calculation formulavariance calcwacc formula with preferred stockgood sharpe ratiostandard deviations calculatoroptions straddlevariance calctrading today black scholes calculatorultra short s&plong term vix chartprofit & loss formulasmonospace font listblack schole modelexcel calculation formuladax index methodologyhow many shares in an option contractgamma calculatorhow to change font size in notepadshare price volatility calculatorhow to compute sample variancevolatility as an asset classannualize a numberquote vxxwhat does rsi mean in stocksintrinsic value of put option formulatheta financespx volatility indexsp futures bloomberghow to calculate variance excelcalculating stock volatilityvix options settlementpayoff put optionbarrier option calculatorsharpe calculatorintrinsic value of call optioncboe vix historical datablack scholes options pricingexcel kurtosishow to calculate square root in excelmacd oscillatorpowershares etnmarket sharpe ratioblack sholevxx inversepopulation deviation calculatorunbiased standard deviation calculatorwac methodmean and variance calculatorproshares leveraged etfsvix derivativessquaring a negative number