How do I get the list of the S&P500 constituents on any given date?

Question

question

Pilboud

35 ●1 ●1 ●4

How do I get the list of the S&P500 constituents on any given date?

I can get the current list of the S&P constituents using this: ek.get_data('0#.SPX',['TR.CommonName', 'TR.InstrumentIsActive', 'TR.CompanyMarketCap', 'TR.PriceClose']).

But I would like to be able to get the list on any given date that I would pass on to the code. Is there any way to do this? Thank you.

eikon eikon-data-api python refinitiv-dataplatform-eikon workspace workspace-data-api date

Jul 20, 2017 at 07:05 AM

10 |1500

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

Answer 1 · 2017-07-20T08:42:21Z

Zhenya Kovalyov

4.6k ●26 ●7 ●22

There is, but the depth of historical data depends on the index provider. Try this for the snapshot of the constituents for January 1st, 2016:

tr.get_data(instruments=".SPX", fields=["TR.IndexConstituentRIC","TR.IndexConstituentName"], parameters={'SDate':'2016-01-01'})

Jul 20, 2017 at 08:42 AM

10 |1500

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

Pilboud Jul 20, 2017 at 08:49 AM

This works for me, thank you very much.

iteam Jul 20, 2017 at 10:36 AM

I tired this, but It seams that it does not return data before 2014. Is this data not avaalible?

Pilboud iteam Jul 20, 2017 at 11:51 AM

The available data depend on the index that provides it

Zhenya Kovalyov iteam Jul 20, 2017 at 11:51 AM

I would suggest calling Thomson Reuters Support Desk with this, they would be able to provide you more asset specific information.

Answer 2 · 2017-07-20T14:59:28Z

Alex Putkov.1

39.4k ●77 ●11 ●27

Here's another method that I find to produce much better results:
tr.get_data("0#.SPX(2012-01-01)", ["TR.CompanyName"])

Jul 20, 2017 at 02:59 PM

10 |1500

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

Pilboud Jul 21, 2017 at 04:13 AM

Thanks. And yes, that's an easier method. Also if you want to get the close price (I am sure it works for other fields but i have not tried) for that specific date you can do:

tr.get_data("0#.SPX(2017-07-01)", ["TR.CompanyName","TR.PriceClose(2017-07-01)"])

Tulkkas Oct 11, 2019 at 11:05 AM

Why does this does not return any RIC if supplied with 'TR.IndexConstituentRIC' ?

Alex Putkov.1 Tulkkas Oct 11, 2019 at 01:15 PM

Two reasons.

Incorrect syntax.
To retrieve index constituents using TR.IndexConstituentRIC field you need to use index RIC not the chain RIC, i.e. ".SPX" instead of "0#.SPX", and the date needs to be passed in the parameters of get_data method rather than in the instrument.
Index constituent history available through TR.IndexConstituentRIC field only goes back to 2016.

See the discussion on this thread for more details and alternative ways to retrieve historical index constitutes.

cqlc94 Alex Putkov.1 Jul 09, 2020 at 10:10 AM

Hi there, where could I find the depth information about apis or fields such your said "TR.IndexConstituentRIC field only goes back to 2016"? Thanks

Q&A Forum

question

How do I get the list of the S&P500 constituents on any given date?

2 Answers

Write an Answer

question

How do I get the list of the S&P500 constituents on any given date?

2 Answers

Write an Answer

Related Questions