For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I am looking to find how many company were divested or acquired by a company. Is there a way we can find it out?
I am able to fetch the deals data using the below code:
deals=ek.get_data("SCREEN(U(IN(DEALS)),BETWEEN(TR.MnAAnnDate,20190101,20200617))", ["TR.MnAAnnDate","TR.MnATarget","TR.MnATargetPermId","TR.MnAAcquiror","TR.MnAAcquirorPermId"])
I am specifically interested in getting the numbers.
I understand Refinitiv Helpdesk provided you with attached spreadsheet that retrieves the data you're looking for. And now you need help recreating the same data retrieval using Eikon Data APIs. The code snippet below recreates the same data retrieval as in the spreadsheet.
stock_ric = 'BAC.N'
dpr = 'A' #deal part role = 'A' for acquiror
cusip6 = ek.get_data(stock_ric,'TR.SDCCusip',raw_output=True)['data'][0][1]
scr_exp = f"SCREEN(U(IN(DEALS)),IN(TR.MNASDCCusip(DealPartRole={dpr}),{cusip6}))"
fields = ['TR.MnASDCDealNumber','TR.MnAAcquiror','TR.MnATarget','TR.MnAAnnDate',
'TR.MnARankDate','TR.MnADealValue(CURN=USD)','TR.MnASynopsis',
'TR.MnADealType','TR.MnAAttitude','TR.MnAStatus']
df, err = ek.get_data(scr_exp, fields)
df
This forum is not the best place to ask about content questions. For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
This forum is dedicated to things specific to the use of Eikon APIs.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/
