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)




"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
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"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 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.
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"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
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
Home  Search  Register  Login  Blogs 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: Mon March 25, 2019 9:30 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003