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 :)
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
22.5k
●59 ●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.
14.4k
●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.
