Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

**Formula of Volatility (Table of Contents)**

## 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 by 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**

### 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 i^{th} day as P_{i} and the mean price as P_{av}.

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

**Step 3:** Next, compute the square of all the deviations i.e. (P_{av} – P_{i})^{2}.

4.9 (1,067 ratings)

**Step 4:** Next, find the summation of all the squared deviations i.e. ∑ (P_{av} – P_{i})^{2}.

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

**Variance = ∑ (P _{av} – P_{i})^{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 = √(∑ (P _{av} – P_{i})^{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 * √****(∑ (P _{av} – P_{i})^{2} / n)**

### Example of Volatility Formula (with 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

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

Now, 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

Variance =** 66.1229**

**Daily Volatility**

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

Therefore, the calculation of Daily Volatility will be,

Daily volatility = √66.1229

Daily volatility =** 8.1316**

**Annualized Volatility**

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

Therefore, the calculation of Annualized Volatility will be,

Annualized volatility = √252 * 8.1316

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 very important 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 of time. 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 of time.

One of the major application 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 has been a guide to Volatility Formula. Here we discuss how to calculate the Daily and Annualized Volatility along with the practical example and downloadable excel sheet. You can learn more about accounting from the following articles –

- Examples of Adjusted R Squared (with Excel Template)
- Beta in Finance Interpretation
- R Squared Formula | Examples
- Sortino Ratio Calculation
- Unlevered Beta Calculation
- Stock Beta calculation
- Portfolio Standard Deviation Calculation

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion