How can I find the component of indexes like the S&P 500 or the Sub Index and access them in Python through the jupyter notebook?
How can I write a define a screener and have the results returned in a jupyter notebook?
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●0 ●1
component of indexes like the S&P 500 or the Sub Index
6.7k
●8 ●6 ●7
Hi @nikolas - Thank for your question. Refinitiv maintains a number of chain RICs which provide the constituents of many indices as well as options and futures chains. Please use the following code to get the constituents of the SPX.
df,err = ek.get_data(['0#.SPX'], ['CF_NAME']) df
To find the chain RICs for subsectors you can just add a 0# infront of say .SPLRCTELP which is the Integrated Telecommunications Services sub index.
I hope this can help.
1
●0 ●0 ●1
Thanks for that. What if you want to add market cap or some other values available in a screener?
@nikolas just add the fields in as you want - you can see a full list of fields available using the Data Item Browser App (type DIB into Eikon search bar):
df,err = ek.get_data(['0#.SPLRCTELP'], ['CF_NAME','TR.CompanyMarketCap']) df
