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)

"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.

"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.

"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike

"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George

"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post

"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum

"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum

"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum

"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

"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

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, how to do automatic startup?

Author	Topic: Excel/DDE, how to do automatic startup? (4 messages, Page 1 of 1)
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Apr 27, 2010 06:05 PM Msg. 1 of 4 Hi - I have ventured into using Excel w/DDE connection to track some IQFeed numbers and it works great Wish I'd gotten into this years ago... My question has to do with starting it all up. When I crank up excel and get the spreadsheet up, I get the message about 'Some active content has been disabled'. When I specify to enable the date connection(to IQFeed, I presume) and to enable the links, another message pops up about 'Remote data not accessible'. I select 'Yes to All' and the IQLINK.EXE app starts up, after which everything works fine. Question is, how to I setup Excel to connect all the way through automatically and therefore bypass the manual steps?? I don't have any concerns about security, other apps, etc., as this pc is dedicated to DTNIQ stuff, so not to worry about any settings causing unforeseen consequences... Thanks.
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Apr 27, 2010 06:07 PM Msg. 2 of 4 oops...'date connection' --> 'data connection'.
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Apr 27, 2010 06:09 PM Msg. 3 of 4 damn, can't type, can't proof read, no 'edit' button... 'how to I setup Excel' --> 'how do I setup Excel'.
DTN_CurtisT -DTN Technical Support- Posts: 323 Joined: Jun 14, 2007	Posted: Apr 28, 2010 08:46 AM Msg. 4 of 4 Hello AMA, unfortunately with running just the DDE there is really no way to automate the connection within Excel. The two prompts you are getting when you start your DDE Excel spreadsheet is normal since Excel needs to do so to establish the connection. Since you are getting two prompts it sounds like you are running in Excel 2003, in Excel 2007 there is only one prompt which is nice but that is about it. Now you can run a 3rd party software which work directly within Excel and have them direct connect to IQFeed bypassing the DDE connection and that will allow you to automatically connect that way. You can find the software on our site at http://www.iqfeed.net/index.cfm?displayaction=data§ion=software. 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