Getting companies listed under a Exchange using Eikon.

I would like to request companies listed under the exchange MA (MADRID STOCK EXCHANGE - FLOOR) using Eikon.

I'm getting the list of Exchange RIC extensions from here: https://customers.reuters.com/a/productsupport/Datascope/GCODES/price_src_cds.html

Any help is appreciated

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

I think you refer to "BOLSA DE MADRID" exchange ?

If so, please try this code:

df,e = ek.get_data("SCREEN(U(IN(Equity(active,public,primary))),IN(TR.ExchangeMarketIdCode,""XMAD""))",["TR.CommonName;TR.ExchangeName"])

df

ahs.png

All comments

chavalit-jintamalit

I think you refer to "BOLSA DE MADRID" exchange ?

If so, please try this code:

df,e = ek.get_data("SCREEN(U(IN(Equity(active,public,primary))),IN(TR.ExchangeMarketIdCode,""XMAD""))",["TR.CommonName;TR.ExchangeName"])

df

ahs.png

aquilesjlp300

Not exactly, check this screenshot please (taken from this site: )

Basically looking for companies that have the ".MA" suffix as the RIC exchange. The ones you're showing are for ".MC"

Is it possible?

chavalit-jintamalit

Hi @aquilesjlp300

The SCREENER app in Eikon Desktop does not have any other exchange with "MADRID" in its name.

I think the list you are referring to is not an Exchange suffix at all.

aquilesjlp300

chavalit.jintamalit ♦♦ thanks for your reply. I get your point because I don't get anything there either, but there's something bugging me about the Link I posted at the beginning of the question, which leads me to believe that perhaps the information in this website is not up to date anymore (perhaps): https://customers.reuters.com/a/productsupport/Datascope/GCODES/price_src_cds.html why does the exchange appears in there but not on the SCREENER app? Also, checking old forum posts, I found this older question in which I can see a link leading to an Excel file that maps MICs and RIC exchanges, and the RIC exchange I'm looking for also appears (check screenshot please). Are these tables up to date? Should I trust them? How can I resolve this discrepancy? Is there something I'm reading wrong perhaps? Any help you might have will be appreciated

EXPLORE OUR SITES