I would like to get all known proposed and completed mergers/acquisitions in a given time frame.
I've researched this, looking at a few tickets:
https://community.developers.refinitiv.com/questions/58733/couldnt-find-deal-with-api.html
https://developers.refinitiv.com/en/article-catalog/article/eikon-data-api-cheat-sheet
I am using the C# API and can get a simple example working, such as:
ek.get_data("SCREEN(U(IN(DEALS)),BETWEEN(TR.MnAAnnDate,20230101,20231231))",["TR.MnAAnnDate","TR.MnATarget","TR.MnATargetPermId","TR.MnAAcquiror","TR.MnAAcquirorPermId"])
I have two problems/requests with this:
-I'd like to limit it to public companies only.
-I need the ticker symbol or RIC returned with each row so I know what company is involved. I've tried passing TR.TickerSymbol, TR.Instrument, and TR.RIC and none seem to work.
Please advise how I should do this. Thanks.