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)




"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"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
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"It’s so nice to be working with real professionals!" - Comment from Len
"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
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 »Product Support »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: Fri March 24, 2023 7:38 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003