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")=Fifty_dayMovingAverage(A1)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
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?