DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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)

"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email

"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post

"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob

"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat

"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip

"Excellent datafeed !!!" - Comment from Arely

"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum

"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George

"You have an excellent product !!!!!!" - Comment from Arely

"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott

Home

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »Archive (2017 and earlier) »Data and Content Support »how to understand the symbol format

Author	Topic: how to understand the symbol format (16 messages, Page 1 of 1)
junkone -Interested User- Posts: 28 Joined: Jul 18, 2007	Posted: Aug 26, 2017 10:29 AM Msg. 1 of 16 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 Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Aug 28, 2017 06:42 AM Msg. 2 of 16 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: 28 Joined: Jul 18, 2007	Posted: Aug 28, 2017 09:08 PM Msg. 3 of 16 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 Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Aug 29, 2017 07:10 AM Msg. 4 of 16 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: 28 Joined: Jul 18, 2007	Posted: Aug 29, 2017 11:32 PM Msg. 5 of 16 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: 74 Joined: Mar 24, 2010	Posted: Aug 30, 2017 12:11 AM Msg. 6 of 16 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: 28 Joined: Jul 18, 2007	Posted: Aug 30, 2017 09:07 PM Msg. 7 of 16 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 Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Aug 31, 2017 12:57 PM Msg. 8 of 16 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: 28 Joined: Jul 18, 2007	Posted: Sep 4, 2017 06:47 PM Msg. 9 of 16 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 Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Sep 5, 2017 02:05 PM Msg. 10 of 16 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
junkone -Interested User- Posts: 28 Joined: Jul 18, 2007	Posted: Oct 7, 2018 06:47 PM Msg. 11 of 16 was the LSE issue ever fixed?
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Oct 8, 2018 09:53 AM Msg. 12 of 16 At this time the total LSE symbols displayed in our Symbol Lookup does still include Mutual Funds and Bonds. This is on our roadmap to resolve. Unfortunately I do not have an ETA. Can you expand on your question regarding "Understanding symbol Format"? Stephen Shockey \| DTN \| Trading Customer Service Technical Support Phone: 800.779.7299 \| International 402.255.3918 stephen.shockey@dtn.com www.dtn.com
junkone -Interested User- Posts: 28 Joined: Jul 18, 2007	Posted: Oct 8, 2018 08:31 PM Msg. 13 of 16 i was trying to load my amibroker and need to figure out which are just the LSE stocks. when i look at the spreadsheet from DTN, there are 11774 records matching equity in the LSE exchange. the breakdown is LSE LSE 9873 LSE LSEI 1901 Which of these are just equity. I dont care about bonds or mutual funds.
DTN Todd -Interested User- Posts: 74 Joined: Mar 24, 2010	Posted: Oct 8, 2018 08:56 PM Msg. 14 of 16 At the following link http://www.iqfeed.net/symbolguide/index.cfm?symbolguide=lookup&displayaction=support§ion=guide&web=iqfeed enter L in the search text field In the filter by exchange select LSE In the security type select Equity then select the search button. That will give you the list you are looking for
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Oct 9, 2018 10:15 AM Msg. 15 of 16 LSEI are the index symbols. Stephen Shockey \| DTN \| Trading Customer Service Technical Support Phone: 800.779.7299 \| International 402.255.3918 stephen.shockey@dtn.com www.dtn.com
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Oct 10, 2018 10:41 AM Msg. 16 of 16 To clarify LSEI symbols are International Equities on the London Stock Exchange. We have removed Mutual funds and Bonds from the LSE symbol total. Please keep in mind the 11,774 total symbols on the LSE includes ETF symbols. Hopefully this fully answers your questions regarding LSE symbols. Stephen Shockey \| DTN \| Trading Customer Service Technical Support Phone: 800.779.7299 \| International 402.255.3918 stephen.shockey@dtn.com www.dtn.com