For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Tulkkas avatar image
37 ●3 ●3 ●10

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...

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonhistoricalindex
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

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)
icon clock
10 |1500

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

Click below to post an Idea Post Idea