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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
7 4 2 4

Using web scripting API (python), output data is incomplete

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")

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apiricsweb
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

Upvote
Accepted
39.3k 77 11 27

I'm afraid I'm not reproducing this. I just tried executing your request and I got 416 RICs as expected. The same number as returned by =TR function in Excel. It seems to me that the issue you reported earlier on a separate thread has been fixed. Can you try again?

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.

Hi Alex. Thanks. I agree, it is working for me as well. Not clear why it stopped though. was not working 4 to 7 Dec