question

Upvotes
Accepted
nipat.puangjampa avatar image
3 ●1 ●1 ●4

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.


1643750970035.png




refinitiv-data-platformesg
1643750970035.png (55.2 KiB)
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.

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.8k ●250 ●52 ●74

@nipat.puangjampa

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

I tested with the following formula.

=@TR("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:

1643780655897.png

  • 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.


1643780655897.png (31.6 KiB)
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.

Upvote
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

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

1643781242381.png

1643781294278.png

Hope this could help.


1643781242381.png (19.6 KiB)
1643781294278.png (24.0 KiB)
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.

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.