How do I use EIKON Data API with Python to pull MASRCH data?

eric.jian

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

Use Screener in Eikon Excel to set up the criteria for deals search. Click Screener button on Thomson Reuters tab in Excel ribbon. In the Screener wizard select Universe: Deals. Then setup search criteria, e.g. Deal Status include Pending, Deal Value >= 10 billion USD. If required modify report template by adding or removing columns. Click Insert Screen to paste screener expression into Excel worksheet, which results in a formula like the one below.

=TR("SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), IN(TR.MnAStatus,""P""), TR.MnADealValue(Curn=USD,Scale=9)>=10, CURN=USD)","TR.MnASDCDealNumber;TR.MnAAnnDate;TR.MnARankDate;TR.MnARankValueIncNetDebt(Scale=6);TR.MnATarget;TR.MnATargetPermId;TR.MnATargetMacroInd;TR.MnAAcquiror;TR.MnAAcquirorPermId;TR.MnAAcquirorMacroInd;TR.MnAStatus;TR.MnADealValue(Curn=USD,Scale=9)","CH=Fd")

Translate the above to the equivalent call using Eikon Data APIs in Python:

ek.get_data('''SCREEN(U(IN(DEALS))/*UNV:DEALSMNA*/,IN(TR.MnAStatus,"P"),
    TR.MnADealValue(Curn=USD,Scale=9)>=10,CURN=USD)''',
            ['TR.MnASDCDealNumber','TR.MnAAnnDate','TR.MnARankDate',
             'TR.MnARankValueIncNetDebt(Scale=6)','TR.MnATarget',
             'TR.MnATargetPermId','TR.MnATargetMacroInd','TR.MnAAcquiror',
             'TR.MnAAcquirorPermId','TR.MnAAcquirorMacroInd',
             'TR.MnAStatus','TR.MnADealValue(Curn=USD,Scale=9)'])

For more details on how to translate a call using =TR function in Eikon Excel to Python code using Eikon Data APIs see this tutorial.

All comments

Alex Putkov.1

Use Screener in Eikon Excel to set up the criteria for deals search. Click Screener button on Thomson Reuters tab in Excel ribbon. In the Screener wizard select Universe: Deals. Then setup search criteria, e.g. Deal Status include Pending, Deal Value >= 10 billion USD. If required modify report template by adding or removing columns. Click Insert Screen to paste screener expression into Excel worksheet, which results in a formula like the one below.

=TR("SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), IN(TR.MnAStatus,""P""), TR.MnADealValue(Curn=USD,Scale=9)>=10, CURN=USD)","TR.MnASDCDealNumber;TR.MnAAnnDate;TR.MnARankDate;TR.MnARankValueIncNetDebt(Scale=6);TR.MnATarget;TR.MnATargetPermId;TR.MnATargetMacroInd;TR.MnAAcquiror;TR.MnAAcquirorPermId;TR.MnAAcquirorMacroInd;TR.MnAStatus;TR.MnADealValue(Curn=USD,Scale=9)","CH=Fd")

Translate the above to the equivalent call using Eikon Data APIs in Python:

ek.get_data('''SCREEN(U(IN(DEALS))/*UNV:DEALSMNA*/,IN(TR.MnAStatus,"P"),
    TR.MnADealValue(Curn=USD,Scale=9)>=10,CURN=USD)''',
            ['TR.MnASDCDealNumber','TR.MnAAnnDate','TR.MnARankDate',
             'TR.MnARankValueIncNetDebt(Scale=6)','TR.MnATarget',
             'TR.MnATargetPermId','TR.MnATargetMacroInd','TR.MnAAcquiror',
             'TR.MnAAcquirorPermId','TR.MnAAcquirorMacroInd',
             'TR.MnAStatus','TR.MnADealValue(Curn=USD,Scale=9)'])

For more details on how to translate a call using =TR function in Eikon Excel to Python code using Eikon Data APIs see this tutorial.

eric.jian

Thank you for this. When I do a screening, if the number of results is greater than 15,000 it cannot be exported to excel. Is there a way export to excel even when the number of results is greater? Thanks

Zhenya Kovalyov

@eric.jian not really

eric.jian

Do you know where I can find the list of parameters like TR.MnAStatus for MnA deals?

Alex Putkov.1

Use Screener wizard in Eikon Excel.

eric.jian

The most recent announcement date of a deal that I see using this screener by Eikon Excel is 3/15/2019. On MASRCH, the most recent is 3/19/2019. How come the deals search provided by the Screener in Eikon Excel does not show the most recent deals 3/19/2019 (today)? Is there a way to use the Data API to retrieve the actual MASRCH data?

Zhenya Kovalyov

@eric.jian I would suggest raising this with your local Refinitiv Support Desk. Eikon API and Eikon Excel are sourced from the same database, so you can only replicate what you can see in Excel.

EXPLORE OUR SITES