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)

Examples

=TwoHundredDayMovingAverage("AAPL")
Apple's 200-day MA
=TwoHundredDayMovingAverage("SPY")
S&P 500 ETF 200-day MA
=Last("AAPL")-TwoHundredDayMovingAverage("AAPL")
Distance from 200-day MA
=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

Q: Is this an EMA or SMA? A: This is a Simple Moving Average (SMA).

Q: Why is 200 days significant? A: 200 trading days is approximately one year of market data, making it a standard long-term indicator.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Two Hundred Days Moving Average and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions