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

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.