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)
