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)




"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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
"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
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"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
"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
"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
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) »DTN.IQ Client Software Support »EXCEL DDE examples/samples/templates?
Author Topic: EXCEL DDE examples/samples/templates? (3 messages, Page 1 of 1)

AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007


Posted: Mar 12, 2011 02:04 PM          Msg. 1 of 3
Hi - somewhere on the DTN/IQFeed websites, or in the installation software, I found a sample or two of how to code Excel to grab data. I remember a sample watchlist, and maybe some other stuff, but haven't been able to find them. Looked at the help page, but that wasn't it. Could you point me to any samples you might have? Might be dreaming, but could swear I encountered and actual sample or two.

Very basic stuff for now, such as watchlist, options chain, Time & Sales. I want to experiment some with collecting data live and running it through Excel.

Previously, I'd managed to code up how to retrieve basic options data into Excel and that works great. Time to take it to the next level...

Thanks

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Mar 12, 2011 02:16 PM          Msg. 2 of 3
A few versions ago we moved the Sample DDE Spreadsheet into the IQFeed installer. Thus, you should be able to find the sample in the IQFeed folder. A shortcut should be available when clicking "Start --> All Programs --> IQFeed 4.7.2.0".

the only DDE interface directly supported with IQFeed is to get streaming data on a symbol basis. We don't include an interface for T&S, chains, etc. If you want more advanced functionality feeding data into Excel, I would suggest looking at XLQ or QuoteIN (3rd party apps) as they both provide a more efficient feed from IQFeed into Excel as well as advanced functionality and formulas.

Jay Froscheiser
DTN

AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007


Posted: Mar 12, 2011 03:40 PM          Msg. 3 of 3
Thanks for the quick response, Jay. Thought I'd lost my mind for a minute, but the sample spreadsheet was what I was remembering...
 

 

Time: Fri May 3, 2024 1:01 PM CFBB v1.2.0 17 ms.
© AderSoftware 2002-2003