firm first included in COMPUSTAT
Posted: 02 September 2014 04:31 AM   [ Ignore ]
Newbie
Rank
Total Posts:  2
Joined  2014-09-02

I need the total number of years since a firm was included in the Global or NA COMPUSTAT database ...

Has anyone an indea how to get this information most easily (using web query) ...

Thank you

Profile
 
 
Posted: 02 September 2014 07:53 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

For North America, this info is in ‘Compustat Names’: http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65815

It holds a variable ‘year1’ (First Fiscal Year of Available Accounting Data).

By the way, Compustat has data on the firm typically 2-3 years before the IPO. (This data is taken from the prospectus).

I didn’t see a web form to download this through a web query though..

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: 02 September 2014 07:56 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  2
Joined  2014-09-02

Thank your for your answer. smile

I know that it is possible to get the infomation via SAS (year1). However, I’m using the web query and was wondering whether it is also possible to get the variable aslo via the web query ...

Profile
 
 
Posted: 02 September 2014 07:59 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

ok smile

I couldn’t find a form for web query, so it looks like you need to get your hands dirty 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
 
 
Posted: 12 June 2016 10:31 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  3
Joined  2016-03-21
Joost Impink - 02 September 2014 07:53 AM

hi,

For North America, this info is in ‘Compustat Names’: http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65815

It holds a variable ‘year1’ (First Fiscal Year of Available Accounting Data).

By the way, Compustat has data on the firm typically 2-3 years before the IPO. (This data is taken from the prospectus).

I didn’t see a web form to download this through a web query though..

Hope this helps,

Joost

Hi! If I click the URL to find the year1 variable for firms I get an ampty page with this message: There are no variables available for the selected file.
I used to be able to check the variables, but now the page is gone. Anyone an idea what I am doing wrong?

Robin

Profile
 
 
Posted: 12 June 2016 01:21 PM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Robin,

Seems to work for me. Which url are you clicking (what is the link)?

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: 13 June 2016 02:19 AM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  3
Joined  2016-03-21
Joost Impink - 12 June 2016 01:21 PM

hi Robin,

Seems to work for me. Which url are you clicking (what is the link)?

Best,

Joost

This one: http://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65815
But it seems to work fine again. Don´t know what happend yesterday.

Robin

Profile
 
 
Posted: 13 June 2016 12:01 PM   [ Ignore ]   [ # 7 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

ok smile

 Signature 

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

Profile