Percent Change From 200-Day Moving Average
Calculates the percentage change between current price and 200-day moving average.
Syntax
=PercentChangeFrom200_dayMovingAverage(Symbol)Returns
number
Percent change from 200-day MA
Examples
=PercentChangeFrom200_dayMovingAverage("AAPL")=PercentChangeFrom200_dayMovingAverage(A1)When to Use
- Relative trend analysis
- Screening for stocks above/below trend
When NOT to Use
- Absolute dollar change needed
Related Formulas
More MarketXLS Technical Indicators formulas you can use in the same worksheet:
- Percent Change From 50 Day Moving Average
- Plus Directional Indicator (+DI)
- Relative Strength Index (RSI)
- Simple Moving Average (SMA)
- SMA (Simple Moving Average)
- Standard Deviation
- Technical Indicator (Generic)
- Technical Score
See PercentChangeFrom200_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?