Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by fbontadini · Oct 20, 2021 at 11:04 AM · esgtimeseriesdatastream-for-office

ESG scores for all US companies with the excel plug in

Hi all,

I am a super beginner with Datastream and I was wondering if any of you could help me. I'd like to retrieve all ESG scores for all available US companies for the period 2007 onwards using the excel plug in. I have zero experience with Datastream so if you can't provide a strightforward answer it would be great if you could point me towards any relevant resources.

thanks!

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Jirapongse · Oct 21, 2021 at 04:21 AM

@fbontadini

You should have the Datastream menu in Excel.

1634789690081.png

Then, select the Time Series Request to get time series data.

Use Find Series and Datatypes to search for instruments and data types.

For example, the following formula is used to get CGSCORE (Governance Pillar Score) of instruments in the S&P 500.

=@DSGRID("LS&PCOMP","CGSCORE","-2Y","-0D","D","RowHeader=true;TimeSeriesList=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

1634789908216.png

Otherwise, you can use the Static Request to get static data.

For more information, you can contact the Datastream support team directly via MyRefinitiv.


1634789690081.png (39.1 KiB)
1634789908216.png (45.6 KiB)
Comment

People who like this

0 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 · Oct 20, 2021 at 11:42 AM

hi @fbontadini ,

I assume that you have an Eikon account, which is required to use the Excel plug-in. If so, you can use Screener app to search for the company you are interested in.

  • please check this article about how to do so Find Your Right Companies with SCREENER
  • You may also find these Screener training videos useful.

Or you can access Screener app in an Excel plug-in

1634729936659.png

For example, applying these filters1634730138770.png

I'm getting the Excel formula below

=@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.TRESGScore(Period=FY0)>0, IN(TR.HQCountryCode,""US""), CURN=USD)","TR.CommonName;TR.TRESGScore(Period=FY0);TR.HeadquartersCountry","curn=USD RH=In CH=Fd")


Hope this could help, please tell me in case you have any further question


1634729936659.png (29.0 KiB)
1634730138770.png (141.1 KiB)
Comment

People who like this

0 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
Answer by fbontadini · Oct 20, 2021 at 11:51 AM

Hi,

thanks for the quick reply. To be perfectly honest I am not sure I have an eikon account. My institution has purchased a licence for Datastream and I have received an email through which I set up my "Refinitiv Workspace". I have also received instructions on how to install the excel plug in, so I assume we have a lince for that as well. On the whole, this has been a rather confusing process so far, so forgive me if this is a trivial question but what is the difference between Eikon, Datastream and the Refinitiv Workspace?

I have tried copying and pasting the formula you kindly provided but still get an error, though this is probably me missing some crucial pieces to this puzzle!

thanks again!

Comment

People who like this

0 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

Retrieving data in Datastream Excel-plugin for all European companies with continuous availability of ESG score for the last 15 years

How to extract ESG Pillar Scores time series with TR function?

Where can I get the ISIN numbers from all stocks which have an ESG rating?

How do I get a ESG Score via DatatStreamDSWS ?

gRTCOMInterface.ProcessRequestTable hangs up

  • 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
  • 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
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges