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

Find more posts tagged with

python

jupyter-notebook

Accepted answers

raksina.samasiri

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

All comments

raksina.samasiri

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

EXPLORE OUR SITES