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

question

Upvotes
Accepted
98 26 32 35

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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