Back-end errors in get_data and SCREEN

LRE42
LRE42 Newcomer

Hello - I have a script that I've used for over a year without many problems, but lately I am getting a lot of "400 Bad Requested universes". You can see below I am screening for companies. When I put this screener syntax in Excel's TR function, I am able to download companies fine. However, I need this Python workflow to work because there's a lot of subsequent steps built on top of this initial screening step. Maybe the problem is that I recently upgraded from Python 3.11.7 to 3.12.7?

import lseg.data as ld
import pandas as pd

import lseg.data as ldimport pandas as pd
syntax_loop = [    "SCREEN(U(IN(Equity(active or inactive,public ,primary))), CURN=USD, TR.F.TotRevenue(Period=FY0)>0 , IN(TR.HQCountryCode,AT,BE,DK,FO,FI,FR,DE,GI,GL,GG,IS,IE,IM,IT,JE,LI,LU,MC,NL,NO,PT,SM,ES,SE,CH,GB)  , IN(TR.TRBCActivityCode,5220304027,5720102012,5720102013,5720102015,5730101010) )",    "SCREEN(U(IN(Equity(active or inactive,public ,primary))), CURN=USD, TR.F.TotRevenue(Period=FY0)>0 , IN(TR.HQCountryCode,MX,CA)  , IN(TR.TRBCActivityCode,5220304027,5720102012,5720102013,5720102015,5730101010) )",    "SCREEN(U(IN(Equity(active or inactive,public ,primary))), CURN=USD, TR.F.TotRevenue(Period=FY0)>0 , IN(TR.HQCountryCode,US)  , IN(TR.TRBCActivityCode,5220304027,5720102012,5720102013,5720102015,5730101010) )"]
list = []ld.open_session()for i in range(len(syntax_loop)):    df0 = ld.get_data(syntax_loop[i],"TR.CommonName")    list.append(df0)ld.close_session()df = pd.concat(list)print(df)

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @LRE42

    Thank you for reaching out to us.

    I can run the code properly.

    image.png

    If the issue happens intermittently, it could be the problem on the server side. You can use the try/except code to catch this exception and then retry. You can refer to this discussion.