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")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
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?