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

eric.jian
eric.jian Newcomer
in Eikon Data APIs
How do I use EIKON Data API with Python to pull MASRCH data?
Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓
    • 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.

Answers

Categories