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

nipat.puangjampa
nipat.puangjampa Newcomer
in Refinitiv Data Platform

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




Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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

Answers

  • raksina.samasiri
    raksina.samasiri admin

    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.

Categories