Quality of the Economy - Looking at the markets and making predictions

Tim Folkerts

Trusted Information Resource
Since we are looking at the markets and making predictions, I thougth I'd try my own hand at it. Here at first is a stab at I-Charts of the S&P 500. (The following is a potential "first blog entry" for an on-going blog about such topics.)


The I-Chart provides a standard way in Quality Engineering to look for changes in a process. A data point is recorded at regular intervals and various tests are performed to see if there has been a change in the process -- to see if hte process is "out of control".


In this case, the market forces shaping the S&P500 is the "process" and we are looking at the % change in the closing value from the previous day. (By using % change, we can more easily & effectively compare with other measures - like the DJIA - and also with previous decades when the closing values were much lower.)


Several tests are common for I-Charts to see if there has been a change in the process. Five tests were used to see if the process was "out of control"


  • a single point more than 3 standard deviations from the mean
    looking for highly unusual single days
  • 2 out of 3 points more than 2 standard deviations from the mean
    looking for a small cluster of fairly unusual days
  • 4 out of 5 points more than 1 standard deviations from the mean
    looking for a week of moderately unusual days
  • 15 points within 1 standard deviation of the mean
    3 weeks with unusually little change in the markets
  • 9 points in a row on one side of the mean
    a 2 week run up or down


Control limits were calculated using the first 100 days in each interval. When two or more of these oot-of-control conditions were detected in a short period of time, a shift was assumed to have occurred and new control limits calculated. The most common out-of-control conditions were the first (signaling increased variability) and the 4th (signaling decreased variability).


During the first half of the decade, there are two major periods.
Quality of the Economy - Looking at the markets and making predictions


  • Up through April 2003, the market showed considerable variability. Several sub-intervals might be identified, but for the most part the control limits (the +/- 3 standard deviation limits) were around 4% to 5%. in other words, days when the closing valuechanged by 4 or 5 percent were not atypical.
  • After April 2003, the control limits tightened considerably. Now the control limits were down near 2.4%. It is easy to see the change on the graph - the values are much mroe densly packed near the center.




The rest of the decade shows more trends. (Notice first of all that the scale is much different here, about twice as great on the y axis.)

Quality of the Economy - Looking at the markets and making predictions


  • 2005 through mid-2007 continues the tight control limits a small daily variability.
  • around July 2007, the variability increased - almost doubling. The process stayed at these limits for about a year
  • October saw unprecedented variability. Never in the history of the S&P 500 was the variability as great. The data ends 23-OCT-2008, but, given the state of the markets (Mid NOvermber as this is being written) I expect the large control limits are still in effect.


In the future, I plan to look at:


  • how other measures compare with these results -- for example the DJIA or foreign markets.
  • see if there are way to either predict the the changes, or to use the changes to predict other financial measures
  • Others??? We will see.
 

Tim Folkerts

Trusted Information Resource
Here is one follow-up - we'll see what interest it draws.


I completed I-Charts of the % change from the previous day for the measurement indicated. There are some strong similarities ... but also some differences.






Take a look a minute …
Quality of the Economy - Looking at the markets and making predictions
I-Chart of DJIA 1990 - 2008



Quality of the Economy - Looking at the markets and making predictions
I-Chart of S&P500



Quality of the Economy - Looking at the markets and making predictions
I-Chart of FTSE100 (London)




Quality of the Economy - Looking at the markets and making predictions
I-Chart of Nikkei (Japan)



Quality of the Economy - Looking at the markets and making predictions
US 10 Year Treasuries



Quality of the Economy - Looking at the markets and making predictions
I-Chart of Oil Prices (WTI Spot Price)





These charts are looking at volatility on the markets… how much they change from one day to the next. All cover identical time periods (Jan 1, 1990 - Oct 23, 2008.)

  • The degree of volatility during the entire 18 yr period is measured by the width of the “control limits” (labeled UCL or “upper control limit” and LCL for “lower control limit). The volatility (from highest to lowest) is
    1. Oil
    2. Nikkei
    3. 10 Year treasuries
    4. FTSE, S&P500 and DJIA tied for all practical purpuses.

  • The DJIA, S&P500 and FTSE were very similar over this period.
    * A moderately volatile period from 1990-1991
    * A quite period from 1992-1996
    * A rather volitle period from 1997-2003
    * A quite period from 2003-2007
    * More volatility again from mid 2007
    * Extreme volatility in October 2008
  • The price of oil followed a similar pattern, although the quiet period in the mid 2000’s started later.
Not sure what it all means yet, but I think there is something here :)
 
Top Bottom