ESG Scores and Pillar Scores for M&A Target and Acquierer
HI,
I am using the Eikon API in Python. I am trying to get the ESG scores of the target companies at the day of the deal announcement and the acquirer scores on the deal announcement as well as 6 months after the deal is closed.
I have the following code that partially works (I am not getting the exact date as per the M&A announcement) How can I get this?
Also, it seems odd to me that doing this for Target and Acquirer, I only get a dataset of around 150 deals, shouldn't there be more?
Thanks in advance
#split dataset in two as otherwise too large for request
MA1 = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), TR.MnAPctHeldAtAnnDate<50, TR.MnAPctOfSharesOwnedPostMerger>=50, IN(TR.MnAStatus,""U"",""C""), BETWEEN(TR.MnAAnnDate,20100101,20141231)/*dt:Date*/, IN(TR.MnAPubStatus,""V"",""P""), NOT_IN(TR.MnAMacroIndustry(DealPartRole=T:A),'GOVAGY'), TR.MnAIsForFinancialPurpose==false, TR.MnAIsSelfTender==false, CURN=USD)",
["TR.MnASDCDealNumber;TR.MnAAnnDate;TR.MnARankDate;TR.MnATarget;TR.MnATargetPermId;TR.MnATargetMacroInd;TR.MnATargetMidInd;TR.MnATargetNation;TR.MnAAcquiror;TR.MnAAcquirorPermId;TR.MnAAcquirorMacroInd;TR.MnAAcquirorMidInd;TR.MnAAcquirorNation;TR.MnATargetFinAdvisor(Concat='|');TR.MNADealId;TR.MnATargetRegionAndSubRegion(Concat='|')"])
#Check for ESG score of Target company at deal announcement (MA1)
Companies = [str(i) for i in MA1[0]["Target PermID"]]
Fields = ['TR.RIC',
'TR.CommonName',
'TR.HeadquartersCountry',
'TR.TRBCEconomicSector',
'TR.TRESGScore',
'TR.TRESGScore.date',
'TR.TRESGCScoreGrade',
'TR.TRESGCScoreGrade.date',
'TR.EnvironmentPillarScore',
'TR.EnvironmentPillarScore.date',
'TR.AnalyticEnvControv',
'TR.AnalyticEnvControv.date',
'TR.EnvMaterialsSourcing',
'TR.EnvMaterialsSourcing.date',
'TR.SocialPillarScore',
'TR.SocialPillarScore.date',
'TR.GovernancePillarScore',
'TR.GovernancePillarScore.date',
'TR.MnATotalDealValue',
'TR.MnATotalDealValue.date',
'TR.MnAConsiderationPercent',
'TR.MnAConsiderationPercent.date',
'TR.MnAConsiderationStructure',
'TR.MnAConsiderationStructure.date',
'TR.MnAStatus',
'TR.MnAStatus.date',
'TR.MnAAnnDate']
targetesg1, err = ek.get_data(instruments = Companies,
fields = Fields,
parameters = {'SDate' : "0",
'EDate' : "0",
'Period' : 'FY0',
'Frq' : 'FY'})
targetesg1.dropna(subset=['ESG Score'], inplace=True)
targetesg1
Best Answer
-
1. With regards to getting exact dates as per the M&A announcement: I wrote an article related to this subject called 'Investigating the effect of Company Announcements on their Share Price following COVID-19 '; let me know if t helps. Otherwise, may I ask you if you looked for the relevent fields you are after in the DIB or using Search? (N.B.: Search uses the RD library which you have access to, but you may have to install it on your kernel.)
2. When it comes to the number of answers for your requests using EDAPI, I am thinking that you may reach the single-call limit... You can find details on this here (which I found here). Do let me know if this is not enough to explain the lack of data retrieved in your use case.
0
Answers
-
Hi @jonathan.legrand ,
Thank you for the reply, it was very helpful. One remark for others facing a similar problem. The filter TR.MnAPctHeldAtAnnDate<50 seems to be removing most of the deals of interest as they have no value (N/A) in Refinitv instead of 0. Therefore, the filter also removes those. Should you want to apply the filter you can use it after downloading the dataset.
0 -
Hi, I also want to pull M&A deal data and consider the criterion that the acquirer holds less than 50% shares of the target before the deal announcement and more than 50% shares of the target after the deal. What is the filter in Eikon that can be applied to consider this criterion, or what is the variable that needs to be added to the dataset to filter on this criterion later? I couldn't find it. Thank you for your help!
0 -
Hi @annalenadigeronimo, To find the right screener string to use in your call, please use the SCREENER app, as per the article:
Find Your Right Companies with SCREENER | Eikon Data APIs (Python) | Devportal (lseg.com)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 中文论坛