Duplicated Total Asset data for a 9-digit CUSIP- Compustat
Posted: 22 August 2014 01:44 PM   [ Ignore ]
Newbie
Rank
Total Posts:  10
Joined  2014-07-11

Hi all,

I retrieve data for a firm using the 9-digit CUSIP 000915306 using the file FUNDA.
I found two different records for its total asset for the year 1992. Same thing happens for the year 1993. I was wondering how this could happen and which one I should choose.
Thanks!
DN

Image Attachments
Screen_Shot_2014-08-22_at_2.38.12_PM.png
Profile
 
 
Posted: 23 August 2014 08:47 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Diep,

Funda has ‘multiple records’ for each firm-year; for the ‘regular’ firms in North America, add this to your query:

if indfmt='INDL' and datafmt='STD' and popsrc='D' and consol='C'

From Xpress-feed sample program: http://wrds-web.wharton.upenn.edu/wrds/support/Data/_003Sample Programs/Compustat/compna_funda1.cfm
“DATAFMT is the Data Format code that indicates how the data is collected and presented, with Standardized (STD) being the common and useful type. “

The difference in assets/sales is because of the dataformat (somehow) - see screenshot.

best regards,

Joost

 

Image Attachments
data_format.png
 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 August 2014 10:58 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  10
Joined  2014-07-11

That works just perfectly. Thank you Joost!
DN

Profile
 
 
Posted: 25 August 2014 11:32 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

Great, I’m glad it works! smile

Joost

 Signature 

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

Profile