What are all the variables related to SDC Platinum that are present in the "Data Item Browser" of...

nicola.fiore
nicola.fiore Newcomer
in Eikon Data APIs
What are all the variables related to SDC Platinum that are present in the "Data Item Browser" of Refinitiv? (I am particularly interested in "private placement" transactions and "unregistered offerings")
Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @nicola.fiore

    Thank you for the clarification. You can retrieve M&A data using Eikon Data APIs. The data source for M&A data is the same between SDC Platinum and Eikon, however the metadata (field names and parameters) are different. E.g. in SDC Platinum the field name for Target Macro Industry is TTF_MACRO_CODE, whereas in Eikon the field name is TR.MnATargetMacroInd. The field names related to this dataset are listed under Deals category in content classification in the Data Item Browser app. However in practice you probably always want to use Screener to retrieve M&A data. In the Screener app select Deals from the drop-down for the Universe and then follow the wizard to construct Screener expression. E.g. the following expression retrieves all deals announced year to date where the target's business activity falls under Wind Systems & Equipment according to TRBC classification scheme.

    ek.get_data(('SCREEN(U(IN(DEALS)),IN(TR.MnATRBCActivity,"5020101011"),'
                'relativedate(TR.MnAAnnDate,YTD))'),
                ['TR.MnASDCDealNumber','TR.MnAAnnDate','TR.MnATarget',
                 'TR.MnATargetPermId','TR.MnATargetMacroInd',
                 'TR.MnATargetMidInd','TR.MnATargetNation',
                 'TR.MnAAcquiror','TR.MnAAcquirorPermId',
                 'TR.MnAAcquirorMacroInd','TR.MnAAcquirorMidInd',
                 'TR.MnAAcquirorNation',
                 'TR.MnATargetFinAdvisor','TR.MnAAcquirorFinAdvisor',
                 'TR.MnATRBCActivity'])

    See the article titled "Find Your Right Companies with SCREENER | Eikon Data APIs(Python)" for details about using Screener in Eikon Data APIs.

Answers

Categories