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!