eps actual and forecast
Posted: 24 February 2015 04:05 AM   [ Ignore ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Hi,

I need to get the following information for all french firms (annually):
a) actual eps
b)eps forecast
c) number of analyst following a company at the last EPS consensus forecast


Can anyone provide me with some help on which IBES datasets to use.

Thanks in advance.

Profile
 
 
Posted: 24 February 2015 09:27 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

How about this one:

ACTPSUM_EPSINT I/B/E/S Summary History - Actuals + Pricing and Ancillary File (EPS for International Region)
http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=40&file_id=53654

Select a few firms to see how the data behaves over time (there data is monthly, so you need to decide ‘when’ to measure it). Check the documentation to see what ‘FPI’ etc means.

best regards,

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: 20 March 2015 08:19 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Hi,
Thank you for your reply:)
I need more information about the difference between
https://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=40&file_id=53793 (The Institutional Brokers Estimates System provides consensus and detail forecasts from security analysts, including earnings per share, revenue, cash flow, long-term growth projections and stock recommendations. Dataset List → I/B/E/S (IBES) → I/B/E/S Summary History - Summary Statistics with Actuals (EPS for International Region) (STATSUM_EPSINT)
and
https://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=40&file_id=53789 (The Institutional Brokers Estimates System provides consensus and detail forecasts from security analysts, including earnings per share, revenue, cash flow, long-term growth projections and stock recommendations.Dataset List → I/B/E/S (IBES) → I/B/E/S Summary History - Unadjusted Summary Statistics (EPS for International Region) (STATSUMU_EPSINT)


Best regards,

Profile
 
 
Posted: 20 March 2015 09:31 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

The last ‘U’ in STATSUMU stands for ‘unadjusted’ (for stock splits). So, STATSUM is adjusted for stock splits, and STASTUMU is unadjusted.

Best regards,

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: 20 March 2015 11:22 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

smile thanks a lot, so it’s better to work with adjusted file rather unadjusted one.


Best regards

Profile
 
 
Posted: 20 March 2015 03:05 PM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

It is easier, but if your sample goes back a long time, and you have many observations that had ‘many’ stock splits, the stock split adjusted numbers can lose precision.

The drawback of using ‘unadjusted’, is that you need to do the adjustments yourself, which is a lot of work to do well. The IBES adjustment dates are not aligned with the ‘actual’ stock split date (as reflected in CRSP), which makes it harder.

So, I guess it is never easy here.. smile

Best regards,

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: 21 March 2015 05:47 AM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Ok, thanks a lot,  but if I need to khow firms that had a stock split during our sample period, I have to make a comparaison between adjusted and unadjusted file?

Profile
 
 
Posted: 21 March 2015 06:19 AM   [ Ignore ]   [ # 7 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

look at datasets ADJ and ADJSUM for stock split info used by IBES.

Best,

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: 22 March 2015 02:52 AM   [ Ignore ]   [ # 8 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Sorry again,

Please, can you explain me why from STATSUM, for such firms I have two actual value at the same date en End forecasting, what’s ?
for example for NEOPOST SA at 17/04/2003 (I/B/E/S Statistical Period (SAS Format))  EPS ANN 1 P EUR   I have two actual value , the first one is 2.94 31/03/2004 9:39:00 EUR
and the second is 2.74 31/03/2004 9:39:00 EUR.

Best,

Profile
 
 
Posted: 22 March 2015 06:10 AM   [ Ignore ]   [ # 9 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

I can’t find this firm; do you have its cusip or oftic?

thanks,

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: 22 March 2015 07:31 AM   [ Ignore ]   [ # 10 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Thank you again, 

EF561709 (CUSIP/SEDOL)


Best,

Profile
 
 
Posted: 22 March 2015 08:20 PM   [ Ignore ]   [ # 11 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

ok, a foreign company smile

Anyway, this must be a data error, as there is only one actual earnings for a fiscal year, and not two. Did you encounter many of these for your dataset?

Best regards,

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: 23 March 2015 10:54 AM   [ Ignore ]   [ # 12 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Thank you for your reply.

Until this moment, I found just this error in my dataset.. if I will find more, I will keep you informed.

Best regards,
Nabi smile

Profile
 
 
Posted: 23 March 2015 06:34 PM   [ Ignore ]   [ # 13 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Nabi,

If there are only a few observations like this (relative to your full sample), it will probably not matter for the results of your analyses.

Best regards,

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: 24 March 2015 04:49 AM   [ Ignore ]   [ # 14 ]
Newbie
Rank
Total Posts:  17
Joined  2015-02-23

Hi,
please, I need your help.
I need the data abaout french firms"nbre estimates, median est.mean est.sd. est and actual value” I work with summ file “adjusted for stock split”, I found for many firms “at the same time” two different actual value. At the beginning I think that is an error, but from 2000-2006, I report two diiferent actual value. I tried to verify with the file actual value and I find two different actual value. Please I need clarification, it is not clear.

Many thanks in advance for your reply.

Nabi

Profile