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?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

@GI 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.

All comments

Zhenya Kovalyov

@GI 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.

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

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.

EXPLORE OUR SITES