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)

"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon

"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum

"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

"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan

"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat

"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah

"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

"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

"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn

"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

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) »IQFeed Developer Support »Data Bars in Excel

Author	Topic: Data Bars in Excel (8 messages, Page 1 of 1)
indextrader -Interested User- Posts: 12 Joined: Feb 2, 2007	Posted: Feb 2, 2007 03:26 AM Msg. 1 of 8 I'm not sure if this is the proper forum but I'm looking for ways to input data into excel other than the simple "last" quotes in the sample dtn excel sheet. More specifically, I need a way to format data like the following...http://indextradersmarketideas.blogspot.com/ Doesn't look like this forum allows file attchements and that's the only way I know of to show what I'm looking for. Do I need some "custom" work done? API? Are there developers out there that can do these things economically? Thank you! Edited by indextrader on Feb 2, 2007 at 03:34 AM
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Feb 2, 2007 08:46 AM Msg. 2 of 8 The DDE for IQFeed was not originally designed for historical data. However, I know that a few people have written VBA within excel to agregate the data similar to what you are looking for. We have an example of this available here: ftp://www.dtniq.com/iq/Sample%20IQFeed%20DDE%20with%20T&S.xls
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 DTN IQFeed/DTN.IQ/DTN NxCore	Posted: Feb 2, 2007 09:23 AM Msg. 3 of 8 There are 2 options from DTN to do this. 1) is with our ProphetX Active Trader product and its "Tabular Display" - http://www.dtniq.com/flash/pxdemo/tabulardisplay.jpg. as you can see in the image, you can also put multiple symbols in the display. You can then Set this display up as a DDE link from the Product. With ProphetX, you are getting a full analytics package, great news display, free form functions in charts/quote sheets, and DDE. The pricing is $75 per month with annual subscription. 2) Take a look at QuoteIN on our compatible software page at www.dtniq.com. QuoteIN is a 3rd party software that works on IQFeed and expands the DDE linking capability to include hisorical data as well. Jay Froscheiser DTN - Trading Markets
indextrader -Interested User- Posts: 12 Joined: Feb 2, 2007	Posted: Feb 5, 2007 02:12 AM Msg. 4 of 8 Ok, so if I understand both you and Steve are saying that while the DDE quotes you currently offer for Excel are not able to fetch historical data, the data is available thru your API if one is competent at programming for it? In other words, if I wanted historical minute data for 300 stocks for say, 20 days, on demand at the beginning of the day, the data is available? Or would I first have to collect data for ALL stocks for a period of time, store it on my hard drive and then access it? I'm trying to figure out what I CAN and can't do with your data feeds in order to hire the right programmer to obtain the data. Jay, while ProphetX appears to be a very good program, I need to stick with a data feed for the versatility in programming for "X" factors. Thanks very much guys. I'd really appreciate a response. Edited by indextrader on Feb 5, 2007 at 02:13 AM Edited by indextrader on Feb 5, 2007 at 02:14 AM
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Feb 5, 2007 09:55 AM Msg. 5 of 8 Yes, in terms of historical data that is available through the API, we keep: 8 days of tick by tick data (no pre/post market ticks currently) 120 days of minute history (available in any increment of minutes) Daily, weekly, monthly data has no defined limit. (for example, MSFT goes back 10+ years) Any of this data is available at anytime throughout the day.
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 DTN IQFeed/DTN.IQ/DTN NxCore	Posted: Feb 5, 2007 05:04 PM Msg. 6 of 8 Also, in case you missed it on my post, you don't need to hire a programmer to write something for you to pull historical data into Excel with IQFeed. You can use QuoteIN or XQL (both 3rd party software that supports IQFeed) to pull in IQFeed historical data into Excel. This will give you the streaming data and history, and they also use RTD instead of DDE which is MUCH more efficient. Jay Froscheiser DTN - Trading Markets
indextrader -Interested User- Posts: 12 Joined: Feb 2, 2007	Posted: Feb 8, 2007 09:48 AM Msg. 7 of 8 Jay, thanks for your help on this. Regarding RTD, how do customers like myself currently using your datafeed change over from DDE to RTD? I've also heard of it's better efficiency and have been waiting for some "initiative" on this. Most data vendors it seems mention it, yet do not have a detailed way for customers to use it. What should people who want quotes via RTD do then? Thanks again!
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 DTN IQFeed/DTN.IQ/DTN NxCore	Posted: Feb 8, 2007 10:31 AM Msg. 8 of 8 To be honest, I don't have much experience with RTD (using XLQ or QuoteIN). I have talked to a fair number of customers using them however, and I haven't heard of any heartache in using RTD. Thus, I would guess it is a minor change in the formulas. I would suggest looking at the documentation on XLQ and QuoteIN's website as I am sure it will explain how to get RTD working using IQFeed. My guess is it is as easy as DDE since RTD is now natively supported in Excel. Jay Froscheiser DTN - Trading Markets