How do we correct this syntax?

cheryl.eje
cheryl.eje
in Eikon Data APIs

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

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    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

Categories