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

"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

"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy 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

"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

"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

"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei

"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

"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim

"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry

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.