Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by marco-girardi · Mar 28, 2018 at 03:47 AM · eikoneikon-com-apiconstituents

Hi, how do I get the Stoxx 600 constituents list of any given date from Thomson Reuters for excel?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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Mar 28, 2018 at 04:33 AM

The formula is

=TR(".STOXX";"TR.IndexConstituentRIC;TR.IndexConstituentName;TR.IndexConstituentWeightPercent";"SDate=2016-06-01")

The python code:

import eikon as tr
tr.set_app_id('blah')
df, e = tr.get_data(['.STOXX'], 
                    ['TR.IndexConstituentRIC', 'TR.IndexConstituentName','TR.IndexConstituentWeightPercent'], 
                    {'SDate':'20160601'})


screen-shot-2018-03-28-at-113233.png (65.2 KiB)
Comment
marco-girardi
amine.lahraichi

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
Answer by marco-girardi · Mar 28, 2018 at 04:47 AM

Thank you, I put the formula in the excel sheet, however it returns me one single list of constituents. How can I retrieve the constituents for every month (or quarter) from a certain date? @Zhenya Kovalyov

Comment

People who like this

0 Show 1 · 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
Alex Putkov.1 ♦♦ · Mar 29, 2018 at 06:32 PM 0
Share

You either need to create a separate function for each date for which you'd like to retrieve the list of constituents. Or you can retrieve the list of joiners and leavers between two dates, e.g.
=TR(".STOXX","TR.IndexJLConstituentChangeDate;TR.IndexJLConstituentRIC.change;TR.IndexJLConstituentRIC;TR.IndexJLConstituentComName","SDate=2017-03-08 EDate=2018-03-08 IC=B CH=Fd RH=IN")

avatar image
Answer by marco-girardi · Mar 28, 2018 at 05:28 AM

What is more, somethimes the result is "NULL", am I making any mistake?

Comment

People who like this

0 Show 2 · 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
Alex Putkov.1 ♦♦ · Mar 29, 2018 at 06:33 PM 0
Share

Do you have an example you can share?

avatar image
REFINITIV
Nipat Kunvutipongsak ♦♦ · Apr 12, 2018 at 03:51 AM 0
Share

Can you share the example code as mentioned by @Alex Putkov to offer further insight into your question?

avatar image
Answer by amine.lahraichi · Apr 03, 2018 at 12:56 PM

Hello,

Do you have an example with Eikon .NET Api?

Also where can you find the documentation of the parameters field in the python get_data function?

Many thanks,

Comment

People who like this

0 Show 2 · 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
Alex Putkov.1 ♦♦ · Apr 03, 2018 at 02:50 PM 0
Share

All API documentation including tutorials and code samples can be found right here on this portal.
Here's the link to the page listing the APIs available with Eikon.
https://developers.thomsonreuters.com/eikon-apis-0/apis-in-this-family
If you're interested in streaming market data or timeseries of price history, click on the link to .NET APIs for use in custom applications. If you also need fundamental and reference data follow the link to COM APIs for use in custom applications (.NET APIs do not provide access to fundamental and reference data).

avatar image
REFINITIV
Alex Putkov.1 ♦♦ · Apr 03, 2018 at 02:52 PM 0
Share

And here's the link to the documentation page for Eikon Data APIs where you can find Eikon Data APIs for Python Reference Guide detailing the methods available through this API and their signatures including the parameters for get_data method.
https://developers.thomsonreuters.com/eikon-data-apis/docs

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 >
10 People are following this question.

Related Questions

Excel API: formula builder - retreive data from local server

RDATA batch request with individual Sdate parameters

DEX2 field-list documentaion

Error loading 'ThomsonReuters.Udap.BusTools.DLL' assembly.

RSearch : Extract more than 2000 bonds

  • 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