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!

Best Answer

  • Hi @nlieb7

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

    Please follow this step:

    image


    image


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