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?
3
●1 ●3 ●6
Hi team, is there currently a way to search for SPAC deals using the RDP API?
Hello @mansoor.elahi
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
39.4k
●77 ●11 ●27
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="|")'])
Thanks Alex! Would something similar be possible via RDP / do we have any documentation around querying our deals database via RDP?
1
●1 ●4 ●8
what if the blank check company hasn't yet found a target, is there a way to pull the blank check company row in even if they aren't yet in a deal?
