Moving averages, RSI and MACD, and how they fail

Read three common indicators and describe the market conditions in which each one gives false signals.

Moving averages, RSI and MACD are all built from the same column of closing prices. Each one redraws the price line in a different shape, and none of them tells you anything the price does not already contain.

Broker apps make this easy to forget, because you can add each indicator with one tap. Marcus, an investor, used his broker app's one-tap indicators to add three to his STI ETF chart: a pair of moving averages, RSI and MACD. They sat under the price like instruments on a dashboard. On most days at least one of them was flashing a signal, and it often contradicted another.

Working out a simple moving average

A simple moving average is the average closing price over the last N days. For a 50-day simple moving average, you add the last 50 closes and divide by 50. The next day you drop the oldest close, add the newest one and work out the average again, so the line moves forward one day at a time.

Take five rising closes of S$10, S$11, S$12, S$13 and S$14 (made-up prices; nothing in these notes is a trading signal). Their five-day average is S$12, which is two dollars behind the latest price of S$14.

Averaging smooths out daily noise, and that is its purpose. The cost of smoothing is that a moving average always trails the price. A longer window gives a smoother line and a longer delay, and a 200-day average reflects prices from up to ten months ago. An exponential moving average (EMA) uses the same idea but gives recent days more weight, so it turns slightly sooner than a simple moving average.

Golden crosses, death crosses and Marcus's count

Traders often watch two moving averages together. When the 50-day average rises above the 200-day average, that is called a golden cross, and it is read as the start of an uptrend. When the 50-day average falls below the 200-day average, that is a death cross, read as the reverse: the start of a downtrend. Any point where one average crosses another is a crossover.

Both averages lag, so a crossover arrives after the turn has already happened. In a long, strong trend the lag costs little, and you still catch most of the move. In a sideways, choppy market the averages cross back and forth, and each cross comes late on a move that soon reverses. Crossovers that another crossover reverses soon after, before the price has gone anywhere useful, are called false signals.

Marcus tested golden and death crosses on ten years of made-up STI data. His method was:

list every golden and death cross in the data for each cross, check whether a move of more than 10% in the signalled direction followed before the next cross, and count it as good if so otherwise, check whether the opposite cross reversed it within three months, and count it as false if so count the good and false signals

He found seven crossovers. Three were followed by a move of more than 10% in the signalled direction. Four were reversed by the opposite cross within three months, with the index ending roughly where it started or moving the other way. By his definition, 4 of 7, more than half, were false, and each false signal would have cost two trades.

Counting false signals does not prove a rule useless, because a few good signals might outweigh several small losses. A crossover rule works in long trends and loses a little in sideways markets, and what matters is how the two net out after costs. Lesson 10.8, "Test one trading rule with costs on real price history", shows you how to work that out properly.

Calculating RSI and reading 70 and 30

The relative strength index, or RSI, was introduced by J. Welles Wilder in his 1978 book on technical trading systems. It compares the size of recent gains with the size of recent losses, usually over 14 periods. Over the window, find the average gain on up days and the average loss on down days. Divide the average gain by the average loss to get RS. Then RSI = 100 - 100 / (1 + RS).

Say the average gain is 1.2 and the average loss is 0.6. RS = 1.2 / 0.6 = 2, so RSI = 100 - 100/3, which is about 66.7.

The scale runs from 0 to 100. By convention, RSI above 70 is called overbought and RSI below 30 is called oversold. These labels suggest a reversal is due, but in a strong trend it often is not. A stock rising steadily for months can stay above 70 for most of that time, and selling on the first overbought reading would miss the rest of the rise. A falling stock can stay oversold through a long decline. RSI shows that recent moves have been fast and one-sided. It does not show whether they are about to stop.

How MACD and its signal line are built

MACD stands for moving average convergence divergence. Gerald Appel developed it in the late 1970s. To build the usual version, calculate the 12-day EMA and the 26-day EMA, then subtract the 26-day EMA from the 12-day EMA. MACD is positive when the short average is above the long one, and the gap between the two widens when the price is accelerating. The signal line is a 9-day average of MACD itself, drawn on top of MACD. Crossings between MACD and the signal line are read as buy and sell signals.

MACD is a crossover system like the 50-day and 200-day averages, only faster and with an extra layer of smoothing, so it has the same weakness. In a sideways market it produces whipsaw, where the lines cross back and forth and give signals in alternating directions. Lesson 5.3, "Spreads, depth and market impact on small and large stocks", showed that each round trip costs a spread and a commission, so a run of whipsaw signals loses money even when the price ends where it started.

Why three indicators gave Marcus no extra knowledge

All three indicators transform the same closing prices. They can make some features easier to see, such as how fast the price is moving or the gap between short-term and long-term moves, but they cannot reveal anything the chart does not already contain. Adding more indicators rarely helps. Indicators often agree because they share a source, and when they disagree it is usually because they use different windows. Neither the agreement nor the disagreement is independent evidence. Marcus's three indicators gave him contradictions on most days and no extra knowledge, because they are transformations of one price line.

Choose one broad index with at least ten years of daily data, such as the STI or a world index, and get ready to plot its 50-day and 200-day moving averages and count every crossover.

Take one index over ten years and count the false signals given by the 50 and 200-day moving average crossover.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).