How can I get historical data for the constituents of an index on Python?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
How can I get historical data for the constituents of an index on Python?
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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
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")
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 :)