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 Data APIs /
avatar image
Question by Pilboud · Jul 20, 2017 at 07:05 AM · date

How do I get the list of the S&P500 constituents on any given date?

I can get the current list of the S&P constituents using this: ek.get_data('0#.SPX',['TR.CommonName', 'TR.InstrumentIsActive', 'TR.CompanyMarketCap', 'TR.PriceClose']).

But I would like to be able to get the list on any given date that I would pass on to the code. Is there any way to do this? Thank you.

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 Zhenya Kovalyov · Jul 20, 2017 at 08:42 AM

There is, but the depth of historical data depends on the index provider. Try this for the snapshot of the constituents for January 1st, 2016:

tr.get_data(instruments=".SPX", fields=["TR.IndexConstituentRIC","TR.IndexConstituentName"], parameters={'SDate':'2016-01-01'})
Comment
Pilboud

People who like this

1 Show 4 · 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
Pilboud · Jul 20, 2017 at 08:49 AM 1
Share

This works for me, thank you very much.

avatar image
iteam · Jul 20, 2017 at 10:36 AM 0
Share

I tired this, but It seams that it does not return data before 2014. Is this data not avaalible?

avatar image
Pilboud iteam · Jul 20, 2017 at 11:51 AM 0
Share

The available data depend on the index that provides it

avatar image
REFINITIV
Zhenya Kovalyov ♦♦ iteam · Jul 20, 2017 at 11:51 AM 0
Share

I would suggest calling Thomson Reuters Support Desk with this, they would be able to provide you more asset specific information.

avatar image
REFINITIV
Answer by Alex Putkov. · Jul 20, 2017 at 02:59 PM

Here's another method that I find to produce much better results:
tr.get_data("0#.SPX(2012-01-01)", ["TR.CompanyName"])

Comment
Joris.Hoendervangers
Pilboud
jirapongse.phuriphanvichai
cqlc94

People who like this

4 Show 4 · 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
Pilboud · Jul 21, 2017 at 04:13 AM 1
Share

Thanks. And yes, that's an easier method. Also if you want to get the close price (I am sure it works for other fields but i have not tried) for that specific date you can do:

tr.get_data("0#.SPX(2017-07-01)", ["TR.CompanyName","TR.PriceClose(2017-07-01)"])

avatar image
Tulkkas · Oct 11, 2019 at 11:05 AM 0
Share

Why does this does not return any RIC if supplied with 'TR.IndexConstituentRIC' ?

avatar image
REFINITIV
Alex Putkov. ♦♦ Tulkkas · Oct 11, 2019 at 01:15 PM 0
Share

Two reasons.

  1. Incorrect syntax.
    To retrieve index constituents using TR.IndexConstituentRIC field you need to use index RIC not the chain RIC, i.e. ".SPX" instead of "0#.SPX", and the date needs to be passed in the parameters of get_data method rather than in the instrument.
  2. Index constituent history available through TR.IndexConstituentRIC field only goes back to 2016.

See the discussion on this thread for more details and alternative ways to retrieve historical index constitutes.

avatar image
cqlc94 Alex Putkov. ♦♦ · Jul 09, 2020 at 10:10 AM 0
Share

Hi there, where could I find the depth information about apis or fields such your said "TR.IndexConstituentRIC field only goes back to 2016"? Thanks

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

Related Questions

ek.get_data - TR.PriceClose.date not working

Does not return calc dates when more than one ric in request get_data

How do I fetch the date in the coupon history?

What is the best value to use for the date/time when a value has been updated/changed? ACTIV_DATE? Using the Get_Data Function

Dynamic trailing one year request

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges