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
1
●2 ●1 ●1
Is it possible to search for all Equities listed on a particular exchange using the Eikon.get_data() function?
Hello @Excel Benedict.Cruz,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
22k
●59 ●14 ●21
Hi @Excel Benedict.Cruz, you can use a screener to form the basis of your query to get all the instruments. See Excel Screener for help on screener filters.
For e.g. to get all the instruments listed on NYSE:
>>> df, err = ek.get_data(instruments = "SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeMarketIdCode,""XNYS""), CURN=USD)", fields = ['TR.CommonName', 'TR.ExchangeName']) >>> df.head() Instrument Company Common Name Exchange Name 0 FN.N Fabrinet NEW YORK STOCK EXCHANGE, INC. 1 GCAP.N GAIN Capital Holdings Inc NEW YORK STOCK EXCHANGE, INC. 2 HPP.N Hudson Pacific Properties Inc NEW YORK STOCK EXCHANGE, INC. 3 OAS.N Oasis Petroleum Inc NEW YORK STOCK EXCHANGE, INC. 4 ENV.N Envestnet Inc NEW YORK STOCK EXCHANGE, INC.
