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

Find more posts tagged with

historical

index

constituents

Accepted answers

Gurpreet

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.

All comments

raksina.samasiri

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.

Gurpreet

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.

EXPLORE OUR SITES