ESG scores
Hello,
How can I get ESG overall and each component score for the acquirers in M&A transactions five years before and after the transaction? I want US deals only during 2010 onwards. In the Refinitiv workspace I can only see the scores per company, but is there any tool that can display the scores for a set of companies during specific period?
Best Answer
-
Dear @georgecambridge001 ,
I have tried building the search query, but unfortunately some of the properties you had been asking for wasn't available in Search API. This is the query I have created with limited filter criteria.
MnA = search.Definition(
view = search.Views.DEALS_MERGERS_AND_ACQUISITIONS,
filter = "TransactionStatus eq 'Completed' and TransactionAnnouncementDate ge 2003-01-01",
select = "TransactionAnnouncementDate, TargetCompanyName",
order_by = 'TransactionAnnouncementDate desc',
top = 10000).get_data()
MnA.data.dfPerhaps, it would be useful if you find these companies from Workspace using Mergers & Acquisitions screener App (it will pop up if you simply search in Workspace searchbar) and export as excel.
Then, you can use examples here to get the ESG data you are after. Additionally, you may find examples for the symbology conversion also useful as many of filtered companies might not have RICs.
Best regards,
Haykaz
0
Answers
-
Dear @georgecambridge001 ,
Thank you for your question. If I understand your question correctly you can achieve this via Refinitiv Data Library API in 2 steps:
1. Retrieve the RICs of M&A acquirers - This can be done via the Search function. In this Article, there is an example of Search request. Please have a look and let me know if you will have any difficulties in creating API request in RD. I can help you to build one.
2. Get ESG scores for the retrieved companies - I believe this example which again utilizes RD Library to get ESG data might be very handy.
Hope this was helpful and let me know should you have any further questions.
Best regards,
Haykaz
0 -
Hi @h.aramyan01 and @zoya faberov
I have been trying to build the code on my own but I could not make it. Can you please help me out to build one? Here is what I need:
Step 1:
- M&A transactions since 2003 January onwards
- Status flag = completed
- Divestiture flag = true, spinoff flag = false, carve-out flag = false
- Target's parent (immediate, ultimate, temporary) = public
- Exclude industries in the financial sector (for target parents)
- Whether divested unit and its parent were in the same industry (as measured by the SIC code)
Step 2:
- Obtain ESG scores (overall, pillar, and sub-components e.g., resource use score)
I thank you in advance for your support.
0 -
Hi @georgecambridge001 ,
Sure I can work on that, just please bear in mind it might take some time (Search requests involve some research). I'll post a code here, once ready.
Best regards,
Haykaz
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