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 »Archive (2017 and earlier) »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: 1746
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 July 1, 2025 8:38 PM CFBB v1.2.0 21 ms.
© AderSoftware 2002-2003