How can I use Build Formula in excel to collect panel data on ESG?

Hi,

I would like to get a panel data on ESG (many firms across years). I am now trying to use the Build formula of Refinitiv in excel to get a panel data on ESG. My identifiers are CIK and CUSIP from compustat. I want to get ESG data, e.g., workforce score, from 2002 to 2020 for each (firm) identifier.

The data I got is shown below.

First of all, why are there a lot of NULL's even in Columns CIK Number, CUSIP, Fiscal Year End Date?

Second, how should I set the parameters? I ticked series and chose last 20 FY. Please advise.

Find more posts tagged with

esg

refinitiv-data-platform

Accepted answers

Jirapongse

@nipat.puangjampa

I assume that you are using Eikon Excel to retrieve the ESG data.

I tested with the following formula.

=@TR(&quot;0000001750;0000910627;0000061478","TR.CUSIP;TR.RIC;TR.CommonName;TR.TRESGWorkforceScoreGrade.Date;TR.TRESGWorkforceScoreGrade","SDate=0 EDate=-19 CH=Fd RH=IN",B2)

The output is:

0000001750 is AAR Corp (AIR.N). The TR.TRESGWorkforceScoreGrade data is available from 2016 to 2021.
0000910627 is ACF Industries Holding LLC. There is no TR.TRESGWorkforceScoreGrade data
0000061478 is CommScope Connectivity LLC (ADCT.OQ^L10). It is a delisted RIC. The TR.TRESGWorkforceScoreGrade data is available from 2002 to 2009.

To confirm the availability of the ESG data of those instruments, please contact the Eikon Excel support team directly via MyRefinitiv.

All comments

Jirapongse

@nipat.puangjampa

I assume that you are using Eikon Excel to retrieve the ESG data.

I tested with the following formula.

=@TR(&quot;0000001750;0000910627;0000061478","TR.CUSIP;TR.RIC;TR.CommonName;TR.TRESGWorkforceScoreGrade.Date;TR.TRESGWorkforceScoreGrade","SDate=0 EDate=-19 CH=Fd RH=IN",B2)

The output is:

0000001750 is AAR Corp (AIR.N). The TR.TRESGWorkforceScoreGrade data is available from 2016 to 2021.
0000910627 is ACF Industries Holding LLC. There is no TR.TRESGWorkforceScoreGrade data
0000061478 is CommScope Connectivity LLC (ADCT.OQ^L10). It is a delisted RIC. The TR.TRESGWorkforceScoreGrade data is available from 2002 to 2009.

To confirm the availability of the ESG data of those instruments, please contact the Eikon Excel support team directly via MyRefinitiv.

raksina.samasiri

hi @nipat.puangjampa

This forum is more for programming-type queries, rather than content queries. I would recommend you to contact the Eikon support team directly via MyRefinitiv. You can provide the input and the current formula you are using and ask them about the NULL value or just ask for the Excel formula of the data you would like to get.

However, to select the parameter with start-end date, you may select 'Start-End' in the dropdonwn after the 'Series' is ticked, from here you can choose 'Select Date' in From and To field as screenshots below

Hope this could help.

EXPLORE OUR SITES