HOW CAN I GET ALL TICKER NAMES FROM CONSOLIDATED EXCHANGES IN US

karenallen.eusebio

e.g. AAPL.OQ rather than AAPL.O
THIS IS MY CODE. I'M USING CODEBOOK

ld.open_session()#US#tickers= list(Screener('U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,"US"), IN(TR.GICSSectorCode,"10","15","20","25","30","35","40","45","50","55","60"), DOES_NOT_CONTAIN(TR.ExchangeCode,"PNK"), CURN=USD'))#HKtickers= list(Screener('U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,"HK"), IN(TR.GICSSectorCode,"10","15","20","25","30","35","40","45","50","55","60"), CURN=USD'))print(f"Total tickers: {len(tickers)}")

Jirapongse

@karenallen.eusebio

Thank you for reaching out to us.

It could be Screener or Search API. However, the Search API limits the output to 10,000 entries.

For the Screener, please contact the helpdesk team via LSEG Support to verify the formula. It is the same formula used in the Screener app.

For the Search API, please refer to the following articles:

• Building Search into your Application Workflow
• Find content and functionality using the Data Library with Workspace Advanced Search