how can i get a list of all U.S. stocks?

rice

If I want to get a list of all U.S. stocks, how should I do it? I tried using:

cond = 'IN(TR.ExchangeCountryCode,US)'
each_req = "SCREEN(U(IN(Equity(active,public)))/*UNV:Public*/, " + cond + ", NOT_IN(TR.InstrumentTypeCode,BONDFUT,BONDSPREAD,CEF,ETF,ETFA,ETFB,ETFC,ETFE,ETFM,ETFO,ETFX,ETMF,FU&N,GROWUNT,HDG,INS,OPF,OPTRTS,PAIDSUBRTS,PREFERRED,PRF,RTS,SUBSRTS),CURN=USD)"
fields = ["TR.OrganizationID", "TR.CompanyName", "TR.ExchangeName", "TR.IsPrimaryInstrument", "TR.ISIN", "TR.InstrumentType", "TR.ExchangeCountry"]
df_stock = ld.get_data(each_req, fields)

Is this the correct way to do it?

Jirapongse

@rice

Thank you for reaching out to us.

I can run the code properly with the desktop session.

It returns 17252 rows.

rice

https://community.developers.refinitiv.com/discussion/comment/127187#Comment_127187

Yes, I just wanted to confirm whether this is the correct way to fetch all active US stocks.

Jirapongse

@rice

This is the same formula used in the Screener app.

You can contact the helpdesk team directly via LSEG Support to confirm this.

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.

rice

I had no issues allowing this code a few days ago, why is it reporting an error today?

Jirapongse

@rice

I got the same error when using the rdp for the datagrid.

config = ld.get_config()
config.set_param("apis.data.datagrid.underlying-platform", "rdp")

I think the problem is the FU&N in the query.

I am not sure if it is FU&N or FUN.

You can contact the helpdesk team directly via LSEG Support to confirm this.