Divining Future S&P 500 Closing Prices!

March 28th, 2013 by 
PK

There's a few topics we like to return to now and again on this website - our "go-tos" if you will.  A few years back we noted that options, although not instruments that we often use, are awesome since the price signals they give us let us estimate three different things:

  1. Direction - Will a security trade up or down?
  2. Magnitude - How large a move will a security make?
  3. Timeframe - How quickly will the security move?

Compare that to stocks - if someone is buying, that means that they are betraying the direction they think the stock will go (up).  We don't have a clue about the other two.  In essense, the information given to us by options is three times more valuable than that of stocks.

Well, Of Course Options Are Better...

Yes, you're right, Don't Quit Your Day Job wasn't the first to use this metadata to  build indicators.  People have been watching options price movements for years, and concepts like Options Pain were well known before our site even started.

However, we take it a bit further.  We built an options 'implied closing price' calculator way back in December of 2011.  You can see the initial results of that effort here, and our thoughts on the quality of the signals (not so amazing).

So why continue to push the issue?  Truly, there is some mispricing in the options market one of you sharp eyed and quick witted readers can take advantage of... something which might even become evident from me posting these graphs and these charts (The gap between 'High' and 'Low' is 75 percentage points - as in, implied odds are 12.5% more and 12.5% less):

S&P Closing prices predicted by my options tool.And the calls...

Implied closing prices for S&P 500 based on SPY calls.

How Do You Predict the S&P 500 Closing Price?

Simple, in a way.  The ETF 'SPY' trades for roughly 10% of the value of the S&P 500, so I used the long dated options of that ETF to build these predictions.  Roughly, we look at the intrinsic value and the implied time value, and figure out the clusters (automatically) to try to determine where traders think the pricing will fall.  Here's the data presented in chart form (Dates are 'options closing' dates):

2013-042013-052013-062013-072013-092013-122014-012014-032015-012015-12
Put High157015801582.15158015601601.7315551621.661642.791650.39
Put Medium1550154015401527.841441.53150014651442.371448.241425
Put Low15101470144013651350134512651198.711244.961142.09
2013-042013-052013-062013-072013-092013-122014-012014-032015-012015-12
Call High15801591.6516101611.551651.03162515951699.4615251860.34
Call Medium15601552.1215601559.711568.3915751542.261552.11461.591552.85
Call Low1532151015001512.3155015351489.641478.5914151395.42

As you would expect, uncertainty increases as you move further out in time. These results were retrieved after the market closed on March 28th, so try to figure out where the mispricings lie before the market reopens.

How to Use These S&P 500 Predicted Closing Prices?

Well, we haven't yet gotten around to trying to tease out some correlations and actionable trades on this - but if you read our warning article above, you'll note that the predictions implied by options were only correct 44.3% of the time... even though 75% was implied by pricing.  That means that over the universe of the predictions we pulled, over 50% of closing prices were in the implied 25% area - and usually higher.

An amazing year?  A coincidence?  Well, we won't know for a while - but I present these numbers as is.  Hopefully one of you makes a ton of money off of this information!

      

PK

PK started DQYDJ in 2009 to research and discuss finance and investing and help answer financial questions. He's expanded DQYDJ to build visualizations, calculators, and interactive tools.

PK lives in New Hampshire with his wife, kids, and dog.

Don't Quit Your Day Job...

DQYDJ may be compensated by our partners if you make purchases through links. See our disclosures page. As an Amazon Associate we earn from qualifying purchases.
Sign Up For Emails
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram