Two Hundred Day Moving Average
Returns the 200-day simple moving average (SMA) of closing prices for a stock. This is one of the most important technical indicators for identifying long-term trends.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Technical Analysis Use
- Price above 200 MA: Long-term uptrend (bullish)
- Price below 200 MA: Long-term downtrend (bearish)
- 50 MA crossing above 200 MA: Golden Cross (very bullish)
- 50 MA crossing below 200 MA: Death Cross (very bearish)
Syntax
=TwoHundredDayMovingAverage(Symbol)Returns
number
200-day simple moving average price
Examples
=TwoHundredDayMovingAverage("AAPL")=TwoHundredDayMovingAverage("SPY")=Last("AAPL")-TwoHundredDayMovingAverage("AAPL")=IF(FiftyDayMovingAverage("AAPL")>TwoHundredDayMovingAverage("AAPL"),"Golden Cross Zone","Death Cross Zone")When to Use
- Identifying long-term trend direction
- Finding major support/resistance levels
- Golden/Death cross analysis
- Long-term investment decisions
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 50-day MA | FiftyDayMovingAverage() |
| Need custom period | SimpleMovingAverage() |
| Need EMA | ExponentialMovingAverage() |
Common Issues & FAQ
Is this an EMA or SMA?
This is a Simple Moving Average (SMA).
Why is 200 days significant?
200 trading days is approximately one year of market data, making it a standard long-term indicator.
Related Formulas
More MarketXLS Technical Indicators formulas you can use in the same worksheet:
- Williams %R Indicator
- 200-Day Moving Average
- 50-Day Moving Average
- Average Daily Volume
- Average True Range (ATR)
- Average Volume 1 Year
- Average Volume 15 Days
- Average Volume 2 Years
See TwoHundredDayMovingAverage used in a complete workbook: Bank Earnings Tracker Excel: Q1 2026 Dashboard for Fed-Sensitive Financial Stocks
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?