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 Tulkkas · Jul 02, 2020 at 06:49 AM · eikon apihistorical dataindex constituents

Issue retreiving RICs for the SPI index

I am trying to retrieve the RICs for the SPI index using the following code:

index_id    = '0#.SPIX(2020-06-30)'
data, err   = ek.get_data(index_id,['TR.RIC']) 

This returns me nan. When I try without the date in the request as follow, it works:

index_id    = '0#.SPIX'
data, err   = ek.get_data(index_id,['TR.RIC']) 

Is that because it is not possible to get historical constituents or is this because of another reason?

How then could I get historical constituents for this index? Knowing that this works for others such as .SPX, .STOXX etc...

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani · Jul 02, 2020 at 07:18 AM

Hi @Tulkkas - thanks for your question. You are right that we do not carry historical constituents for that index but we do carry it for the SPI (0#.SSHI) which appears to have the same underlying constituents.

index_id    = '0#.SSHI(2020-06-30)'
data, err   = ek.get_data(index_id,['TR.RIC']) 
data.sort_values('RIC')

index_id    = '0#.SPIX'
data, err   = ek.get_data(index_id,['TR.RIC']) 
data.sort_values('RIC')

I hope this can help you.


1593674162347.png (61.4 KiB)
1593674270478.png (59.4 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.

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

Related Questions

get_data() function : headers random bug

AF.N^I17 giving Invalid RIC for get_timeseries, works on get_data

Need VWAP historically in Eikon API. Cannot translate Excel Rhistory to Python get_timeseries().

How can I get historical data for the constituents of an index on Python?

Does get_timeseries provides adjusted close prices (splits and dividends) when using corax="adjusted" ?

  • 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