From North America Fundamentals Annual, some balance sheet entries are missing for all
Posted: 23 November 2014 12:09 AM   [ Ignore ]
Newbie
Rank
Total Posts:  2
Joined  2014-11-22

Hi all,

I downloaded all companies for the whole available time span (1950-2014) with checking all the possible variables.
From the downloaded file (over 3G), one of the variables I need (IST—Investment Securities -Total) is completely missing. No observation has any value for that variable.

I looked at other variables such as sales (sale) or cash (ch), but they were not like this.

Does anyone have an idea about this?

All best,
John

Profile
 
 
Posted: 23 November 2014 06:18 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi John,

I did a search on Compustat Bank, there this variable is 99+% available. So, it appears to be a ‘banking’ variable that made it into the ‘industrial’ list (Funda).

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 November 2014 12:56 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  2
Joined  2014-11-22

Hi Joost,

I just realized that.
Thank you!

Best,
John

Profile