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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

How do we correct this syntax?

SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'), 'TR.CompanyMarketCap(Scale=9)',>=10).currency('USD').query

SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'), BETWEEN('TR.CompanyMarketCap(Scale=9)', 5, 10)).currency('USD').query

pythonjupyter-notebook
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
4.3k 6 5 8

hi @cheryl.eje

Can you try the syntax below

SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'), 'TR.CompanyMarketCap(Scale=9)','>=10').currency('USD').query

and

SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'), ('TR.CompanyMarketCap(Scale=9)', '>=5'), ('TR.CompanyMarketCap(Scale=9)', '<=10')).currency('USD').query
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.