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)




"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've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"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
Home  Search  Register  Login  Blogs Recent Posts

Information on Various DTN Products:
DTN IQFeed | DTN ProphetX | DTN Ag | NxCore
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »Data and Content Support »How do I start?
Author Topic: How do I start? (3 messages, Page 1 of 1)

kevin
-Interested User-
Posts: 1
Joined: Apr 11, 2014


Posted: Apr 11, 2014 11:50 PM          Msg. 1 of 3
Hello everyone,

I apologize if this if covered elsewhere, but how do I access minute-by-minute historical data? The documentation provided only covers how to access certain data through Excel (e.g. =IQLink|symbol!field). I'm not sure where to start.

I am looking to obtain minute data for certain symbols and date ranges and to save them in easily parse-able file formats (.csv, .txt, etc.). How can I used this software to do this?

Any help or guidance would be much appreciated. Thank you,

Kevin

DTN_CurtisT
-DTN Technical Support-
Posts: 323
Joined: Jun 14, 2007


Posted: Apr 13, 2014 04:01 PM          Msg. 2 of 3
Hello Kevin, DDE by itself will only give you streaming data from IQFeed. To be able to download Historical data you will need to use a 3rd party charting software which there are 3 that work really well with IQFeed and Excel. The first two that work directly within Excel is XLQ from www.qmatix.com, and QuoteLink from www.quotelink.net. The third runs as a separate program from excel but connects to IQFeed to download both streaming and historical data and saves the data into excel formatted file and it is called QCollector from www.mechtrading.com. I would recommend checking out all three to see which one would work best for you and what you are wanting to accomplish.

Curtis Thompson
support@iqfeed.net
support@dtniq.com
support@prophetx.com
Trading Markets Customer Service
1-800-397-7000

AMA
-DTN Evangelist-
Posts: 179
Joined: Aug 1, 2007


Posted: Apr 16, 2014 07:21 PM          Msg. 3 of 3
If by chance you also have the DTNIQ interface app from Telvent that gets it's data feed from IQFeed, you can use a Time & Sales window to do what you want. Bring up a Time & Sales window, configure it to gather minute data back as far as you want(for me, stock data goes back into 2007), then click on the small diskette icon, at which point you'll be prompted where to save and which format. Specify comma delmited for .CSV and you'll be all set.

You have to do this manually, or perhaps you could write a Windows macro to do this for you, if you have a repetitive task to accomplish.
 

 

Time: Tue February 20, 2018 5:29 PM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003