SQL Query for IPOs

archit_chauhan

Currently, we are able to access information about upcoming IPOs through Dscreen. Could you please confirm if there is any database table available that we can query directly via SQL to fetch the latest announced upcoming IPOs?

Specifically, we’d like to know:

• If such a table exists in our database
• The schema or table name we should use
• Whether we can run a daily query to automatically retrieve the most recent IPO announcements
• Or, if possible, could you provide a sample SQL query that we can use as a reference?

Jirapongse

@archit_chauhan

Thank you for reaching out to us.

If you have the screener formula, you can use it with the LSEG Data Library for Python to retrieve the same set of data. For further guidance please refer to the Find Your Right Companies with SCREENER | the Data Library (Python) article.

For example:

df = ld.get_data(
    universe=['SCREEN(U(IN(DEALS)),TR.NIisECM=True, IN(TR.NITargetMarket,"US"), IN(TR.NIIssueType,"IPO"), IN(TR.NITransactionStatus,"INPROGRESS"), CURN=USD)'],
    fields=["TR.NIDealID","TR.NISdcPackageNumber","TR.NIMasterDealType.code",
            "TR.NIAllManagersRole(Concat='|').code","TR.NIManagersRole(Concat='|').code",
            "TR.NIIssueDate","TR.NIIssuer","TR.NIIssuerPermId","TR.NIIssueType(Concat='|')",
            "TR.NITransactionStatus","TR.NIIssuerNation","TR.NICurrentFilingDate","TR.NIOfferPricePrintUniform",
            "TR.NIProceedsAmtInclOverallotSoldAllMkts(Scale=6)","TR.NIProceedsAmtThisMkt(Scale=6)","TR.NIIssuerExchTicker(Concat='|')"])
df

Regarding SQL, please first confirm which LSEG product you are using. Alternatively, you can contact your LSEG account team or sales representative to determine which LSEG products are best suited to your requirements.