"Bernie Schaeffer is without a doubt the utmost authority on options. I have gained a solid understanding of what it takes to trade successfully." - J. Humphrey, NC

Technical Analysis
Moving Averages

Fundamental Analysis

A moving average smoothes out values of adjacent statistical observations and thereby eliminates minor or irregular fluctuations (called "noise"). A moving average is one of the most widely used technical analysis tools in all of trading and is a workhorse for many in the industry. Moving averages are used to identify the market's or an individual equity's trend in order to establish positions in the direction of the trend.

While there are numerous methodologies for calculating moving averages, we will deal with the three most commonly used - simple, weighted, and exponential. All are based on the issue's closing price for the time frame used (daily, weekly, or monthly), the idea being that there are many intra-period battles going on in the market and the war isn't won until the close. Some studies will base their calculations on intraday spreads between high and low pricing, but we will not pursue that issue here. We will speak of a "10-day" moving average throughout this discussion, though the calculations for weekly and monthly moving averages will follow the same logic.

Simple Moving Average

A simple 10-day moving average consists of successive averages of the 10 most recent days' closing values. The calculation is very straightforward - simply add up the daily closing values and divide by 10. With each subsequent day, the newest closing value is incorporated into the average and the value of 10 days previous is dropped.

The table below depicts closing prices for Microsoft (MSFT) on the dates indicated. The "First Series" chart covers the 10 trading days from June 8 through June 21. Adding the closing prices results in a sum of 698.45. Divided this sum by 10 yields our 10-day moving average of 69.85 for MSFT for the market close on June 21. Moving to the "Second Series" chart, note that we dropped the oldest reading of June 8 and replaced it with the June 22 closing value. The 10-day sum decreased to 694.09, resulting in a new 10-day moving average of 69.41.

FIRST SERIES SECOND SERIES
DATE CLOSING PRICE DATE CLOSING PRICE

6/08/01

73.19 6/11/01 72.12

6/11/01

72.12 6/12/01 72.08

6/12/01

72.08 6/13/01 70.69

6/13/01

70.69 6/14/01 68.90

6/14/01

68.90 6/15/01 68.02

6/15/01

68.02 6/18/01 66.88

6/18/01

66.88 6/19/01 67.32

6/19/01

67.32 6/20/01 69.41

6/20/01

69.41 6/21/01 69.84

6/21/01

69.84 6/22/01 68.83
SUM 698.45 SUM 694.09
10-Day 69.85 10-Day 69.41

One of the objections some have with the simple moving average calculation is that it assigns equal weight to each of the 10 values. It is not unreasonable to argue that the most current readings should be more important as a reflection of what the stock is doing now. This takes on added importance as the time frame increases (e.g., 20 days). Since the calculation is modified each day by dropping the oldest value in favor of adding the most current one, its fluctuation now becomes a function of just two numbers. That is, if the current value is greater than the one being dropped, the average turns upward. The converse is true - if the current value is lower than that of 10 days ago, the average moves lower. This is demonstrated in the table above. To arrive at the calculations of the "Second Series", we dropped the 73.19 reading of June 8 used in the first calculation and replaced it with the lower value 68.83 of June 22. The result was a lower "plot point" for the 10-day moving average.

Weighted Moving Average

Although the weighted averaging process is basically the same as for a simple moving average, more significance, or "weight," is added to the most current readings (on a closing basis). Looking at the chart below, note that we have assigned weightings so that day 10 carries 10 times more significance than day one.

The weightings may be allocated to suit the individual analyst's taste and don't have to be uniformly progressive (10, 9, 8, 7, etc.). The importance here is that you are consistent in your application. For example, there is no reason why the first five days cannot have equal weightings with the progression occurring in days six through 10 (although you are complicating an already cumbersome calculation).

The next step is to multiply the "weighting" by the day's closing price to come up with a "weighted price." We have used the same MSFT values from the "Second Series" above. The sum of the weighted price column is 3788.71. Divide this figure by the sum of the weightings (55) to arrive at a weighted 10-day weighted moving average of 68.89. Note that this weighted 10-day plot point is lower than the plot point of the simple 10-day moving average because more reliance is placed on the latter readings that are lower than the first few points of data.

  Price Weighted Calculation
Date Weighting X Closing Price = Weighted Price
6/11/01 1 X 72.12 = 72.12
6/12/01 2 X 72.08 = 144.16
6/13/01 3 X 70.69 = 212.07
6/14/01 4 X 68.90 = 275.60
6/15/01 5 X 68.02 = 340.10
6/18/01 6 X 66.88 = 401.28
6/19/01 7 X 67.32 = 471.24
6/20/01 8 X 69.41 = 555.28
6/21/01 9 X 69.84 = 628.56
6/22/01 10 X 68.83 = 688.30
Sum 55   694.09   3788.71
10-Day     69.41   68.89
      Simple   Weighted

Exponential Moving Average

This form of moving average also assigns greater relevance to the more current values. An exponential system is based upon the assignment of a fixed percentage weight to the current price, say 18 percent (could be any weighting; see below for rationale), and all of the remaining weight (82 percent) to the previous value of the moving average itself. The proportional weight assigned to the most recent reading is often called a "smoothing constant."

To determine an exponential "smoothing constant" roughly proportional to a simple moving average of a given time length, divide two by one more than the length of the simple moving average you wish to replicate. It may sound confusing, so let's look at an example. To find a smoothing constant to construct an exponential moving average comparable to a simple 10-day moving average, divide two by 11 (one more than the 10-day simple). The result is 0.18 (why we chose this number above).

