PDA

View Full Version : DDE Excel Test Fail


FX42n
06-29-2006, 01:45 AM
Greetings. At the request of FXCM Technical Support, I am requesting assistance. I am using Excel 2000, with Excel 2007 Beta to edit my xml files. My PC operates on XP Home, and has 2000 Professional and 2007 Professional Beta. It also has McAfee Security Center.

My DDE VisualBasic test is successful, but my Excel DDE Test hangs, and requires Task Manager to end program. It was functioning perfectly until I added Order2Go DDE, and have experienced connection difficulties afterwards.

I would appreciate any assistance. Thank you.

FX42n
06-29-2006, 02:04 AM
Here's a strange thing....

I uninstalled the DDE through Add/Delete Programs in Control Panel, shut down my PC, and restarted; however, I forgot to remove the DDE from my startup icons, and it appeared upon restart. I added my logon info and "neptune", and tried the Excel Test again, which was successful.

Just FYI....

trendjumper
06-29-2006, 02:19 AM
Are you using the Order2GoDDE found at:
http://www.fxprogrammers.com/forum/showthread.php?t=13

And if so, where are you entering "neptune"?

FX42n
06-30-2006, 06:06 AM
Greetings, and thank you for your response. As the second post in this thread states, my DDE program works now.

I had been using the FXCM DDE named FXPS.EXE for the past couple of months without incident. On a recent thread, I read there was another DDE option - Order2GoDDE. I followed the links and installed it, and made no modifications to it. The next time I started up XP, I was unable to connect to my original DDE, so I uninstalled the Order2GoDDE, and was able to connect.

Upon restart, I found I was unable to connect again. This time I uninstalled the FXPS DDE and restarted my XP before reinstalling it. At startup, I found that it was still there, and when I logged on, I was able to connect.

------------------
Neptune refers to the "terminal" textbox on the "Dialog" form used to log into the FXPS.EXE program. The Dialog form has four textboxes: UserID, Password, URL, and Terminal. After I uninstalled the FXPS.EXE program, the URL Textbox was the only field still filled in, so I had to enter UserID, Password, and Terminal before I could attempt a login.

------------------
A side comment:
Now that there are two DDE programs offered by FXCM, I am not certain which one is better. I do not believe the FXPS.EXE program has the ability to automate orders, and I believe the Order2GoDDE does. This by itself may make Order2GoDDE superior; however, I do not know how to access the DLL file to incorporate those commands into my vba snippits, or other methods to access these commands, so really the feature is useless to me at this time.

In fact, I am still learning how to write beginner vba macros. I'm learning from "Excel VBA for Applications, Second Edition," by Webb, but these elementary exercises do not provide solutions I can use, nor explain how to write more complex snippits like the one posted by Ariva in "Close trades vba examples" http://www.fxprogrammers.com/forum/showthread.php?t=133

I am trying figure out how to apply this snippit and make it work, so I can disect it and attempt to modify it so it will update current period values and create new periods automatically. I know I probably am barking up the wrong tree with this snippit, but it's how I learn....by doing. I also realize it probably won't work on FXPS.EXE and need to switch over to Order2GoDDE to make the application work properly.

Thanks for your assistance. I really appreciate your thoughtfulness. Best of luck in your trading.