CurFYEPS1WkAgo does not equal FHist("CurFYEPSMean",1)

Report a problem or error
1

CurFYEPS1WkAgo does not equal FHist(“CurFYEPSMean”,1), but I would expect them to be the same. See screenshot below.

Capture.JPG
Capture.JPG962×442 64.7 KB

2

FHist pulls data from weekly snapshots. CurFYEPS1WkAgo is based on latest data from last night. If you set the as-of date to 4/13/14 they match.

ALSO: I would NOT use FHist with estimates. You may be pulling in a different fiscal year: FHist (“CurrFYEPSMean”,0) may be a different fiscal year than FHist("CurrFYEPSMean,1). The CURFYESPXXX factors make sure that they are all pointing to the same fiscal year.

3

Thank you for the explanation, so a robust custom formula such as CurFYEPS2WkAgo cannot be created by us?

Edit:
One more thing: On the server status page I read “Estimate Revision Data as of 04/12/14”, which gives me the impression that there were no estimate updates last night.

4

Correct.

Revision factors are a subset of estimates and they are only weekly. Things like Up/Dn revisions.

5

Thanks Marco! Great support.