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 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
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"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
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"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
"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
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
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) »Data and Content Support »Effective Futures Download
Author Topic: Effective Futures Download (5 messages, Page 1 of 1)

Jan Krpalek
-Interested User-
Posts: 10
Joined: Oct 17, 2012


Posted: Sep 23, 2013 04:29 AM          Msg. 1 of 5
Hello,

i am wondering how i can download futures data for enclosed symbols. I generated a list of symbols but most of them is not found in the database. Are there any more rules i should include in my list generating process?

First you put ticker, than expiration month and year. Eg: HOF07, M6MG11, ESX09.

NYMEX and COMEX are working alright, but i have difficulties specially with agriculture and currencies. The point of my analysis should by in calculating contango and backwardation as far as it possible on whole spectrum of instruments, so i need all contracts regarding one ticker which saved in IQ Feed Database (daily data only).

What data subscription i need to have ordered? I have only NYMEX, COMEX and CME. Because i have found in "Symbol look up" that currencies are preceded by "M", i used it also in my list.

I enclose the list of tickers i am interested in and also monthly codes, which i use for my ticker list.

Thank you very much for your help,
John

Jan Krpalek
-Interested User-
Posts: 10
Joined: Oct 17, 2012


Posted: Sep 23, 2013 04:31 AM          Msg. 2 of 5
Tickers i am interested in...
ZC
ZS
ZL
ZM
ZW
LE
HE
FC
CL
NG
BZ
RB
HO
QM
ES
ND
YM
NKD
NQ
SP
6A
6C
6S
6E
6B
6J
6M
GE
ZB
ZN
ZF
ZT
GC
PL
SI
PA
HG

Edited by Jan Krpalek on Sep 23, 2013 at 04:32 AM

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Sep 23, 2013 11:08 AM          Msg. 3 of 5
Hello Jan,

Here are the symbols you have requested. Let us know if anything else comes up.

Exchange DTN equivalent
ZC @C
ZS @S
ZL @BO
ZM @SM
ZW @W
LE @LE
HE @HE
FC @GF
CL QCL
NG QNG
BZ QBZ
RB QRB
HO QHO
QM @QM
ES @ES
ND @ND
YM @YM
NKD @NKD
NQ @NQ
SP @SP
6A @AD
6C @CD
6S @SF
6E @EU
6B @BP
6J @JY
6M @PX
GE @ED
ZB @US
ZN @TY
ZF @FV
ZT @TU
GC QGC
PL QPL
SI QSI
PA QPA
HG QHG


Tim

Jan Krpalek
-Interested User-
Posts: 10
Joined: Oct 17, 2012


Posted: Sep 24, 2013 08:55 AM          Msg. 4 of 5
Thank you very much for your help.

Does IQ Feed have any documentation, database of tickers you can find directly without dealing with discussion forum? Of course i have seen the list on pages, but there you can find only concrete tickers, current ticker. Maybe the convention of some would had changed, every broker has a slightly different convention... For example NGK07 definitely exists, but you can't find it on the database.

And i don't even talk about options which are in ... horrible mess i would say. Do you have any idea how to create a list of all possible options traded on SPX.XO (theoretical index)? Yes, i know the convention for stocks: MOT0917J7, FDX0918S22.5 etc. Is it really the only way how to find these ticker in your database by method of "trial and error"?

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Sep 24, 2013 10:16 AM          Msg. 5 of 5
Jan,

While we do publish all current symbols in a text file that is updated every 24 hours. It will not contain any expired symbols, such as your examples NGK07 or MOT0917J7. Unfortunatly there is not a way to create these other than trial and error at this time. Also, please be aware that equity option history was not saved prior to March 2010.

In case it is of any aid to you here is the link for the current symbol lists.

http://www.dtniq.com/product/mktsymbols_v2.zip

Tim
 

 

Time: Tue April 23, 2024 2:22 AM CFBB v1.2.0 8 ms.
© AderSoftware 2002-2003