200-Day Moving Average
Calculates the simple moving average of closing prices over the past 200 trading days.
Syntax
=TwoHundred_dayMovingAverage(Symbol)Returns
number
200-day simple moving average
Examples
=TwoHundred_dayMovingAverage("AAPL")=TwoHundred_dayMovingAverage(A1)When to Use
- Long-term trend analysis
- Bull/bear market indicator
- Major support/resistance levels
When NOT to Use
- Short-term trading signals
Related Formulas
More MarketXLS Technical Indicators formulas you can use in the same worksheet:
- Average Daily Volume
- Average True Range (ATR)
- Average Volume 1 Year
- Average Volume 15 Days
- Average Volume 2 Years
- Average Volume 3 Months
- Average Volume 3 Years
- Average Volume 30 Days
See TwoHundred_dayMovingAverage used in a complete workbook: Moving Average Excel: Build an SMA and EMA Crossover Dashboard That Updates Itself
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?