200-Day Moving Average

Calculates the simple moving average of closing prices over the past 200 trading days.

When to Use

  • Long-term trend analysis
  • Bull/bear market indicator
  • Major support/resistance levels

When NOT to Use

  • Short-term trading signals

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 200-Day Moving Average and Other Financial Formulas
How does MarketXLS work?