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