|
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)
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"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
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
|
|
|
|
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: 183
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.
|
|
|
|