I have screen that works in Excel API, but not in Web scripting API (Python). What do I need to change? "SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,""ZA"")),CFRJ.J"
You need to request at least one field (ex: TR.PriceClose).
Following code is running well:
>>> ek.get_data("SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,'ZA')),CFRJ.J","TR.PriceClose")( Instrument Price Close0 CCOJ.J 4737.01 RACPp.J 2150.02 LHCJ.J 2562.03 RSGJ.J 188.0.. ... ...409 NFTRCIJ.J 2286.0410 NFGOVIJ.J 5540.0411 PREFTXJ.J 844.0412 CFRJ.J 12115.0[413 rows x 2 columns], None)
@Johann-Lourens, a workaround if you just want to retrieve RIC list, you can also request a not existing field (much faster to execute):
>>> data,err=ek.get_data("SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,'ZA')),CFRJ.J","Instrument")>>> data Instrument INSTRUMENT0 CCOJ.J NaN1 RACPp.J NaN2 LHCJ.J NaN3 RSGJ.J NaN.. ... ...409 NFTRCIJ.J NaN410 NFGOVIJ.J NaN411 PREFTXJ.J NaN412 CFRJ.J NaN[413 rows x 2 columns]
