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

Question

Question by Johann Lourens · Dec 07, 2017 at 12:00 AM · python api primary ric web api

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

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2017-12-07T19:08:41Z

REFINITIV

Best Answer

Answer by Alex Putkov. · Dec 07, 2017 at 07:08 PM

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?

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Johann Lourens · Dec 10, 2017 at 10:48 PM 0

Share

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

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

1 Reply

Watch this question

Related Questions