50-Day Moving Average
Calculates the simple moving average of closing prices over the past 50 trading days.
Syntax
=Fifty_dayMovingAverage(Symbol)Returns
number
50-day simple moving average
Examples
=Fifty_dayMovingAverage("AAPL")When to Use
- Short-term trend analysis
- Technical trading signals
- Support/resistance levels
When NOT to Use
- Long-term trend analysis
Related Formulas
More MarketXLS Technical Indicators formulas you can use in the same worksheet:
- Average Daily Volume
- Average True Range (ATR)
- Average Volume 1 Year
- Average Volume 15 Days
- Average Volume 2 Years
- Average Volume 3 Months
- Average Volume 3 Years
- Average Volume 30 Days
See Fifty_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?