Company Screener not returning results

Giorgio Cozzolino

I am trying to run the screener function on python but a code which used to work in the past is now not working properly. I would expect the below to yield results but nothing seem to come up?

code = 'TR.NAICSSubsectorAllCode(Concat=|)'
naics_code = '325'
syntax = 'SCREEN(U(IN(Equity(active,public,private,primary))), \
            CONTAINS(' + code + ',' + naics_code + '), \
            TR.TotalRevenue(Period=FY0,Scale=6)>=1000, CURN=USD)'


fields = ["TR.OrganizationID","TR.CommonName","TR.CUSIPCode","TR.ISINCode","TR.IsPublic","TR.BusinessSummary","TR.HeadquartersCountry",
          "TR.NAICSSectorAll(Concat=|)","TR.NAICSSectorAllCode(Concat=|)","TR.NAICSSubsectorAll(Concat=|)","TR.NAICSSubsectorAllCode(Concat=|)",
          "TR.NAICSIndustryGroupAll(Concat=|)","TR.NAICSIndustryGroupAllCode(Concat=|)","TR.NAICSInternationalIndustryAll(Concat=|)","TR.NAICSInternationalIndustryAllCode(Concat=|)",
          "TR.CompanyMarketCap(SDate=0D,Curn=USD,Scale=6)", "TR.CurrEnterpriseValueEV(Curn=USD,Scale=6)","TR.Revenue(Period=FY0,Curn=USD,Scale=6)", 
          "TR.EBITMarginPercent(Period=FY0)","TR.F.EBITDAMargPct(Period=FY0)","TR.NetProfitMargin(Period=FY0)", 
          "TR.ExchangeName","TR.UltimateParent","TR.UltimateParentId"]

df, e = ek.get_data(syntax, fields)
df

I have attached evidence of the issue. Could you please help?

Jirapongse

@Giorgio Cozzolino

Thank you for reaching out to us.

I ran the code and found that the response contains an error "processing failed".

However, if I change 'TR.NAICSSubsectorAllCode(Concat=|)' to 'TR.NAICSSubsectorAllCode', the code can run properly.

code = 'TR.NAICSSubsectorAllCode'
naics_code = '325'
syntax = 'SCREEN(U(IN(Equity(active,public,private,primary))), \
            CONTAINS(' + code + ',' + naics_code + '), \
            TR.TotalRevenue(Period=FY0,Scale=6)>=1000, CURN=USD)'

You need to contact the helpdesk team via MyAccount to verify the query.