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

rice · July 30

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 · July 30

@rice

Thank you for reaching out to us.

I can run the code properly with the desktop session.

It returns 17252 rows.

rice · July 31

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 · July 31

@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 · August 1

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

Jirapongse · August 1

@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.

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

Answers

Categories

EXPLORE OUR SITES

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

Answers

Categories