Advance/Decline Cumulative Average

I've created a new dynamic, automatically updating spreadsheet for following the NYSE Advance Decline Cumulative Average. It's essentially the same as the TOS study I shared in my very first post, but the data now extends all the way into the 1960's. A word of warning; because of the massive data-pull (daily data for approx. 50 years), the spreadsheet easily takes a couple of minutes to load, even with a fast internet connection.

The study draws a line that is the running sum of the daily percent change of the advancing issues compared to declining issues, and another line that is a 252 day moving average (the typical number of trading days over one calendar year).

The study isn't a holy grail by any means, but can give early warning signs as well as early recovery signs, either by the signal line crossing over the moving average (which worked well signaling the beginning and end of the 2008 bear market) or by negative and positive divergences (e.g. during the period of 1998-2003).

In addition to the chart with the AD lines, I've included a chart with the S&P 500 index for comparison purposes.

QH AdvDecCumAvg Spreadsheet