IBES Actual file (actual EPS)
Posted: 15 January 2013 01:24 PM   [ Ignore ]
Newbie
Rank
Total Posts:  22
Joined  2013-01-15

Hi, I am new to IBES and like to get some help.

I use WRDS query to download actual data (with EPS actual value). see below
Obs TICKER PENDS     Value
1 CANI 19990131 0.3500
2 CANI 19990131 0.3500
3 CAO2 19990131 0.7367
4 CAO2 19990131 0.7367
5 CAO2 19990131 0.7367
6 CLEV 19990131 0.0000
7 EBSC 19990131 1.3200
8 ELBO 19990131 0.9700
9 ELBO 19990131 0.9600
10 ELBO 19990131 1.0000


the last column is the actual EPS, isn’t it? then why for the same firm (e.g. CANI) it has two records and all other duplicate record.

would you also point to an introductory material or research paper that explains the differences of actual file, detail file and summary data, so I can get on with IBES fast ?

thanks in advance!

-R

Profile
 
 
Posted: 17 January 2013 09:04 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Rochelle,

From which table do these numbers come from?

What I would recommend doing is to take a single year of a single firm (preferably with stock splits), and then download data for this firm-year of the tables that you think will have your data, and then see what is going on. Wrds has manuals online with what the fields mean, but it is best to see some actual (small set of) data.

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: 17 January 2013 05:15 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  22
Joined  2013-01-15

Thanks Joost !

I used internet query, and selected actutal file . I did not use SSH to download or use PC connect SAS code to pull data, so I can ‘t give you the data set name.

-  R

Profile
 
 
Posted: 17 January 2013 06:27 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Rochelle,

If you submit the form in the web interface, it will give a summary of which table it used (variables selected, conditions, etc).

It takes some time to get to know the tables. In general, there are different ‘types’ that are combined:
- US vs non-US
- summary (once a month) vs detail (continuous updates)
- adjusted (for stock splits) vs non-adjusted
- EPS vs non-EPS (for example sales forecasts)
- including actual eps or not

Table names indicate what is in there. For example, STATSUMU_EPSUS => STATSUM (summary statistics) + U (unadjusted) + _EPS + US

The number of tables has grown over the years for IBES; and if you scroll through them (http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=40) it is mind-boggling 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: 18 January 2013 09:46 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  22
Joined  2013-01-15

Hi, Joost

Thanks for your help again !

when using internet query, I did save the output information, it shows : Libraries/Data Sets : ibes/act / . this did not tell me which specific dataset my data come from.

I went to the link you send from your last response. (http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=40)

I do see a long list of dataset that is mind -boggling for newbie like me.

what I want to compute is simple: the sum of squared deviation between analyst individual EPS forecast and the actual EPS for U.S. firms. 

1. should I use ACT_EPSUS and DETU_EPSUS ?

2. if yes, should I then adjust for stock split ?

3. if yes, what is the best way of doing that ?

Looking forward to your reply ,


Best,

-R

Profile
 
 
Posted: 18 January 2013 03:55 PM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi R,

Working with actuals as opposed to the split adjusted is probably preferable. (A 2-1 stock split would impact the squared deviation quite a bit.)

I find the list of tables overwhelming as well smile

I suggest to make a selection of tables that you think are most appropriate, and then test it ‘manually’ for a few observations to see if the table has what you need and how you would need to manipulate the data.

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