Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"I was with ******* for 4 years at $230 a month, this is a huge savings for me, GOD BLESS YOU PEOPLE," - Comment from T.S. via Email
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
Home  Search  Register  Login  Blogs Recent Posts

Information on Various DTN Products:
DTN IQFeed | DTN ProphetX | DTN Ag | NxCore
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »Data and Content Support »how to understand the symbol format
Author Topic: how to understand the symbol format (10 messages, Page 1 of 1)

junkone
-Interested User-
Posts: 24
Joined: Jul 18, 2007


Posted: Aug 26, 2017 10:29 AM          Msg. 1 of 10
The number of stocks listed in nasdaq is 3.5k http://i.imgur.com/HhAubKE.png
but the number of stocks that your symbols lookup is showing is >63k. http://i.imgur.com/hUMtulT.png
how do i filter out the right symbols from mktsymbols_v2 zip file. the zip file matchs your website but there seems to be too much symbols for LSE and Nasdaq that dont align with the counts provided by the exchange.

DTN_Stephen
-DTN Evangelist-
Posts: 116
Joined: Aug 22, 2014


Posted: Aug 28, 2017 06:42 AM          Msg. 2 of 10
The number 63,449 under NASDAQ that you see it the total number of Equities, Equity Option symbols, Indexes, OTC and Futures symbols.

You can drill further down by utilizing the Security Type field just below where you had chosen Filter by Exchange.

Stephen Shockey | Telvent DTN LLC | Trading Markets | United States |Customer Service Technical Support
Email: support@iqfeed.net

junkone
-Interested User-
Posts: 24
Joined: Jul 18, 2007


Posted: Aug 28, 2017 09:08 PM          Msg. 3 of 10
it still does not add up. I pulled all the Nasdaq info in a pivot table and you can see I don't get the right counts. Just tell me what doe these different column types mean?



I have exchange=Nasdaq
when I filter Equity, I get 19091 symbols. this is way too many for nasdaq
http://i.imgur.com/HdyGiGR.png

DTN_Stephen
-DTN Evangelist-
Posts: 116
Joined: Aug 22, 2014


Posted: Aug 29, 2017 07:10 AM          Msg. 4 of 10
Equity is stock symbols.

Index is index symbols.

Money is money market symbols.

Mutual is mutual funds.

Stephen Shockey | Telvent DTN LLC | Trading Markets | United States |Customer Service Technical Support
Email: support@iqfeed.net

junkone
-Interested User-
Posts: 24
Joined: Jul 18, 2007


Posted: Aug 29, 2017 11:32 PM          Msg. 5 of 10
why do you hve 19k Nasdaq symbols in equity? it makes no sense when Nasdaq posts that they have 3.5 k symbols.

DTN Todd
-Interested User-
Posts: 33
Joined: Mar 24, 2010


Posted: Aug 30, 2017 12:11 AM          Msg. 6 of 10
That number of 19,086 includes NCM, NGM, MGSM, OTCBB and OTC. The over the counter stocks account for more then 15,000

junkone
-Interested User-
Posts: 24
Joined: Jul 18, 2007


Posted: Aug 30, 2017 09:07 PM          Msg. 7 of 10
so which part of this accounts for the Nasdaq only. there are 3273 listed in their website
http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NASDAQ. Should I just ignore OTC only or should I ignore any of the other ones NCM, NGM, MGSM?
I need better clarity as its your symbol list and I need to make it better.
I have similar issue with LSE symbols where the counts are greater than what is listed in LSE

DTN_Stephen
-DTN Evangelist-
Posts: 116
Joined: Aug 22, 2014


Posted: Aug 31, 2017 12:57 PM          Msg. 8 of 10
If you utilize NCM, NGM and NGSM you will get the expected results for NASDAQ. You should omit OTC and OTCBB.

Stephen Shockey | Telvent DTN LLC | Trading Markets | United States |Customer Service Technical Support
Email: support@iqfeed.net

junkone
-Interested User-
Posts: 24
Joined: Jul 18, 2007


Posted: Sep 4, 2017 06:47 PM          Msg. 9 of 10
ok, how do I distinguish these LSE stocks. I am sure its not 23k that exist on the exchange.
https://i.imgur.com/6ay9QqT.png

DTN_Stephen
-DTN Evangelist-
Posts: 116
Joined: Aug 22, 2014


Posted: Sep 5, 2017 02:05 PM          Msg. 10 of 10
Unfortunately that number 23,304 that our symbol lookup is reflecting for London Stock Exchange (Equities) has Mutual Funds and Bonds intermingled.

This has been reported to our developers for resolution. Unfortunately there is not an ETA at this time.

Stephen Shockey | Telvent DTN LLC | Trading Markets | United States |Customer Service Technical Support
Email: support@iqfeed.net
 

 

Time: Thu November 23, 2017 6:15 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003