IBES Summary and Detail database with analyst following
Posted: 01 April 2016 03:27 PM   [ Ignore ]
Newbie
Rank
Total Posts:  8
Joined  2015-01-26

Hi All,
I need to find out how many analysts following a company. I know there are two databases that I can look at: Summary and Detail.
So I searched the company with Ticker “AA” for year 2011 and the month is Febrary in both databases.

The Summary shows:
OFTIC   TICKER   FPEDATS   MEASURE   STATPERS   FPI   NUMEST   MEDEST   MEANEST

AA     AA     20111231     EPS     20110217   1     15     1.25     1.28

The Detail shows:
OFTIC   TICKER   FPEDATS   MEASURE   ANNDATS   FPI   ACTDATS   REVDATS   ESTIMATOR   VALUEAA    
AA     AA     20111231     EPS     20110211   1   20110214   20110321     00042     1.160

Both are for company AA, next year EPS, in Feb, 2010. Why the summary shows that there are 15 times of estimate and the Detail only shows one estimate?

I know there are differences between these two database and I read somewhere in the Forum about this question. However, I can not find those articles.

Thank you for your help.

 

Profile
 
 
Posted: 02 April 2016 04:26 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

The summary file is constructed using the detail file (with some corrections). For the #analysts I would use the summary file.

I am not sure about the length of the period, but the summary file counts the number of analysts that have given a forecast in the last 6 months for some period. So, you found 1 of those in Feb, but you would need to go back to a bunch of months before that as well.

Hope this helps,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 14 April 2016 06:31 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  13
Joined  2016-04-14
Joost Impink - 02 April 2016 04:26 PM

hi,

The summary file is constructed using the detail file (with some corrections). For the #analysts I would use the summary file.

I am not sure about the length of the period, but the summary file counts the number of analysts that have given a forecast in the last 6 months for some period. So, you found 1 of those in Feb, but you would need to go back to a bunch of months before that as well.

Hope this helps,

Joost

Hi,

I used the summary of IBES…why the forecast period end date is 12/31/2014..but there are 8 different number of analysts summary ?

Thank you so much!

Profile