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 am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"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
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"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
"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 enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"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
"You have an excellent product !!!!!!" - Comment from Arely
"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
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 »How to make an Excel DOM and TIME n SALES
Author Topic: How to make an Excel DOM and TIME n SALES (3 messages, Page 1 of 1)

jb1975
-Interested User-
Posts: 1
Joined: Jul 24, 2007


Posted: Jul 24, 2007 05:14 AM          Msg. 1 of 3
Hello
I use IQfeed with Quotetracker, to receive realtime datafeeds of the ES, YM futures contracts. While I love Quotetracker, Unfortunately Quotetracker doesnt have a futures Depth of Market(DOM)/ladder, nor does the TIME n SALES show the contracts offered on the BID and ASK, at the time of each transaction.

I would like to create these realtime features in Excel. Id be grateful for help in coding this, and the linking (DDE?) of IQfeed to Excel

Thanks

DTN_LorenF
-DTN Technical Support-
Posts: 228
Joined: May 11, 2004


Posted: Jul 24, 2007 07:41 AM          Msg. 2 of 3
We do have a sample DDE spread sheet that is installed with the IQfeed. If you call our service department I/we willl help you with what we can.

jbclem
-Interested User-
Posts: 24
Joined: Feb 23, 2005


Posted: Sep 14, 2007 07:41 PM          Msg. 3 of 3
jb1975...did you ever figure this out? I'm trying to learn how to feed Excel from IQFeed, and run some custom formulas, but I'm not sure how to get Excel to collect historical data, or to hold the previous day's data. If you get this message, can you share what you've learned, especially if you've figured out the DOM and Time and Sales issues.

Thanks,

jc
 

 

Time: Wed April 24, 2024 6:36 AM CFBB v1.2.0 8 ms.
© AderSoftware 2002-2003