question

Upvotes
Accepted
1 1 1 1

How to get historical constituents

Hello,

I started working with Refinitiv Eikon (mostly the Excel Ad On). Is there a way to get all constiutents from a time period as of say 2020 until 2022?


Thanks in advance :)

historicalindexconstituents
icon clock
10 |1500

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

Upvotes
Accepted
24.8k 64 15 21

Constituents of what?

For an index you can use the following python call:

# get S&P500 constituents in January 2020
ek.get_data('0#.SPX(2020-01-01)', fields=['TR.TRESGScore'], parameters={'SDate': '2020-01-01', 'Period': 'FY0'})


For help with excel plugin, its best to contact Refinitiv Helpdesk as mentioned by Raksina.

icon clock
10 |1500

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

Upvotes
15.5k 32 5 10

hi @eikon1111 ,

Thanks for your question. However, your question is about Eikon Excel rather than Eikon Data API

this is a more detailed content question and is best checked with the appropriate content team by raising a ticket on Refinitiv Helpdesk Online -> Product -> Eikon marking it a Content Query. Be sure to put all the RICs you want the earliest dates for and they will be able to check those for you. I hope this helps.

icon clock
10 |1500

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.