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