Is it possible to pull M&A historical data for specific Tickers using the API?

Question

Question by mitchell.gillespie · Jul 15, 2019 at 02:07 PM · eikon eikon-data-api python workspace workspace-data-api refinitiv-dataplatform-eikon corporate-actions

Is it possible to pull M&A historical data for specific Tickers using the API?

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?

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-07-16T11:58:23Z

REFINITIV

Best Answer

Answer by Alex Putkov.1 · Jul 16, 2019 at 11:58 AM

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.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is it possible to pull M&A historical data for specific Tickers using the API?

1 Reply

Watch this question

Related Questions