Eikon Web Scripting API (Python) code:
df, err = ek.get_data(['SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,''ZA'')),CFRJ.J'], ['TR.PrimaryRIC']).
Does not pull PrimaryRIC for every ticker in screen. Majority are missed out. I am expecting 416 primary RICs, but only getting roughly 190. It is consistent in the Primary RICs that are not populated. What is happening?
I do not want use to pull TR.PrimaryRICCode or TR.PrimaryQuote. I specifically have to pull data for TR.PrimaryRIC.
Using equivalent query in Excel API yields all 416 Primary RICS which means the data is available.
=TR("SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,""ZA"")),CFRJ.J","TR.PrimaryRIC")