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)




"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 use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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 let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
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: Thu May 2, 2024 8:12 AM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003