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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 2

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

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

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.

Upvotes
Accepted
3.8k 4 4 6

Hi @reshma.palackan

Here is an example how you can make it. The best approach to find the fields and necessary parameters is using Eikon Excel Build Formula tool.

df_tmp,err= ek.get_data("0#.STOXX50","TR.RIC")
instruments = df_tmp['RIC'].tolist()
df,err = ek.get_data(instruments,["TR.WasteTotal.date","TR.WasteTotal"],{"Period":"FY0", "Frq":"FY", "SDate":"0", "EDate":"-10"})
df
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.

Upvotes
9.7k 49 38 60
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.

Upvotes
3.8k 4 4 6

Hi @reshma.palackan

If you are looking for a historical constituents of an index you can also try with:

ek.get_data("0#.FTSE(2010-08-09)","TR.CommonName")
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.

Upvotes
1 1 1 2

It is not for historical constituents, but for historical data pertaining to say Total Waste, for the past ten years of each constituent of Stoxx50, say. I am only getting familiar with the syntax for retrieving data using get_data :)

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