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

"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.

"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post

"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

"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe

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

"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email

"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom

"Everything is working great with the API. I love it." - Comment from Calvin

"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

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) »Data and Content Support »DDE link support

Author	Topic: DDE link support (2 messages, Page 1 of 1)
dasziel -Interested User- Posts: 3 Joined: May 2, 2008	Posted: Jul 15, 2009 04:25 AM Msg. 1 of 2 I need to integrate in Excel cells the following fields: time, bid,bid volume, ask, ask volume, last, tick volume in order to generate a T&S sheet. May you give me the right commands to enter the cells for @ES#? Many thanks in advance I use IQfeed
DTN_CurtisT -DTN Technical Support- Posts: 323 Joined: Jun 14, 2007	Posted: Jul 15, 2009 07:30 AM Msg. 2 of 2 Hello Dasziel, were you looking to build a Time & Sales Sheet via DDE from IQFeed? If so, the DDE Link will not be able to so since it just provides current Streaming Quote Data from IQFeed into Excel. To run as a Time & Sales within Excel what you would need to do is run a 3rd Party software like, XLQ from http://www.qmatix.com/index.htm, QuoteLink from http://www.quotelink.net, or QCollector from http://www.mechtrading.com/qcollector/dtn/index.htm. These softwares run off of our API IQFeed rather than the DDE Link and will provide Time & Sales within Excel. As far as the Formulas for what you are looking for that will be; =IQLink\|'Symbol!'Field' For Example, for the Last traded Price for @ES# it will be =IQLink\|'@ES#'!Last, you will need to use single quotations around @ES# since it has the @ sign at the front of the symbol and Excel will think of it as a Formula within a Formula without them and will error out. All of the Fields are also available within the Sample DDE Spreadsheet that is installed with IQFeed. It is located under Start, All Programs, IQFeed 4.5.0.3, Sample DDE Spreadsheet. On there it will give you all of the available fields that the DDE Link can use to pull data from IQFeed. If you have any other problems or questions please let us know. Curtis Thompson curtis.thompson@dtn.com Trading Markets Customer Service 1-800-397-7000 x3614 Edited by DTN_CurtisT on Jul 15, 2009 at 07:30 AM