question

Upvotes
Accepted
benedikt.von_boehmer avatar image
3 ●0 ●0 ●2

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

refinitiv-dataplatform-eikonrdp-api#productesgpoint-in-time
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri avatar image   raksina.samasiri
Hi @benedikt.von_boehmer ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text on the left side of the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

2 Answers

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @benedikt.von_boehmer,

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
benedikt.von_boehmer avatar image
3 ●0 ●0 ●2

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

annalenadigeronimo avatar image annalenadigeronimo

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!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.