Moving Averages & Bollinger Bands

A moving average just shows me the calm center of the noise, and a Bollinger Band shows me how far the noise usually wanders from that center — neither one tells me what happens next.

• Calculate a simple moving average by hand from a short series of daily closing prices using the rolling window method.
• Explain how Bollinger Bands are built directly from a moving average by adding and subtracting a measure of typical price spread.
• Interpret a widening or narrowing band as a change in volatility rather than a prediction of future price direction.
• Distinguish a genuine change in market behavior from ordinary price noise before reacting to a single price move or band touch.

Here's the problem a raw price chart creates: every day's closing price jumps around, and your eye can't tell if the stock is actually trending or just wobbling. A Simple Moving Average (SMA) fixes this by doing one thing — it averages the last few days' closing prices together, so the daily jitter smooths into one calm line.

The math is plain: take the last N closing prices, add them up, divide by N. Tomorrow, you drop the oldest price and add the newest one — this is called a rolling window, because the "window" of prices you're averaging keeps sliding forward one day at a time. That's the whole idea. No prediction, no magic — just an average that updates daily.

Neither the SMA nor the bands can see tomorrow — they only describe what already happened.

Now, Bollinger Bands. Despite the technical-sounding name, they are not a new formula — they're the SAME SMA you just calculated, with two more lines added: one above it, one below it. Those two lines are drawn by adding and subtracting a measure of typical spread (how far prices usually stray from the average — this spread is called volatility) from the SMA. So the upper band = SMA + spread, and the lower band = SMA − spread. One average, one spread number, two extra lines. That's it.

What do the bands tell you? When recent prices have stayed close to their own average, the spread is small, so the bands sit close together — narrow. When recent prices have been jumping around more than usual, the spread is bigger, so the bands stretch apart — wide.

But here's the turn: neither the SMA nor the bands can see tomorrow. A narrow band doesn't mean something is "about to happen." A wide band doesn't mean "sell now." Both are simply describing what already happened — how calm or unsettled the price has recently been. Reading them is like checking a stock's temperature, not its horoscope.

Suppose you're looking at seven days of closing prices (in INR) for a stock: ₹100, ₹104, ₹98, ₹103, ₹107, ₹101, ₹105.

To find the 5-day SMA for Day 5, you take the last five closes: 100, 104, 98, 103, 107. Add them: 512. Divide by 5: SMA = 102.4.

Move to Day 6: drop the oldest close (100), add the newest (101). Now you're averaging 104, 98, 103, 107, 101 = 513, divided by 5 = SMA of 102.6. That's the rolling window in action — the average barely moved, even though the daily prices bounced around by several rupees each day. That smoothing is the whole point of an SMA.

Now for the bands. Say on Day 5, the typical spread of those five prices around 102.4 works out to about ₹3.5. The upper band = 102.4 + 3.5 = 105.9, and the lower band = 102.4 − 3.5 = 98.9. The gap between 98.9 and 105.9 is fairly narrow — prices have been sticking close to their average, so the market has been calm.

Now imagine a later stretch where prices swing harder — say closes of ₹100, ₹112, ₹95, ₹118, ₹99. The SMA might still land near ₹104.8, but the spread this time comes out closer to ₹9. The upper band jumps to about 113.8, and the lower band drops to about 95.8 — a much wider gap. The average barely shifted, but the band around it stretched out.

What should you take from that? Not "the price is about to explode" and not "time to buy or sell." Just this: recent price behavior became more unsettled than before. The band widening is the market's own way of saying "there's more disagreement in price right now" — nothing more, nothing less.

Point: Bollinger Bands are the same moving average already calculated, with a band of typical spread added above and below it — and the width of that band describes changed behavior in the market, not a prediction of what comes next.

• Treating the moving average as a forecast of where the price is headed next. — Traders often mention averages while talking about future trades, so it's easy to link the tool to prediction instead of description. Fix: Remind yourself the SMA only tells you where the price has recently been, on average — it has zero forward-looking power. It describes the past, not the future.
• Assuming Bollinger Bands are a separate, more advanced formula unrelated to the moving average. — Bands are usually taught as their own topic with an intimidating name, which hides that they're built directly on top of something you already know. Fix: Say it plainly to yourself: Bollinger Bands = SMA + spread and SMA − spread. Same average, one extra step.
• Reacting to a price touching or crossing a band as an automatic buy or sell signal. — Many tutorials frame band touches dramatically, as if they're triggers for action, which feels exciting and actionable. Fix: When price touches a band, treat it only as information — price moved further from its recent average than usual. Pause and ask what changed before deciding anything.
• Believing a narrow band means the market is 'about to explode' in one direction. — This is a popular piece of trading folklore repeated online, and it sounds like useful, confident advice. Fix: Remember a narrow band only says recent movement has been calm. It says nothing about direction or whether bigger moves are actually coming.

• A Simple Moving Average is just the average of the last N closing prices, recalculated daily using a rolling window.
• Bollinger Bands are not a new formula — they're the same moving average with a band added above and below, based on typical price spread.
• A widening band means prices have been straying more than usual; a narrowing band means they've been staying close — neither predicts what happens next.
• Averages and bands describe past and present price behavior only; they never guarantee or forecast the future.
• Before reacting to any sharp price move or band touch, pause and ask: is this normal wobble, or has something actually changed?

Q1. A stock's closing prices for the last 5 days are: ₹100, ₹104, ₹98, ₹103, ₹107. What is the 5-day Simple Moving Average (SMA)?

• 102.4
• 107.0
• 512.0
• 100.0 Answer: 102.4 — Add the five closes (100+104+98+103+107 = 512) and divide by 5, which gives 102.4. That's the whole SMA calculation — sum the last N closes, divide by N.

Q2. In a rolling window, what happens when a new day's closing price is added to the moving average calculation?

• The oldest closing price in the window is dropped and the new one is added
• All previous prices are kept and the new one is simply added to the total
• The average resets to zero and starts counting fresh from the new price
• The window size (N) automatically increases by one Answer: The oldest closing price in the window is dropped and the new one is added — A rolling window always keeps the same number of days (N) — the oldest price slides out as the newest price slides in. This is what keeps the average updating smoothly each day.

Q3. Bollinger Bands are best described as:

• A moving average with an upper and lower line added, based on typical price spread
• A completely separate formula that doesn't use the moving average at all
• A prediction tool that shows exactly where price will move next
• A count of how many days the price went up versus down Answer: A moving average with an upper and lower line added, based on typical price spread — Bollinger Bands aren't a new invention — they're the same SMA you already calculated, with a band drawn above and below it based on how far prices typically stray from that average.

Q4. True or False: If a stock's Bollinger Bands suddenly widen, this tells you the price will keep moving in the same direction it just moved. Answer: False — A widening band only shows that recent prices have strayed further from their average than usual — it describes changed behavior, not a forecast of future direction.

Q5. Bollinger Bands are narrow all week, then a stock touches the upper band on Friday. A trader says: "Narrow bands this week basically predicted this exact move." Did the narrow bands predict this specific move was coming? Reveal: Weak: yes, the narrow bands were basically a forecast. Strong: narrow bands signal low volatility was present, not which direction or when a move would happen — the Friday move still needs to be checked against the stock's typical spread before deciding it means anything.