|
|
Home
Search
Register
Login
Recent Posts
»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 |
|
|