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)




"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"Everything is working great with the API. I love it." - Comment from Calvin
"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
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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
"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 used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"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
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 »DDE Link Coding
Author Topic: DDE Link Coding (3 messages, Page 1 of 1)

jean
-Interested User-
Posts: 29
Joined: Jul 24, 2004


Posted: Aug 29, 2004 05:27 PM          Msg. 1 of 3
I would like to create some simple uses of the DDE link within Excel; namely to receive live data e.g. Time & Sales and to simultaneously see this data build real-time in an Excel Chart.

Does anyone know how I can do this?

Also, I would like to retrieve Historical data through a DDE link. Again any ideas?

Thanks

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

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Aug 30, 2004 10:05 AM          Msg. 2 of 3
Jean,

You can take a look at a sample DDE spreadsheet available at ftp://www.dtniq.com/iq/ . Download the Sample IQFeed DDE with T&S.xls. It is based on a macro that isn't supported, and isn't very good. However, it may give you some ideas.

At this time there isn't a way to pull historical data into Excel from the IQ servers using DDE. With a DTN.IQ subscription you can use the T&S app to export data into Excel though.

A good place to visit is the XLTraders group on yahoo. These folks are high end Excel users who have written many apps with various datafeeds.

http://groups.yahoo.com/group/xltraders

Jay Froscheiser
DTN Market Access, LLC.

jean
-Interested User-
Posts: 29
Joined: Jul 24, 2004


Posted: Aug 30, 2004 11:52 AM          Msg. 3 of 3
OK, thanks for the information
 

 

Time: Tue May 7, 2024 11:01 AM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003