impact of ESG in M&A transactions

angelica.schioppi

Hello, I would like to know how I can select filters for my research regarding the impact of ESG factors in M&A transactions, initially for a general search, then for a comparison between Asia, Europe, and America, and subsequently for an analysis between sectors. Finally, I would like to compare the ESG scores of the target and acquirer one year before and one year after the conclusion of the deal. The analysis will then be conducted in Excel. Can anyone advise me on how to proceed?

[Deleted User]

Hi @angelica.schioppi ,

I believe using Search in Python might be best suited for your research; you can then export this data in excel with pandas (to_excel). I would suggest maybe using CodeBook (more about it here) if you are not familiar with Python, so that you don't have to go through start up instalations.

angelica.schioppi

https://community.developers.refinitiv.com/discussion/comment/115540#Comment_115540

How do I find the ESG scores for the three pillars in the Refinitiv Workspace related to M&A?

[Deleted User]

https://community.developers.refinitiv.com/discussion/comment/115529#Comment_115529

Hi @angelica.schioppi ,

Metadata (such as the fields for specific datasets) vis-à-vis Search can be found as shown in the article, under Properties and Metadata.

angelica.schioppi

https://community.developers.refinitiv.com/discussion/comment/115540#Comment_115540

what filter should I add on refinitiv workspace to find out whether the transaction was paid in cash or shares?

[Deleted User]

https://community.developers.refinitiv.com/discussion/comment/115578#Comment_115578

Hi @angelica.schioppi, Please note that this LSEG Developer Q&A Forum is for technical questions related to LSEG APIs only. For Application (e.g.: Workspace) questions such as yours, please reach out to my.refinitiv.com.

When it comes to the Search API, filters such as this can be found by outputting the fields to excel, as per the article, as aforementioned. However, if this is insufficient, my colleague also built a browser for the Search API; you can read bout it here:

Build queries easily using Refinitiv's Search API with Python and Jupyter | Devportal (lseg.com)