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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
GI avatar image
5 ●0 ●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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

2 Answers

Upvotes
Accepted
Zhenya Kovalyov avatar image
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 5.0 MiB each and 10.0 MiB total.

raptorsun avatar image raptorsun

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

Alex Putkov.1 avatar image Alex Putkov.1 raptorsun

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

Upvotes
GI avatar image
5 ●0 ●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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea