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 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 cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles

"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat

"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

"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart

"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe

"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

"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.

"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email

"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

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