I'm trying to use the Eikon API (ideally) to get a list of all of the Exchange RICs for a particular country (say, all Exchange RICs for the United States). I've looked at the answer posted here. However, that doesn't really answer my question as I'm not interested in the constituents of the Exchanges, but instead am looking for:
1. Just the exchange-level index RICs for each exchange in operation in the country (ideally also historically-active exchanges that are no longer active)
2. A way to do this using the Eikon API for Python (or alternatively DSWS)
Would you have any suggestions for points 1 and 2 above please?
Thank you very much in advance!
@AAMZ Apologies if there is any confusion on my part but a colleague said you might be looking for all indices in a country as opposed to all exchanges. In this case things are as simple using the RDP Search API IndexInstruments view:
data =rdp.search( view=rdp.SearchViews.IndexInstruments, filter = "RCSIndexCountryGroupLeaf eq 'United States'", top = 10000, select ="DocumentTitle, RIC, LongName") display(data)
I hope this can help.
@AAMZ You can use the RDP Search API which you have access to with Eikon. The search returns are limited to a maximum of 10,000. See the code below:
import refinitiv.dataplatform as rdp rdp.open_desktop_session('Your App Key Here') data =rdp.search( view = rdp.SearchViews.EquityQuotes, filter = "RCSExchangeCountryLeaf eq 'United States'", top = 10000, select = "ExchangeCode", group_by = "ExchangeCode", group_count = 1 ) display(data)
. I hope this can help.