Screening the Compustat Database for IPOs that happened in a certain time interval
Posted: 09 March 2013 07:45 AM   [ Ignore ]
Total Posts:  1
Joined  2013-03-09


I have a question regarding IPOs and “searching the entire database”.

I want have the names and dates of all companies that IPOed after 2010 at the NYSE.

My approach is to “search the entire dataset” with the logical conditions:
IPO Date > 2010/01/01
Security Exchange code = 11

As an output, I only want to have the IPO dates, the ticker and the company names.

However, there is no output returned. Probably because i am searching the complete dataset and the delivered output is greater than 2 gigabyte.

Am I missing something here? The names and dates etc, of all the companies , delivered in a zppped .xls format is never going to be greater than two gigabyte.
Does someone see the error that I am making?

Thanks for any help!

Posted: 12 March 2013 10:50 AM   [ Ignore ]   [ # 1 ]
Total Posts:  901
Joined  2011-09-19

hi JPeters,

The first thing that comes to mind is that the date filter may not work, because the resulting dataset shouldn’t be too large (definitely not empty).
Maybe you can ‘play’ a little with different formats.

An alternative is using Jay Ritter’s IPO data, which is publicly available, see




To reply/post new questions: Please use the group WRDS/SAS on Google Groups!