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

• 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.