WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Volatility Formula

Volatility Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Volatility Formula?

The term “volatility” refers to the statistical measure of the dispersion of returns during a certain period of time for stocks, security, or market index. The volatility can be calculated either using the standard deviation or the variance of the security or stock.

The formula for daily volatility is computed by finding out the square root of the variance of a daily stock price.

Daily Volatility Formula is represented as,

Daily Volatility formula = √Variance

Further, the annualized volatility formula is calculated by multiplying the daily volatility by a square root of 252.

Annualized Volatility Formula is  represented as,

Annualized Volatility Formula = √252 * √Variance
Volatility Formula

Explanation of the Volatility Formula

The formula for the volatility of a particular stock can be derived by using the following steps:

Step 1: Firstly, gather daily stock price and then determine the mean of the stock price. Let us assume the daily stock price on an ith day as Pi and the mean price as Pav.

Step 2: Next, compute the difference between each day’s stock price and the mean price, i.e., Pi – P.

Step 3: Next, compute the square of all the deviations, i.e. (Pav – Pi)2.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Step 4: Next, find the summation of all the squared deviations, i.e. ∑ (Pav – Pi)2.

Step 5: Next, divide the summation of all the squared deviations by the number of daily stock prices, say n. It is called the variance of the stock price.

Variance = ∑ (Pav – Pi)2 / n

Step 6: Next, compute the daily volatility or standard deviation by calculating the square root of the variance of the stock.

Daily volatility = √(∑ (Pav – Pi)2 / n)

Step 7: Next, the annualized volatility formula is calculated by multiplying the daily volatility by the square root of 252. Here, 252 is the number of trading days in a year.

Annualized volatility = = √252 * √(∑ (Pav – Pi)2 / n)

Example of Volatility Formula (with Excel Template)

You can download this Volatility Formula Excel Template here – Volatility Formula Excel Template

Let us take the example of Apple Inc.’s stock price movement during the last one month, i.e., January 14, 2019, to February 13, 2019. Calculate the daily volatility and annual volatility of Apple Inc. during the period.

Below is data for calculation of daily volatility and annualized volatility of Apple Inc

Volatility formula eg1

Based on the given stock prices, the median stock price during the period is calculated as $162.23.

The deviation of each day’s stock price with the mean stock price is calculated in the third column, while the square of the deviation is calculated in the fourth column. The summation of the squared deviation is computed to be 1454.7040.

Variance

Now, the variance is calculated by dividing the sum of squared deviation by the number of daily stock prices, i.e., 24,

Variance = 1454.7040 / 24

Volatility formula eg1.2png

Variance = 66.1229

Daily Volatility

Now, the daily volatility is calculated by finding out the square root of the variance,

Volatility formula eg1.3png

Therefore, the calculation of Daily Volatility will be,

Daily volatility = √66.1229

Daily example 1.4

Daily volatility = 8.1316

Annualized Volatility

Now, the annualized volatility is calculated by multiplying the square root of 252 to the daily volatility,

annualized example 1.5

Therefore, the calculation of Annualized Volatility will be,

Annualized volatility = √252 * 8.1316

Volatility formula eg1.6png

Annualized Volatility = 129.0851

Therefore, the daily volatility and annualized volatility of Apple Inc.’s stock price is calculated to be 8.1316 and 129.0851, respectively.

Relevance and Use

From the point of view of an investor, it is essential to understand the concept of volatility because it refers to the measure of risk or uncertainty pertaining to the quantum of changes in the value of a security or stock. Higher volatility indicates that the value of the stock can be spread out over a larger range of values, which eventually means that the value of the stock can potentially move in either direction significantly over a short period. On the other hand, lower volatility indicates that the value of the stock would not fluctuate much and will continue to remain stable over the period.

One of the major applications of volatility is the Volatility Index or VIX, which was created by the Chicago Board of Options Exchange. VIX is a measure of the 30-day expected volatility of the U.S. stock market computed based on real-time quote prices of S&P 500 call and put options.

Recommended Articles

This article has been a guide to Volatility Formula. Here we discuss how to calculate the Daily and Annualized Volatility and the practical example and downloadable excel sheet. You can learn more about accounting from the following articles –

  • Adjusted R Squared
  • Realized Volatility
  • Implied Volatility Explanation
  • Formula of Population Variance
  • Gross Interest
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Volatility Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More