Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Refinitiv Data Platform /
avatar image
Question by nipat.puangjampa · Feb 01 at 09:26 PM · refinitiv-data-platformesg

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




1643750970035.png (55.2 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Jirapongse · Feb 02 at 05:46 AM

@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)
Comment
raksina.samasiri
nipat.puangjampa

People who like this

2 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by raksina.samasiri · Feb 02 at 05:55 AM

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)
Comment
nipat.puangjampa

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

ESG API : maximum number of instruments, duplicated headers and process for adding new fields

how do I request ESG data from java

mapping from RIC to PermID.

How to create clientID (APIKey) for Refinitiv Data Platform

Download ESG Bulk data from CFS

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • FX Venues
    • FX Trading – RFQ Maker
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • Yield Book Analytics
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges