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
nlieb7 avatar image
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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiquery-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

· Write an Answer
Upvotes
Accepted
chavalit avatar image
18.2k ●21 ●13 ●21

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.

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.