How to retrieve old constituents from a index (TRXFLDUSP)?

Hi, I am trying to retrieve the constituents of the index TRXFLDUSP via API calls. It works, but the data is returned for dates after 2009-08-03.

I thought that maybe the index did not exist before 2009-08-03, however, in Reuters terminal it is possible to see historical data for the index since 2000-10-27.

Does any one know how to retrieve the index constituents for this older period (from 2000-oct through now)?

Find more posts tagged with

python

eikon

symbology

rics

index

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jason.ramchandani01

@fidel.esteves thanks for your question - I can indeed replicate the behaviour. Usually you can get historical constituents for a specific date using the following:

df, err = ek.get_data('0#.TRXFLDUSP(20150310)',['TR.RIC'])
df

However if i try the same with a date before your last date I get a nan return:

This indicates that we may not carry this data. As this is a content question I suggest you open a content ticket in Eikon (helios menu --> contact us) referencing this thread and they can confirm that - if so, you can also make a request for this content to be added.

I hope this can help.

All comments

jason.ramchandani01

@fidel.esteves thanks for your question - I can indeed replicate the behaviour. Usually you can get historical constituents for a specific date using the following:

df, err = ek.get_data('0#.TRXFLDUSP(20150310)',['TR.RIC'])
df

However if i try the same with a date before your last date I get a nan return:

I hope this can help.

EXPLORE OUR SITES