As a starting point, let us assume day one to be the exponential moving average for that point in time. The exponential moving average is updated by multiplying the newest price by 0.18 (our smoothing constant) and adding that to the product of the previous exponential moving average multiplied by 0.82 (the balance of the 100 percent allocation). Staying with our MSFT example, the results are shown in the table below.

Date Closing Price Calculation Exponential Moving Avg.
6/11/01 72.12 Arbitrary start point 71.75
6/12/01 72.08 0.18*72.08+0.82*71.75 71.81
6/13/01 70.69 0.18*70.69+0.82*71.81 71.61
6/14/01 68.90 0.18*68.90+0.82*71.61 71.12
6/15/01 68.02 0.18*68.02+0.82*71.12 70.56
6/18/01 66.88 0.18*66.88+0.82*70.56 69.90
6/19/01 67.32 0.18*67.32+0.82*69.90 69.44
6/20/01 69.41 0.18*69.41+0.82*69.44 69.43
6/21/01 69.84 0.18*69.84+0.82*69.43 69.51
6/22/01 68.83 0.18*68.83+0.82*69.51 69.38

Looking at the three types of moving averages, the largest spread between them is 0.52 points, or just 0.75 percent of the simple 10-day moving average. The issue is thus whether the additional work in calculating the weighted and exponential moving averages is justifiable in terms of providing a trading edge. Below is a chart of MSFT with both a simple 10-day moving average (yellow) and a 10-day exponential moving average (blue). Note that the exponential seems to react more quickly than the simple moving average, which could possibly signal a quicker entry or exit point for a trade.

Moving Averages

We recommend that whichever moving average you use, stay consistent with that method. Bouncing from a simple to a weighted average will only confuse you and restrict your ability to recognize equities that have historically reacted well around these trendlines.

Time Frames

We commonly use 10-unit and 20-unit simple moving averages. "Unit" refers to the time frame you wish to use - daily, weekly, or monthly. This changing of perspectives is like driving up to the Rocky Mountains. From a great distance, the range appears to be one solid piece of rock emanating form the earth's crust (think of this as a long-term or monthly chart). As you get a little closer (weekly chart), you start to notice that the "barren" rock is covered with trees and huge fields of snow. Taking a tram up the mountainside (daily chart), you notice pastures of grass surrounding the tree line, an occasional lake nestled into a flat, not to mention a plethora of wildlife. This short-term, or daily, chart reveals things you could only imagine from the long-term perspective.

Each view provides you with a different viewpoint, though each independently does not afford a complete assessment of the mountain. Such is the reasoning behind examining the various chart views and their accompanying moving averages.

These three views of MSFT are presented below (daily, weekly, and monthly from top to bottom), each with a 10-unit (red line) and 20-unit (blue line) simple moving average. Note that the circled areas in the weekly and monthly charts encompass the entire field of view of the prior, shorter-term chart.

Moving Averages

Moving Averages

Moving Averages

The longer term charts and the accompanying longer-term moving averages can aid in determining the overall trend of a stock, index, or market. In fact, we consider the 20-month moving average as the line of demarcation between a bull and bear market. Note how well MSFT followed its 10-month moving average in its strong upward trend from 1995 through its peak in 2000. The subsequent plunge below the 20-month, which had not once been breached on a closing basis during the run-up, should have placed investors on alert.

Even more ominous for the stock's outlook was the occurrence of a "bearish-cross" of the two moving averages. A bearish-cross occurs when the "faster" (10-month) moving average crosses below the "slower" trendline (20-month). This fact on a longer-term chart would indicate that the upward trend has definitely been violated. Also note that the 10-month initially served as resistance toward advance attempts by the shares and now the 20-month may serve as resistance.

The intermediate-term weekly chart begins to reveal the choppy nature of the shares. Initially, the 20-week moving average did a respectable job of containing the equity and driving it lower. Recent activity has the shares trading around the 10-week and 20-week trendlines, showing little respect for their attempts at support or resistance.

The short-term daily chart does more to show the consolidating nature of the shares. The moving averages are losing any directional bias and have "flat-lined" with the stock trading on either side of them at will. This makes these short-term moving averages fairly useless from a practical trading perspective. At this point, we would rely more on historical chart levels of support or resistance. For MSFT, resistance appears at the 75 level while support should come in around 65.

Summation

There is no perfect moving average style or length. You could probably back-test all sorts of combinations and make a positive case for their predictive reliability for some stock or index. Ultimately, the ideal combination is the one that has worked for you. This brings us back to the concept of consistency. Whatever calculation or duration you use, make it yours and stick with it. Only repetitive trial and error will help you hone your technical skills with respect to moving averages.

Expectational Analysis Menu
Fundamental Analysis
Introduction | Earnings Momentum | Corporate Restructuring
New Products | New CEOs | Federal Reserve/ Interest Rates

Technical Analysis
Introduction | Moving Averages | Oscillators | Relative Strength
Support and Resistance | Regression Channels | Volatility Bands

Sentiment Analysis
Introduction | Cover Stories | Open Interest | Put/Call Ratios
Implied Volatility | Mutual Fund Flows | Sentiment Surveys

Putting It All Together
Case Study: EMC Corp. | Case Study: Verizon | Case Study: IBM



Schaeffer's Partner Center