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 am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"I was with ******* for 4 years at $230 a month, this is a huge savings for me, GOD BLESS YOU PEOPLE," - Comment from T.S. via Email
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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.
"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"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
"I just wanted to let u know that your data feed/service is by far the best!!! Your unfiltered tick data is excellent for reading order flow and none of your competitors delivers this quality of data!" - Comment from Peter via Email
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) »IQFeed 3rd Party Software Support »Some trouble with DDE
Author Topic: Some trouble with DDE (3 messages, Page 1 of 1)

Developer59
-Interested User-
Posts: 2
Joined: Sep 26, 2007


Posted: Sep 26, 2007 06:01 AM          Msg. 1 of 3
Hello,

I'am new to IQFeed and first I've a question regarding DDE:

I'am using an Open Office Spreadsheet for test, later I'll use it in my application.

When I try a syntax like '=DDE("iqlink";"system";"fitems1")' it works perfect, all items are send from DDE server and the cell is filled. Now I change the formula as follows '=DDE("iqlink";"DAX.X";"Last")' and the connection crashes, the red DDE icon is lost. What's wrong? I've also tried the same with an test environment for DDE connections, the same result.

But the Time&Sales window, thats open at the same time, shoes me the quotes and the quotes are proper updated appr. every second.

Thanks in advance
Developer59

DTN_Steve_S
-DTN Guru-
Posts: 2093
Joined: Nov 21, 2005


Posted: Sep 26, 2007 08:48 AM          Msg. 2 of 3
This sounds like the bug dealing with timezones.

Is your PC clock's timezone set to GMT+?

If so, in order to use DDE, you will need to adjust your timezone to anything GMT- (you can then adjust your clock back to the correct time for your location).

This bug will be fixed in the next release of IQFeed.


Let me know if this doesn't apply to your situation or if it doesn't help.

Developer59
-Interested User-
Posts: 2
Joined: Sep 26, 2007


Posted: Sep 26, 2007 09:53 AM          Msg. 3 of 3
Yes, my timezone us GMT +1. I'am located in Germany.

I've tried your proposal and now it works, the example spreadsheet from DTN is updating very well.

Many thanks.

When is the time that a fixed DDE server is available?

Best regards
Developer59
 

 

Time: Mon May 6, 2024 7:28 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003