How to get historical constituents

eikon1111
eikon1111
in Eikon Data APIs

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 :)

Tagged:

Best Answer

  • Gurpreet
    Gurpreet
    Answer ✓

    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.

Answers

  • raksina.samasiri
    raksina.samasiri admin

    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.

Categories