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

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.

@eikon1111

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


Upvotes
Accepted
22k 58 14 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
14.2k 30 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.