Volatility Definition - How to Calculate Volatility
87You often hear about stock market volatility, and how bad it is, but have you wondered how to compare volatility? Is it just something you know when you see it, or can it be quantified? Well, like most things, there are ways to quantify volatility so you can make the comparisons you want.
Volatility Definition
First, we need to agree on definition of volatility. It's basically the variation from the average value over a measurement period. If a price varies a great deal from day to day, the volatility will be high, and conversely if the day to day variation is low, the value of volatility will be low as well.
While it gets pretty complicated in a hurry when you burrow into the statistics and when you factor in things like lognormal returns, and stationary processes, it can be approximated by saying that if the volatility is calculated by the standard deviation of the asset prices, then approximately two-thirds of the time the price will be within one standard deviation of the average price over time.
Why Do We Care About Volatility?
One of the areas that volatility takes on greater importance is in the area of options pricing. Not to go into great detail, but an example would be call option, or the option to buy a stock or some other asset in some future period, say the next few months. If a stock price has a history of relatively large price swings, then it becomes more likely that it can exceed the "strike price" of the potentially triggering the buyer to exercise the option, or to buy and sell the stock at a profit, even though the long term average price of the stock hasn't changed. So the option seller will price the option higher for a volatile stock to compensate for this possibility.
Volatility Drag - Why the Average Investor Cares About Volatility
Why would your average investor care? There's another subtle effect on long term stock returns called volatility drag. This is what happens to the annual return on an investment when the year to year returns are volatile. It's best explained with an example.
For the 30 years following 1966 the S&P 500 averaged about approximately 7.8% a year, if you just averaged the individual annual returns. But, if you had an initial investment of $1000, at the end of the 30 year period, you had a healthy $666K, but this represents a compounded annual return of only 6.5%. Where did the rest of the money go? This is the volatility drag.
Here's an example, assume you just invested for 2 years, and the first year you got a +25% return, and the second year you got a -25% return. That's obviously an average return of 0%, but you really got (1+.25) x (1-.25) or a final value of .9375, or a negative overall return of 6.25%, for a compounded annual return of -3.18%. And the story gets worse with more periods or wider swings.
Another easy example would be a gain of +100 percent, and a negative 50%. This gives an apparent average gain of 25%, but the net return is actually zero.
Financial advisors and newsletters take advantage of this all the time. That's why they almost always advertise average annual gains instead of compounded annual returns, as the numbers always look better. Keep that in mind the next time you get some advertisement that suggests huge annual returns. This is also one of the major attractions of hedging and hedge funds.
Finally, volatility will cause market makers to increase the bid ask spread on stocks they make the market in. For thinly traded markets, for example when investing in penny stocks, that just makes it that much tougher to make a profit on a trade.
The Way to Calculate Volatility
For options trading, the usual way to calculate volatility is to take the trailing 20 periods (which for a daily calculation is almost one month of market days) The standard deviation is calculated on the daily closing price. To calculate the standard deviation, you find the average price over the range of days, you take the daily difference between the price and the average, and square that, sum it over the 20 days, and divide by 20 (this value is known as the variance). You then take the square root, and that is the standard deviation, which is the number used to represent the volatility.
Excel Spreadsheets to Calculate Volatility
- An introduction to volatility and how it can be calculated in excel.
Use excel formulas to calculate volatility, log relative prices and implied volatility. - How To Calculate Historical Volatility in Excel
Easily calculate the annualized historical volatility of a set of securities price data. Use daily, weekly, monthly, annual, or other periodic closing prices. Adjust for dividends automatically. One of our many free Power4XL Black-Scholes stock op
More Articles on Investing
- Penny Stock Investment Newsletters and Advisors - Finding the Best
Investing in penny stocks is always a hot topic. The allure of penny stocks is the sense that you can get a large position without a lot of money, and a price swing of a few cents can result in a...
- ETF Trading Strategies - A Look at Several ETF Trading Systems
One of the attractive features of ETF’s is that they can represent a relatively narrow sector of the market, but don’t generally have the volatility of individual stocks. This makes them...
- Sector Trading - There is a Bullish Sector Somewhere
Do you look at the mutual fund rankings that magazines publish every year? The performances can often be eyepopping. Have your ever seen a year that the best performing mutual funds had a loss? ...
- Investing in Index Mutual Funds: Pitfalls of Buy and Hold
Are you overwhelmed by the options when it comes to buying (and selling) mutual funds? With over 10,000 funds out there, there are more funds than stocks listed on the stock exchanges. How do we sort...
- US Treasury ETF’s - A Look at Treasury ETF Choices
There have been a confusing array of US treasury ETF’s made available over the last several years. They come in a few different classes, here are some that might work for your portfolio. One...
- Oil ETFs - What are the Choices for an Oil ETF
Oil is a popular investment target these days as the price of oil shows a lot of volatility, and provides some diversification as it doesn’t move in concert with the overall market. As an...
- Best Time to Invest in Mutual Funds - The Best Months to Invest
When is the best time to invest in mutual funds, or the stock market in general. Because of the redemption fees on mutual funds, it can be harder to use market timing to manage the risk in your...
- Hedging Your Mutual Fund Portfolio - Why Hedge Your Portfolio?
What do farmers and airlines know that you don’t? So far in our series on managing risk we’ve taken a look at market timing and portfolio diversification as two powerful techniques to...
More Hubs On Investing
- ETF Portfolio - Building a Low Risk ETF Portfolio
ETF's are attractive to many investors because of their low overhead costs and ease of investment. - 2 years ago
- Sector Rotation Strategies- A Free Sector Rotation Strategy
We look at a free sector rotation strategy that anyone can use to beat the major market averages. - 3 years ago
- Volatility Definition - How to Calculate Volatility
You often hear about stock market volatility, and how bad it is, but have you wondered how to compare volatility? - 3 years ago
- How Much Do I Need to Retire and How to Manage with Less?
Every investor eventually faces the question of deciding "How much do I need to retire? - 2 years ago
- Oil ETFs - There are Many Oil ETFs - Which Will Work for You?
One popular way to diversify your portfolio is to add some funds or assets that are not correlated strongly to the overall market. - 2 years ago
- How to Invest in Penny Stocks and Not Get Cheated
Investing in penny stocks is often touted as a great way to make a killing in the stock market. - 3 years ago
- Low Risk Funds - Finding Low Risk Mutual Funds
With the market as tough on investors as it's been in the last couple of years, it's good to take a look at ways to reduce the risk in your portfolio. - 2 years ago
- The Best Mutual Funds - Tips for Finding the Best Mutual Funds
Finding the best mutual funds can be a daunting task. - 2 years ago
More of Our Favorite Hubs
- Reverse Phone Lookup - Review of Phone Number Lookup Features
Reverse Phone Lookup - Here are the features you need in a reverse phone number lookup service. - 2 years ago
- www.gmail.com - Get the Most from Your gmail.com Account
gmail.com - Google's free email account is the favorite of millions of users. Here are a few tips to get more from your Gmail account. - 2 years ago
- Repair Garage Door Springs - Garage Door Spring Replacement Video
We've all had that sick feeling when we find the garage door won't open, and no amount of pushing or pulling will get it to budge. And that rusty old spring that had been silently doing its job for the last... - 2 years ago
- Hummingbird Food Recipe - Making Hummingbird Food is Easy
Everyone loves watching hummingbirds in their back yard. And it's great if you can plant the types of plants like honeysuckle or trumpet creepers that will attract hummingbirds naturally. And it's even... - 3 years ago
- Pergola Designs - Choosing the Best Design for Your Pergola Plans
Pergolas are a great addition to your landscape - Make the right choice in a pergola design with these tips for your pergola plans. - 2 years ago












