Volatility Formula (Table of Contents)
What is Volatility Formula?
Volatility is the degree of variation of the returns for a given security or the market index, over a period of given time. It is the measure of the risk and the standard deviation is the typical measure used to measure the volatility of any given stock, while the other method can simply be the variance between returns from the same security or market index. One common measure of the volatility of given security with respect to the market index or the benchmark is its beta.
There can be two types of volatility depending on its usage – Implied Volatility which is a forward-looking estimate and is used in the option pricing strategy. The other is the Regular Volatility which is more common and used a backward-looking real figure.
Degree of Volatility
High volatility of security would mean that with a slight change in the factors affecting the stock price, the price of the security can move drastically in either direction over a short period of time.
A lower volatility means that the value of a security does not react dramatically and tends to be steadier.
Calculation of Volatility of a security
Formula For annualized volatility is given below,
assuming there are 252 trading days in a year. Standard Deviation is the degree to which the prices vary from the average over the given period of time.
For example: if the daily standard deviation of the S&P 500 benchmark is 1.73% in August 2015, its Annualized Volatility will be :
4.5 (1,696 ratings)
1.73 * √252 = 27.4
Therefore, the annualized volatility for the S&P 500 in 2015 is 27.4%, based on the daily volatility or daily price movements in August 2015.
How to calculate the Standard Deviation
- When you have a series of data points
- Calculate the average of the data set.
- Subtract the average from the actual observation, to arrive the deviation.
- Square up all the deviations and add them up, to arrive the Variance.
- Calculate the square root of the variance, to arrive the Standard Deviation.
- Using MS-Excel
- Download the historical prices of given security – till the time period required.
- Calculate the daily returns, which is percentage change each day as compared to the previous day.
- Use the Excel function STDEV().
Example of Volatility Formula (With Excel Template)
Let’s take an example to understand the calculation of Volatility in a better manner.
Volatility Formula Example
Consider calculating the Annualized Volatility of a given stock, ITC in this case.
Below is the data of ITC for the time period January 2018 to December 2018. Calculate Daily returns, volatility, and annualized Volatility of ITC.
We calculate the daily returns, which is column D here, using the close price as mentioned in column C.
So the result will be as given below.
Similarly, calculate daily returns for all the remaining cells.
Daily Volatility can be calculated using the Standard Deviation or STDEV() formula in MS-Excel.
The output will be as given below.
Annualized Volatility is calculated using the formula given below
Annualized Volatility = Standard Deviation * √252
The output of Annualized Volatility will be as shown below.
Relevance and Uses of Volatility
Traditionally, it is an assumption or general phenomenon that the risk frameworks that use standard deviation as the key method, assume that the returns conform to a normal bell-shaped distribution. This gives us a fixed risk and returns framework, and if the returns in the curve do not show a symmetrical behavior the investors tend to panic.
Another use of the volatility numbers is trading on security and deciding on the stop-loss point. The knowledge of stock as to how much will it move within a stipulated time can help the investor decide on the stop loss instead of facing the losses due to the random fluctuations in the stock price.
Understanding volatility and knowing its applications can act as a double-edged sword. When a highly volatile stock can land you up into huge losses, at times when you are hitting at the right market timing you can even end up minting large profits. It undoubtedly reduces your expected long-term return, but it definitely provides you with equal chances to make a few big gains.
Volatility Formula Calculator
You can use the following Volatility Calculator
|Annualized Volatility =||Standard Deviation x √252|
|=||0 x √252 = 0|
This is a guide to Volatility Formula. Here we discuss How to Calculate Volatility along with practical examples. We also provide a Volatility Calculator with a downloadable excel template. You may also look at the following articles to learn more –
- Calculator For Portfolio Return Formula
- Examples of Percentage Decrease Formula
- Capital Asset Pricing Model Formula | Definition
- Coefficient of Variation Formula (Excel Template)
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
250+ Online Courses
Investment Banking Training (with 25+ Projects)
Financial Modeling Training (with 15+ Projects)
Equity Research Training Course (with 6+ Projects)
Corporate Finance Course
Project Finance Course