Accessing Equity Deals from DSCREEN

scott.curry

I'm able to pull in M&A transactions from DSCREEN using the below API call:

df, err = ek.get_data('SCREEN(U(IN(DEALS)), BETWEEN(TR.MnAAnnDate,19991031,20001031), CURN=USD)',
                        fields=['TR.MnASDCDealNumber',
                                    'TR.MnAAnnDate',
                                    'TR.MnARankDate',
                                    'TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)',
                                    'TR.MnATarget,TR.MnATargetPermId',
                                    'TR.MnAAcquiror',
                                    'TR.MnAAcquirorPermId',
                                    'TR.MnAAcquirorMacroInd',
                                    'TR.MnAAcquirorMidInd',
                                    'TR.MnAAcquirorNation',
                                    'TR.MnAStatus'])

How can I pull deals from the other asset classes using this, or another, API?

raksina.samasiri

Hi @scott.curry ,

Have you had a chance to check an article Find Your Right Companies with SCREENER | Eikon Data APIs(Python) yet?

Using the export formula in Screener app will provide you how to put the filter in the Python code for Eikon Data API

Hope this helps and please do let me know in case you have any further questions.