For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles


98 20 30 31

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:

Any help is appreciated :)

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

18.1k 21 13 21


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"])


ahs.png (54.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?

1569085804017.png (8.2 KiB)

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.

ahs.png (213.7 KiB)

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

1569288176638.png (66.7 KiB)
Show more comments