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)

"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email

"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum

"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

"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

"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles

"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

"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 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

"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

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) »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...