Change From 200-Day Moving Average

Calculates the absolute dollar change between current price and 200-day moving average.

Syntax

=ChangeFrom200_dayMovingAverage(Symbol)

Excel Desktop (Windows)

Returns

number

Dollar change from 200-day MA

Examples

=ChangeFrom200_dayMovingAverage("AAPL")

=ChangeFrom200_dayMovingAverage(A1)

When to Use

Measuring distance from long-term trend
Trend strength analysis

When NOT to Use

Percentage-based analysis

Excel Templates Using Change From 200-Day Moving Average

These ready-made MarketXLS templates call ChangeFrom200_dayMovingAverage() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Technical Indicators formulas you can use in the same worksheet:

See ChangeFrom200_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

MarketXLS Excel Add-in Tutorial - How to Use Change From 200-Day Moving Average and Other Financial Formulas

▶

How does MarketXLS work?