DDE Excel 2007 | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Connecting two Metatrader to Excel with DDE ? 22 replies

DDE link to Excel 2007 problem 12 replies

Stalling of Excel when using DDE 1 reply

MT4 DDE for Excel 2007 1 reply

Excel DDE interface 1 reply

Attachments: DDE Excel 2007
Exit Attachments

DDE Excel 2007

  • #1
  • First Post: Feb 20, 2008 2:26am Feb 20, 2008 2:26am
I'm trying to get the DDE link to work with Excel 2007.
The code " =MT4|BID!EURUSD " isn't really working for me.
The "enable DDE" is on in MT4.

Is this an Excel 2007 thing, or what am I doing wrong here? How do I fix this?
  • #2
  • Feb 20, 2008 3:09am Feb 20, 2008 3:09am
look just above the spreadsheet. There will probably be a security warning: Update of Links has been disabled. Click options and then enable this content. Should start working for you. I am using 2007 also.
  • #3
  • Feb 20, 2008 1:30pm Feb 20, 2008 1:30pm
Quoting magnumfreak
look just above the spreadsheet. There will probably be a security warning: Update of Links has been disabled. Click options and then enable this content. Should start working for you. I am using 2007 also.
Well not really. I'm building the spreadsheet myself. And when I enter =MT4|BID!EURUSD , I just get a plain error msg :

The formula you typed contains an error.
  • #4
  • Feb 20, 2008 1:44pm Feb 20, 2008 1:44pm
Ok I fixed it...

I just had to put ' ' around MT4.. as in

='MT4'|BID!EURUSD
  • #5
  • Jun 4, 2008 9:21am Jun 4, 2008 9:21am
Does anyone know how to get this to work with multiple MT4 brokers? I want to have 2 sets of data in my Excel spreadsheet.

Thanks,


Frank
  • #6
  • Jun 4, 2008 4:15pm Jun 4, 2008 4:15pm
This is becoming my standard answer to lots of questions: use work files. I doubt you can rename the MT4.exe on one install and have it all work right. Anyway, work files are better than DDE because you can get history.
  • #7
  • Jun 4, 2008 4:41pm Jun 4, 2008 4:41pm
What are "work files" or where can I get more info on them? I don't claim to know that much Excel, but I haven't heard of them yet.If they are as good as you say there are, I'd like to test them as well and use those from now on instead of DDE.
  • #8
  • Edited 4:55pm Jun 4, 2008 4:51pm | Edited 4:55pm
Two products:
MetaTrader: Look in some of the indicators that do file writes. That way you save the data history for as far back as you want. There are good examples in these threads.
Excel: You will have to learn a little VBA (Visual Basic for Applications) that runs as an Excel macro. Open the VB editor and get help on Read, Print, etc. There are examples for reading files.
You can still use DDE to fire events or you can use a timer to do re-calcs. (I don't have ver 2007, but I think it has a timer.(?)).
ps: What time frame data do you want to collect? (1-minute, 5-min, 1-hr, daily, etc)???
  • #9
  • Jun 4, 2008 5:06pm Jun 4, 2008 5:06pm
Thank you.I'll do what you suggested.
  • #10
  • Edited 5:10pm Jun 4, 2008 5:08pm | Edited 5:10pm
One question I should have asked first: Do you need real-time data? If not, just use the data export function.
ps: If you need an indicator to pull the data I have one close to that I can modify - let me know.
ps2: Two sets of data - what exactly? Does it have to be from two different MT4s?
  • #11
  • Jun 7, 2008 10:00am Jun 7, 2008 10:00am
Quoting Kenz987
One question I should have asked first: Do you need real-time data? If not, just use the data export function.
ps: If you need an indicator to pull the data I have one close to that I can modify - let me know.
ps2: Two sets of data - what exactly? Does it have to be from two different MT4s?

I have been trying to do the same, but with no success.
I want to have tick data from two MT4 brokers linked to one Excel sheet at the same time to compare the timing difference.
It is pretty easy to use DDE to connect to Excel, but only from one Metatrader platform.

Any advise would be appreciated.....maybe someone has a DLL with instructions to do this........I am not a programmerhttp://www.forexfactory.com/images/icons/icon8.gif
Anything worth doing, is worth doing well....
  • #12
  • Jun 7, 2008 11:37am Jun 7, 2008 11:37am
Hello Ben: Writing a DLL is beyond me. I do simple stuff. I have an indicator that will log tick data to a csv file. You can run it on two separate MTs at the same time and collect the data. Then later load those two separate csv files into excel and do the time comparisons. Not real time, but if you just want to do some historical testing it will work. If you are looking for something that will work in real time so that you can be the first in on a news release then I don't know of a way to be that fast. Even if you have excel read the tick data every 5 seconds that is still too slow on news (I think?). Let me know if you want it. Ken.
  • #13
  • Jun 7, 2008 11:56am Jun 7, 2008 11:56am
Hi Ken, thanks for your reply.
Actually, I have heard that some brokers have a delayed feed (some seconds) compared to real pass through brokers, and I want to try and find a slow broker using this method. It's the only way I could think of.
Any ideas?
Anything worth doing, is worth doing well....
  • #14
  • Jun 7, 2008 12:43pm Jun 7, 2008 12:43pm
Here is the ind, thanks to the original author komposter on ru site. I have another idea for you. Modify your profile so I can send you an email. Thanks. Ken.
Attached File(s)
File Type: mq4 LogTickData.mq4   3 KB | 1,458 downloads
  • #15
  • Jun 7, 2008 12:51pm Jun 7, 2008 12:51pm
Thanks for the indi, you can mail me now.
Anything worth doing, is worth doing well....
  • #16
  • Aug 18, 2008 3:51am Aug 18, 2008 3:51am
Quoting magnumfreak
look just above the spreadsheet. There will probably be a security warning: Update of Links has been disabled. Click options and then enable this content. Should start working for you. I am using 2007 also.
I am not so good at software. Can you please advise how to get MT4 data into Openoffice Calc using what kind of syntax. I am attaching a link for the tutorial on using DDE in Openoffice Calc but I am not able to make out how to go about it.

http://user.services.openoffice.org/...hp?f=75&t=3294
  • #17
  • Sep 24, 2009 9:27pm Sep 24, 2009 9:27pm
Hi Everyone

I used this indicator to get some dummy data for a couple of currency pairs.

I would have expected the size of the data files to be same because they should be getting tick data regularly. However the file sizes are different, some 10x bigger than others. Considering the indicators were all opened at the same time I would expect them to be the same size.

Also the tick data has multiple entries for the same time stamp. Not sure why.

The million dollar question is, Is this because
I am using dummy data, OR
multiple indicators cant write that much data reliably
OR
something else. Disk write speed, internet connection.

Would the file sizes be the same if I used a live server?

Any help much appreciated as its causing havoc with my strategy tester.

Cheers

Sam
  • #18
  • Last Post: Apr 15, 2010 5:25am Apr 15, 2010 5:25am
Quoting Skyhr
I'm trying to get the DDE link to work with Excel 2007.
The code " =MT4|BID!EURUSD " isn't really working for me.
The "enable DDE" is on in MT4.

Is this an Excel 2007 thing, or what am I doing wrong here? How do I fix this?
Sorry I know this is an old thread and I'm still looking for a solution, I can only get it to work with excel 2003 workbook not with 2007. I see that the 2003 excel does bring a security tab out but not for 2007 so I don't really know why?

One more question, does anyone know how to separate the data for each candle, for example the HL of the 5 min candle and then the HL of the 15 min?

Thanks
0 traders viewing now