Change From 50-Day Moving Average

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

Syntax

=ChangeFrom50_dayMovingAverage(Symbol)

Excel Desktop (Windows)

Returns

number

Dollar change from 50-day MA

Examples

=ChangeFrom50_dayMovingAverage("AAPL")

=ChangeFrom50_dayMovingAverage(A1)

When to Use

Measuring distance from short-term trend
Short-term trend strength analysis

When NOT to Use

Percentage-based analysis

Excel Templates Using Change From 50-Day Moving Average

These ready-made MarketXLS templates call ChangeFrom50_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 ChangeFrom50_dayMovingAverage used in a complete workbook: Oil Price Shock Portfolio Hedge Excel: Protect Your Investments During Energy Crises in 2026

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 50-Day Moving Average and Other Financial Formulas

▶

How does MarketXLS work?