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 am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"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
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"Thank you so much - awesome feed, awesome service!" - Comment from Greg 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.
"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
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"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
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
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: Thu May 2, 2024 10:36 AM CFBB v1.2.0 8 ms.
© AderSoftware 2002-2003