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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
98 10 21 27

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
18k 21 12 20

Hi

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 (54.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.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): 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 :)

1569288176638.png (66.7 KiB)
Show more comments
Click below to post an Idea Post Idea