Getting list of all nasdaq/nyse stocks

newuser

Hi. I am using Eikon .NET API. I want to get list of all nyse/Nasdaq symbols and then subscribe to prices. Is there a sample code?

newuser

I used excel eikon formula to get the list.

Zhenya Kovalyov

@39783854-26aa-4fea-bc93-00b2ec21f8bb_deprecated_3a75f99c-5134-4b2b-ba84-37662f80bc56: subscribing to real-time updates is the easy part, here is the samples and the tutorial.

As for getting all of the symbols, there is no search api available for .NET at this time. So, here are a few possible ways forward:

• if you have a list of street tickers or any other clearing codes, you can convert them to RICs with the symbology conversion api.
• you can create a list in Excel with a screener query. Go to Eikon Excel > Thomson Reuters tab > Screener and request all active companies listed on NASDAQ and NYSE;
• You can reuse one of the pre-built lists called chains, for example, index consituents for S&P 500 is <0#.SPX>. For specialist chains, I suggest you speak to your local Refinitiv support desk.

Keep in mind that there is a hard limit on simultaneous subscriptions, I do not think you can get more than 2000-2500 tickers streaming at the same time.

dayquant

https://community.developers.refinitiv.com/discussion/comment/37252#Comment_37252

Can you please share the formula?

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/47886#Comment_47886

If you're looking to retrieve the listing of an exchange, take a look at this thread. The screener expression in this answer can also be used in =TR function in Excel. You may also want to watch short video tutorial titled "Working with the Screener" available from the main Eikon menu - Help - Tutorials and Training. Finally if you have any questions about using Eikon Excel add-in you can reach out to Refinitiv Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.