Help ! How To Combine Two Dde From Two Different Brokers?

Hello All,

I need the information on how to combine two DDE from two different brokers.
What I mean is like this :

1. Supposed that I am using Interbankfx and Alpari as my broker so I need to collect their live quotes in an Excel File. For example, I need to calculate the average price of GBP/JPY of those two brokers automatically in excel.
That would be easy to be done in excel if I have one row contains live quotes from Alpari, and another row contain live quotes from Interbankfx.
All I need to do is just make another row to sum up those two rows and divide it by two, so I will get the average.

2. The problem is, I have tried using the DDE-Sample.xls file and It read from the same source although I have opened Interbankfx and Alpari on the same time. For example, both the DDE-Sample.xls file read only from Alpari data, not from Interbankfx (although the file I am opening is from different folder, from Alpari Folder and Interbankfx folder). To be able to open the excel files at the same time, I just renamed the other file to DDE-Sample1.xls, the other file still remain DDE-Sample.xls.

3. Is this problem because the syntax of the DDE : MT4|BID!GBPUSD
The "MT4" doesn't care which broker's terminal is open and it seems that he just choose the broker to connect randomly.

Is there a way to solve this problem? Because actually I need to collect more than just two brokers, if possible I want to collect 5 brokers DDE data at the same time and calculate its average.

Thank You

If I correctly recall the inner workings of DDE, the last app to register itself as "MT4" is the one you're going to be pulling data from. My guess is that the functionality you're looking for is beyond what you can get with DDE. You might be looking at a dll (or poor man's option, writing to text file).

I could be wrong about the DDE thing, but that's my recollection.

Thanks for your reply, but could you please tell me which dll file I must change in order to get the right data? for example, for this file I will point to the DDE Server of Alpari, while for the other file I will point to the dde server of Interbankfx?


How can we check which file has a function to register the MT4?

Thanks

I think he means that you're going to have to create a dll file that pulls that information for you, but will pull both servers at once and dump them out together into your xls file.

do you want to help me to give the example how to make a dll file with a function like that? I almost stress to think how to make it?

Thanks