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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 3

Eikon Data API Query With Range Restrictions

I want to be able to refine my query to Japanese companies with market caps greater than $150M. What is the proper format to do that?


For example, I want the query to do this:

ek.get_data('SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.HeadquartersCountry,"Japan"),(TR.CompanyMarketCap(Curn=USD)>150,000,000))

But I don't know if it is possible or what the right format is.


Thanks!

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonquery-string
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

Upvotes
Accepted
18.1k 21 12 20

Hi @nlieb7

You can use the "SCREENER" app to define the query.

Please follow this step:



On the SCREENER app, you can press F1 to see the help screen too.


ahs.png (325.6 KiB)
ahs1.png (138.0 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.