Hi team, is there currently a way to search for SPAC deals using the RDP API?

mansoor.elahi
mansoor.elahi LSEG
in Refinitiv Data Platform

I know we can query the M&A database, but wondering if we can do the same for Equity deals via RDP in codebook - specifically for SPAC IPOs. Using the deals screener in Workspace we would pull in a flag for "blank check or spac involvement" and set it to true. Can this be done via RDP as well?

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @mansoor.elahi

    Screener expression produced by Deals Screener can be used as the first argument in the get_data method of Eikon Data APIs. The example below returns SPAC IPOs with UK as the target market and issue date YTD.

    screen_exp = ('SCREEN(U(IN(DEALS)),TR.NIisECM=True,'
                  'TR.NIIsBlankCheckCompany==true,IN(TR.NITargetMarket,"UK"),'
                  'relativedate(TR.NIIssueDate,YTD), CURN=USD)')
    df, err = ek.get_data(screen_exp,
                         ['TR.NIDealID','TR.NIIssueDate','TR.NIIssuer',
                          'TR.NIIssuerPermId','TR.NIIssueType(Concat="|")',
                          'TR.NITransactionStatus','TR.NIIssuerNation',
                          'TR.NIOfferPrice',
                          'TR.NIProceedsAmtInclOverallotSoldAllMkts(Scale=6)',
                          'TR.NISecurityTypeAllMkt',
                          'TR.NIOfferingTechnique(Concat="|")'])

Answers

Categories