I have successfully pulled M&A historical data with this:
df, err = ek.get_data("SCREEN(U(IN(DEALS)),BETWEEN(TR.MnAAnnDate,20190501,20190503))",["TR.MnAAnnDate","TR.MnATarget","TR.MnAAcquiror"])
I have not been able to do this for specific merchants. Is there a way to do that?
Here's an example retrieving all the deals announced in the last 12 months (between today and the same date 1 year ago) where Qualcomm Inc is the acquiror or the acquiror's parent.
ek.get_data('SCREEN(U(IN(DEALS)), ' + 'IN(TR.MnAParticipant(DealPartRole=A:AIP:AUP:AMP),' + '"4295907706"), BETWEEN(TR.MnAAnnDate,20180716,20190716))', ['TR.MnASDCDealNumber','TR.MnAAnnDate','TR.MnATarget', 'TR.MnATargetPermId','TR.MnAAcquiror','TR.MnAAcquirorPermId', 'TR.MnATargetFinAdvisor(Concat="|")', 'TR.MnAAcquirorFinAdvisor(Concat="|")'])To construct a Screener expression follow the wizard behind the Screener button under Thomson Reuters tab in Excel ribbon.