Python REST API - Processing Failed (Screener request)

GI
GI
in Eikon Data APIs

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?

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov
    Answer ✓

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

Answers

  • GI
    GI

    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
    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
    Alex Putkov.1

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

Categories