Knowledge Base

These sources allow you to screen for Initial Public Offerings (IPO) and other deal types. Some will also provide or link to additional details or commentary about the deal.

To Build Lists

• Zephyr – see Zephyr access help

1. Choose Zephyr Advanced to build a customized list.
2. Choose Deal types & method of payment > Deal type > IPO. Click OK
3. Find additional limiters by clicking on Alphabetical List or typing in Find a criterion box.
4. When done click the View list of deals at the bottom of the page.

• LSEG Workspace – see LSEG Workspace access help

1. Search for and open the Screener app.
2. On the left, next to Universe change the dropdown to Deals.
3. In the dropdown next to Include: Asset Class select Equity.
4. In the Add Filter search box enter Issue Type and select IPO and/or Follow-On and press Done. Alternatively, use the Original IPO Flag.
5. Add other filters. Use the options above the results to add or remove columns, filter, and sort.

• Capital IQ – see Capital IQ access help

1. Hover over the Screening tab and select Transactions.
2. In the General Transaction Details box select Types. Add Public Offerings to the search criteria.
3. In the General Transaction Details box select Transaction Primary Features. Add Public Offerings-IPO.
4. Add any additional search criteria and click View Results.

• FactSet – see FactSet access help

1. Choose FactSet Web Interface.
2. Choose Idea Screening > Transactions > IPO & Follow Ons.
3. Choose appropriate variables from list to filter results and click View.

For a Large Dataset

• SDC Platinum – see SDC Platinum access help
  • This is one of the main sources used in academic papers.
  • How to download data from SDC Platinum. To get a universe of either IPOs or Secondary Listings, when building the search/screen in the Global New Issues Database use the IPO Flag Y/N variable.
• For a wealth of IPO related data and lists of IPOs that are often used as a base universe for additional academic research papers, see University of Florida's Professor Jay Ritter's website.