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)




"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 would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"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
"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
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"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
"I am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »General Product Announcements »New symbol lookup/search for DTN.IQ and IQFeed
Author Topic: New symbol lookup/search for DTN.IQ and IQFeed (1 messages, Page 1 of 1)

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1752
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Aug 18, 2009 09:55 AM          Msg. 1 of 1
DTN has released an enhanced symbol lookup/search tool on our websites that will make it easier to find the symbols you are looking for. In addition to new search criteria and filters, we have also updated the format of the master symbol file we make available to our customers. The enhanced format master symbol file is updated daily and available for download by visiting www.iqfeed.net and selecting “Symbol Look-Up”. The old format master symbol file (mktsymbols.zip) will no longer be available after August 31, 2009.

Overview of the enhancements to the online Symbol Lookup tool:
The new search has multiple filter levels and search options.
• SIC/NAICS Code Search: Search by NAICS or SIC code and receive all the symbols that make up that industry segment
• Security Type Filter: Restrict the results to a single security type (ie. if you only want the futures, not stocks, options, etc, you should choose “Future”).
Search Options:
o Show Front Month Only: Restricts results to only the front month contracts as identified by the DTN Ticker Plant
o Show Combined Session Only: Restricts results to symbols starting with “+”
o Show Continuous Contracts Only: Restricts results to symbols ending in “#”
o Show E-Minis Only: Restricts results to Listed Market of CMEMINI, CBOTMINI and NYMEXMINI.
o Don’t Show Options: Eliminates Security Type of “FOPTION” and “IEOPTION” from results
o Don’t Show Spreads: Eliminates Security Type of “SPREAD” from results
o Output Symbols Only: Allows user to cut/paste the symbol list results from the webpage into DTN.IQ, ProphetX and other apps.

Format of the new master symbol file:
File name: mktsymbols_v2.zip
Format: Tab Delimited Text (after unzipping file)
Field Order:
1) SYMBOL: Symbol of equity, future, option etc.
2) DESCRIPTION: Symbol Description
3) EXCHANGE: Common name for Listed Exchange
4) LISTED MARKET: Primary Listed Market for the Security
5) SECURITY TYPE: Type of Security
a. BONDS
b. CALC
c. EQUITY
d. FOPTION
e. FOREX
f. FORWARD
g. FUTURE
h. IEOPTION
i. INDEX
j. MKTSTATS
k. MONEY
l. MUTUAL
m. PRECMTL
n. SPOT
o. SPREAD
6) SIC: Standardized Industry Classification Code (Stocks Only)
7) FRONTMONTH: Contains a “Y” if the future is the current front month contract.
8) NAICS: North American Industry Classification System code (Stocks Only)

Jay Froscheiser
DTN
 

 

Time: Tue May 21, 2019 8:12 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003