Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 1 0 2

Python REST API - Processing Failed (Screener request)

Our API request was working yesterday however today it is failing and not returning any instruments. This appears to be the only request which is affected.

Here is the error we get back from Eikon

[{'code': 800, 'col': 1, 'message': 'SCREEN(IN(TR.ExchangeCountryCode,"IT","ES","BE","FR","DE","NL","CH","NO","SE","GB","CA","US","AU","NZ"),TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/>=1000000000,TR.NumberOfAnalysts(Period=FY1)>=2) processing failed.', 'row': 0}]

It shows the screening request as well. I can't find any help with error code 800 or with "processing failed"

What makes this very strange is we have another process that used the Eikon APIs for funds. Getting the data is working fine

ek.get_data(slice_isin_codes, request_fields, request_params)

This request which is a list of ISINs rather than the screener call has no issues.

The screener request (below) is returning processing failed, either code has changes in the last 48 hours and both were running correctly before.

ek.get_data(screener_exp, request_fields)

Any ideas or help?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

Upvotes
Accepted
4.6k 26 7 22

@creator remove the quotes around the country codes:

'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,IT, ES, BE, FR, DE, NL, CH, NO, SE, GB, CA, US, AU ,NZ), TR.CompanyMarketCap(SDate=0D)>=1000000000, TR.NumberOfAnalysts(Period=FY1)>=2, CURN=USD)'

this screener query yields ~6.5k instruments.

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.

Hello Zhenya, is there an online document for the query syntax? at the moment we are relying on excel plugin to build the query.

The Screener wizard in Excel is currently the only way to build a Screener expression.

Upvotes
5 1 0 2

Changed the line from:

screener_exp = """SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/),IN(TR.ExchangeCountryCode,"IT","ES","BE","FR","DE","NL","CH","NO","SE","GB","CA","US","AU","NZ"),TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/>=1000000000,TR.NumberOfAnalysts(Period=FY1)>=2)"""
to:

screener_exp = """SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,IT, ES, BE, FR, DE, NL, CH, NO, SE, GB, CA, US, AU ,NZ), TR.CompanyMarketCap(SDate=0D)>=1000000000, TR.NumberOfAnalysts(Period=FY1)>=2, CURN=USD)"""
And the process is now successfully running.

I'll need to double check the whole process completed but the process is now downloading data whereas it wasn't before.

This wasn't an issue for us before, what has changed?

The CURN USD is new but that hasn't impacted the total number of stocks returned (as USD is the default anyway for us.)

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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