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)




"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"Everything is working great with the API. I love it." - Comment from Calvin
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"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 used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"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
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) »IQFeed 3rd Party Software Support »Basic Backfill Question
Author Topic: Basic Backfill Question (4 messages, Page 1 of 1)

optional
-Interested User-
Posts: 10
Joined: Feb 25, 2008


Posted: Feb 25, 2008 10:29 AM          Msg. 1 of 4
I signed up for the basic IQFEED service demo, I am trying to get backfill 1 minute bars for a futures contract. The product information page says that it is available for 1.5 years historically. I only need to get the last 5 days.

I am using Excel.

Thanks in advance

DTN_SarahS
-DTN Evangelist-
Posts: 195
Joined: May 31, 2007


Posted: Feb 25, 2008 10:39 AM          Msg. 2 of 4
Hello Optional,

Unfortunately, using Excel alone, there is no way to retrieve historical data with IQ Feed. You will need some way to view the historical data. If you prefer to stick to Excel and the DDE linking, I would reccomend a product called XLQ, it will allow you to retrieve the historical data you need to display in Excel. Otherwise, you may want to try DTN IQ or a third party software along side your Excel.

Please let me know if you have further questions.

Kind regards,

Sarah
DTN Trading Markets

optional
-Interested User-
Posts: 10
Joined: Feb 25, 2008


Posted: Feb 25, 2008 10:57 AM          Msg. 3 of 4
I'm willing to consider anything that will just get me the data in some text or XML format. Lightweight as possible, since I'm really just shopping for a data feed.

I have to say, that having to add a 3rd party application to your data feed to get the data feed makes me feel somewhat confused.

DTN_Steve_S
-DTN Guru-
Posts: 2093
Joined: Nov 21, 2005


Posted: Feb 25, 2008 11:03 AM          Msg. 4 of 4
Just to clarify this a bit. It should be possible to retrieve historical data from IQFeed into excel using VBA. However, this is not supported unless you are subscribed to the developer API service.

As Sarah mentioned, our DDE app that feeds data into Excel, only supports realtime streaming data. If you are not looking to develop your own method for retrieving the data, XLQ is developed by one of our API customers and does offer this feature.

To further clarify "what IQFeed is". Simply put, it is a datafeed. We do offer a DTN client application for IQFeed as well (DTN.IQ) but it is not required to use the datafeed. There is a wide variety of other 3rd party apps that support IQFeed as well and you can use any combo of these to get data in whatever format/display you are needing.

If you are wanting to write your own app to process the data from IQFeed, you will need to subscribe to our API service.
Edited by DTN_Steve_S on Feb 25, 2008 at 11:04 AM
 

 

Time: Tue May 7, 2024 11:46 AM CFBB v1.2.0 7 ms.
© AderSoftware 2002-2003