DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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 keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don

"Everything is working great with the API. I love it." - Comment from Calvin

"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip

"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal

"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum

"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.

"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum

"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post

"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim

"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email

Home

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »Archive (2017 and earlier) »Data and Content Support »Download in Excel or to ASCII File

Author	Topic: Download in Excel or to ASCII File (6 messages, Page 1 of 1)
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 2, 2012 01:28 AM Msg. 1 of 6 Is it possible to download historical futures data to Excel or an ASCII File? I have seen that I place in Excel the current quote, but did not figure out how to download a complete set of historical quotes for a future. Is there even a feature where I can download all historical future contracts (not merged, seperate files for contracts) for a selected product (e.g. wheat)?
DTN_CurtisT -DTN Technical Support- Posts: 323 Joined: Jun 14, 2007	Posted: Mar 2, 2012 06:49 AM Msg. 2 of 6 Hello Datatest, You will need to use a 3rd party software, of which the only one that I know of that can download all Historical data directly into either ASCII or Excel is called QCollector from www.mechtrading.com this program allows you to build a list of symbols then have them all download historical data directly into individual files for each symbol as well as have timed updates to keep them up to date. There maybe other software's that are able to do this, but this is the only one that we are aware of that can download all historical data from IQFeed and save it directly to a file. If you have any other questions please let us know. Thanks. Curtis Thompson support@iqfeed.net support@dtniq.com Trading Markets Customer Service 1-800-397-7000 x3614
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 2, 2012 01:09 PM Msg. 3 of 6 thanks. I contacted them and the application is able to do what I want. My question now: How many years back do you have futures contracts?
DTN_CurtisT -DTN Technical Support- Posts: 323 Joined: Jun 14, 2007	Posted: Mar 2, 2012 02:08 PM Msg. 4 of 6 Hello Datatest For our symbols we have up to 3 to 5 years (minis going back to 2005) for Minute data, up to 10 years for Daily, and 10 to 20 years for weekly and monthly data. Tick data we have up to 120 calendar days that you can pull during aftermarket hours starting at 4:30 PM EST to 9:30 AM EST the next morning. During active market hours this is limited to 8 calendar days. If you have any other problems or quesetions please let us know. Thanks. Curtis Thompson support@iqfeed.net support@dtniq.com Trading Markets Customer Service 1-800-397-7000 x3614
datatest -Interested User- Posts: 23 Joined: Feb 29, 2012	Posted: Mar 2, 2012 02:54 PM Msg. 5 of 6 ok, thanks. can you tell me how many years of daily data it is exactly for futures such as corn, wheat and soybean? When I download the continous contract it is back to 1996. Does this mean I can load also single contracts until then?
DTN_ToddH -DTN Guru- Posts: 287 Joined: Oct 6, 2011	Posted: Mar 2, 2012 03:54 PM Msg. 6 of 6 Hello Datatest, You are correct that the continous contracts go back to 1996 for corn, soybeans, and wheat. The oldest single contracts that I found in IQFeed were, CH96, SH96, and WH96. Those three contracts showed data back to late-1994.