I'm using the screener from Python. Is there a way to filter for instruments where TR.TRBCEconomicSe

import eikon as ek
import pandas as pd

Set your App Key

ek.set_app_key("...")

expr = (

'SCREEN('

'U(IN(Equity(active,public,primary))) AND TR.IsPrimaryQuote = 1 AND TR.IsDelistedQuote = false, IN(TR.TRBCEconomicSector,""), '

'TOP(TR.CompanyMarketCap, 25, nnumber), '

'CURN=USD'

')'

)

fields = [

"TR.OrganizationID",

"TR.CommonName",

"TR.CompanyMarketCap(CURN=USD)",

"TR.TRBCEconomicSector",

"TR.TRBCBusinessSector",

"TR.InstrumentType",

"TR.AssetCategory",

"TR.ExchangeName",

"TR.MICName"

]

Retrieve data

df, err = ek.get_data(expr, fields=fields)

Find more posts tagged with

python

screener

workspace

#technology

Accepted answers

All comments

wasin.w V3

Hello @Uday_PK

I am not sure what TR.TRBCEconomicSector that you need. I have followed the https://developers.lseg.com/en/article-catalog/article/find-your-right-companies-with-screener article to create a screener with the following conditions (TR.TRBCEconomicSector = Energy, Healthcare, and Technology)

I got the following TR function on Excel:

=@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TOP(TR.CompanyMarketCap, 25, nnumber), TR.IsPrimaryQuote==true, TR.IsDelistedQuote==false, IN(TR.TRBCEconSectorCode,""50"",""56"",""57""), CURN=USD)","TR.CommonName;TR.CompanyM"&"arketCap;TR.IsPrimaryQuote;TR.IsDelistedQuote;TR.TRBCEconomicSector","curn=USD RH=In CH=Fd")

Then I use the strategic https://developers.lseg.com/en/api-catalog/lseg-data-platform/lseg-data-library-for-python to use the Python code:

import lseg.data as ld 


ld.open_session()


universe='SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TOP(TR.CompanyMarketCap, 25, nnumber), TR.IsPrimaryQuote==true, TR.IsDelistedQuote==false, IN(TR.TRBCEconSectorCode,"50","56","57"), CURN=USD)'


fields = ["TR.OrganizationID","TR.CommonName","TR.CompanyMarketCap(CURN=USD)","TR.TRBCEconomicSector","TR.TRBCBusinessSector","TR.InstrumentType","TR.AssetCategory","TR.ExchangeName","TR.MICName"]


parameters = {"Curn":"USD"}


ld.get_data(universe=universe, fields=fields, parameters=parameters)

Result:

To learn more about the Data Library, check the following resources:

EXPLORE OUR SITES