Upgrade from Eikon -> Workspace. Learn about programming differences.
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.
Hello @alankar.gupta
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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/
