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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 1

Is it possible to search for all Equities listed on a particular exchange using the Eikon.get_data() function?

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
13k 32 12 18

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.


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.

Click below to post an Idea Post Idea