Question about the effect of currency on EPS estimates in detail file
Posted: 25 January 2015 07:15 AM   [ Ignore ]
Newbie
Rank
Total Posts:  4
Joined  2015-01-25

Hi everyone,

When I used the IBES unadjusted detail file, I found some EPS estimates (annual) are more than 2000.00. For EPS, this is very strange. Is it because of changing of currency used in firms’ reporting? (I think stock split should not be the reason) How should I deal with this problem? The dataset contains several currency flags, but I don’t know how to take use of them.

Thank you for any advice!

Profile
 
 
Posted: 25 January 2015 08:49 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Jasmin,

Do you have a sample record (ibes ticker, and forecast period/details) where this is the case?

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: 25 January 2015 09:27 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  4
Joined  2015-01-25

Hi Joost,

The following is some cases in my data from IBES unadjusted detail file. Each observation represents the analyst’s forecast for annual EPS (fpedats refers to the ending of month and year which the forecast applies) at different time points; value refers to the forecasted EPS:

*******************************************************************************
analys ticker cname           fpedats         fpi   curr report_curr pdf measure value
0 @008 MASTER           31dec2004 1       THB THB         P EPS       .91
0 @01A POSDATA CO LTD(P 31dec2000 1   KRW KRW         P EPS       2593
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       1957.304
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2098.569
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2404.406
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2089
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       1880.92
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2588.938
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       3034.625
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2229.745
0 @01A POSDATA CO LTD(P 31dec2001 1   KRW KRW         P EPS       2588.072
574 LINZ LINDSAY MFG           31aug2001 1           USD         D EPS       .73
574 LINZ LINDSAY MFG           31aug2002 1           USD         D EPS       .97
574 LINZ LINDSAY MFG           31aug2002 1           USD         D EPS       .93
574 LTV       LTV CORP           31dec1986 1       USD         P EPS       -.01
574 LUC       LUKENS INC       31dec1985 1       USD         P EPS       .495
574 LUC       LUKENS INC       31dec1985 1       USD         P EPS       .99
********************************************************************************

 

 

Profile
 
 
Posted: 25 January 2015 11:38 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

1000 KRW (South Korean Wong) is approx $1 USD, so the 2,000 seems to be a reasonable number
https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=usd+to+krw

There are tables in Compustat to convert 200+ currencies to British Pounds (GBP) (which you could then convert to USD).

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: 26 January 2015 07:19 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  4
Joined  2015-01-25

Thank you very much ! It is really helpful!

Profile
 
 
Posted: 26 January 2015 07:26 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

smile

 Signature 

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

Profile