SMA200 trend
The 200-day average is the mean closing price of the last 200 trading days — a common line for the long-term trend. The cell shows how far the price is above or below it. For stocks, a price far below it blocks the Dip state; for ETFs it is shown only.
How it is calculated
Distance = (price − 200-day average) ÷ 200-day average
A price of 110 with an average of 100 is +10% (Above). With fewer than 200 days of prices the cell shows —.
Three zones
| Zone | Price vs the average | Colour |
|---|---|---|
| Intact | at or above it | green |
| Below | under it, but above 85% of it | amber |
| Broken | at or under 85% of it | red |
▲ price
│ INTACT — at or above the average
│ ───────────────────────── 200-day average (100%)
│ BELOW — under it, above 85%
▼ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ 85% of the average
BROKEN — stocks: never a Dip How it is used
- Stocks: Broken reads Downtrend whatever the drawdown or volatility. Below still allows a Dip.
- ETFs: shown only. At major market bottoms broad funds often trade far below the average, and a trend rule would hide every dip.