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)




"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
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: Sat April 27, 2024 7:27 AM CFBB v1.2.0 7 ms.
© AderSoftware 2002-2003