200-Day Moving Average
Calculates the simple moving average of closing prices over the past 200 trading days.
Syntax
=TwoHundred_dayMovingAverage(Symbol)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:
