Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by newuser · Jan 03, 2019 at 08:49 AM · apieikon.netqueryexchange

Getting list of all nasdaq/nyse stocks

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?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
Best Answer
Answer by newuser · Jan 15, 2019 at 04:48 PM

I used excel eikon formula to get the list.

Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
dayquant · Aug 27, 2019 at 03:06 AM 0
Share

Can you please share the formula?

avatar image
REFINITIV
Alex Putkov. ♦♦ dayquant · Aug 27, 2019 at 12:40 PM 0
Share

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.

avatar image
REFINITIV
Answer by Zhenya Kovalyov · Jan 03, 2019 at 09:57 AM

@39783854-26aa-4fea-bc93-00b2ec21f8bb: 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.

Comment
SupDev1

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

.net realtime example

Download COM APIs for use in Microsoft Office

Eikon .Net API - Multiple time series subscriptions are causing problems

API Code for Eikon

How do I query Eikon to have immediate notifications when a security matching certain criteria is added by the data team?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges