Upgrade from Eikon -> Workspace. Learn about programming differences.

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

# question

Upvotes
Accepted
1 2 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?

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

### 4 Answers

· Write an Answer
Upvotes
Accepted
3.8k 4 4 6

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

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

Upvotes
18.6k 85 39 63

Please see this question.

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

Upvotes
3.8k 4 4 6

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")`

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

Upvotes
1 2 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 :)

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

### Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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