IMPORTANT: new estimates are now live. Historical data was rebuilt.

Here’s an example of how the data flows; using our Fundamental Charts . It’s for Bassett furniture. They pre-announced results , but the fundamentals updated the following week. Since the Fundamental Charts shows weekly data-points I color coded an “announcement week” in yellow, and a “filing week” in purple. The data points are available on the weekend , or the right edge of each box. It went down like this:

Announcement week (yellow)
1-BSET surprised by 22% in the middle of the week
2-Stock jumps to around 35
3-PE jumps to ~25 . This is the “stale” PE using fundamentals missing the latest period

Filing week (purple)
-Price goes up a bit more to ~36
-However PE drops to ~23 . This is the “real” PE using latest results

The change that went live last week now aligns analysts “CurrentQ” with pre-announcements regardless of fundamentals. Previously it was aligning the Current Quarter to Compustat, therefore all revisions were a week late.

Please note that there’s very little we can do about the “stale” PE that jumped to 25. This is an entirely different issue. All we can do is introduce a flag to detect periods where the data might be stale, which is coming soon.

Thanks


stalePE.gif

Thanks Marco for the explanation. It was very helpful. I checked all of my live Ports, and the biggest change was due to market timing rules. The ports now exit the market a little sooner and reenter the market sooner. In a few Ports some of the whipsaws disappeared.

There are MANY members who don’t bother to check the forum very often, and therefore will miss important announcements like this one.
I think that it would be wise for P123’s business to send an email to all members, first to explain an up coming changes with explanations like the one in your last post, and a second one to tell us when the change went live.

I’d like to point out some cause for alarm concerning the variable spepscy at least in relation to p123’s Fed Model, underscore what a difficult position the manner in which these recent estimates change has been implemented has placed at least some p123 subscribers, and propose a solution I hope will work for everyone’s benefit.

It does sound to me as if these changes represent improvements, and I am greatly appreciative of p123’s prodigious efforts to expand and improve both its data and the tools it makes available to its users.

However, I’m also worried that the changes have not been thoroughly investigated, and even if they have been thoroughly investigated I believe that p123 has made an obvious mistake, which is to assume that improved data can be seamlessly substituted into user sims and models without user exploration, experimentation and tinkering. Every p123 experienced subscriber must know that what we think is going to happen with our models and results is not always borne out by the data, that great data does not automatically lead to great models, and that improved data does not necessarily lead to better models, either.

The following underscores my concerns about lack of complete attention to spepscy and p123’s Fed Model. If these concerns seem obscure, let me point out that p123’s Fed Model is featured on p123’s own home page:

–>The model has indicated by the date shown, at least previously, that it is updated daily. But the Risk Premium does not change daily. It changes weekly.

→ On the Charts page:

Current Y Estimates Trend shows down
Next Y Estimates Trend shows down
Blended Y Estimates Trend shows up

Can the Current Y and Next Y Estimates Trends both be down and the Blended Estimates Trend be up? How are these trends calculated?

→ Again, on the Charts page, if you click on the choices next to EPS, nothing seems to change.

The practical problem with abrupt changes in data is that traders find themselves without adequate opportunity to update their models and screens, and therefore the models and screens traders rely upon can indicate one set of stocks one day and another set of stocks the next. Or the models indicate might indicate that one should be hedged one day and unhedged the next.

Therefore I’d like to suggest that p123 introduce important changes like this estimate change in a BETA-like manner so that subscribers have time to experiment and revise their models before needing to go live.

I learned a lot from improvements made earlier this year to the manner in which aggregated industry variables were handled, but it took some time. The immediate consequence of that change was confusion and stress.

In some cases I believe it’s possible that the old and new data series will both have value. For example, that was the case this year when UST10YR was introduced. The variable TNX still had value. In fact, the old TNX is more sensitive to change.

I am grateful for the the improvements p123 is making, but please give me, and presumably other p123 users, a chance to keep up!

Hugh

atw,

the Fed Model chart is displaying the same for CurrY & NextY. But if you download the data you will see that CurrY is 116.74 & NextY is 126.98.

The data is ok, it’s just a front end issue. Should be fixed soon. Thanks

Hi Marco,

Here are some troubling Fed Model-related numbers:

On March 12, 2001…

tnx is 49.19
spepcy is 55.8175
sprp is N/A

In 2002…

On May 6th:
tnx is 50.79
spepcy is 51.4017
sprp is 0.0111

On May 13th:
tnx is 52.20
spepcy is 51.5185
sprp is 0.0111

On May 20th:
tnx is 51.89
spepcy is 51.6191
sprp is 0.0111

On May 27th:
tnx is 51.38
spepcy is 51.6191 - no changes from the previous week to the 4th decimal point in estimated earnings for the entire S&P 500?
sprp is 0.0111 - sprp could be 0.0111 for four consecutive weeks?

Thanks very much.

Hugh

Hi Marco,

Is it possible to confirm that someone on staff is investigating the suspect data?

At least while uncertainties about the quality of the replacement data exist, is it possible to make the old data available?

Thanks very much.

Hugh

Marco is on vacation, but I can confirm that we’re investigating this.

Great, thanks.

Hugh

The source of the problem has been found and will be patched tonight.

Thanks Aaron. What was the issue?

When normal time series (e.g. for stocks, ETFs) are loaded, non-positive values are discarded, since they’re invalid in such contexts.
For other time series which are allowed to have non-positive values, a flag is set indicating that the data should not be sanitized in this manner.
I found a piece of code used to reload S&P500-related time series which failed to indicate the flag.
That being said, #SPRP was the only time series affected by this bug, and only before 2002/6/17.

Thanks very much for this and glad you were able to identify the issue. It sounds as if the bug was unrelated to the new earnings estimate release?

Hugh

Indeed it was. It’s basically raw data loaded from Compustat.