DDE link to Excel 2007 problem | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Excel hangs with MT4 DDE Link 14 replies

Stalling of Excel when using DDE 1 reply

DDE Excel 2007 17 replies

MT4 DDE for Excel 2007 1 reply

Excel DDE interface 1 reply

DDE link to Excel 2007 problem

  • #1
  • First Post: Sep 13, 2011 12:51am Sep 13, 2011 12:51am
I have searched but found no solution so any help would be appreciated.

Trying to get DDE links to update in XL
Security warning asks to enable links ... when I do that then XL hangs and has to be restarted. Simply cannot get it to work!!

I assume it is some security setting in XL but cannot find it??
OR how do I set up a new data source??

Have used the DDE Sample file but that does not work either (so it is not my link syntax.
Tried ='MT4'|BID!GBPUSD and =MT4|BID!GBPUSD (neither work)

I assume that DDE still should work in XL 2007 ?
If you think I'm mad, I must be mad
  • #2
  • Sep 13, 2011 1:56am Sep 13, 2011 1:56am
Not sure what you meant by security warning; you should be very specific. I can't imagine its a Excel version problem.

Anyway, I will take a guess. In MT4, DDE has to be enabled. You do this on the Options menu choice under Tools. There is a flag on the Server tab for DDE. You may have to restart MT4 and Excel for this to take effect.
  • #3
  • Sep 13, 2011 2:04am Sep 13, 2011 2:04am
DDE is definitely enabled.

Have set to enable automatic data updates in XL and the book will then not open ... just hangs.

If remove the automatic enable links then when open the workbook it gives "Security Alert" and when I click on enable links the XL just hangs and I have to restart the program??
If you think I'm mad, I must be mad
  • #4
  • Sep 13, 2011 10:51am Sep 13, 2011 10:51am
Finally !!!

Pinned it down to a conflict with Google!!!!!!!!!!!!!

If anyone could shed any further light on what in particular is causing the conflict and how to prevent it I would be forever grateful :-)
If you think I'm mad, I must be mad
  • #5
  • Sep 13, 2011 10:59am Sep 13, 2011 10:59am
I had the same problem and found that starting up Excel prior to Google helped. Or use an alternative browser - I think Opera worked OK, though I haven't used that workbook for a while now...
  • #6
  • Sep 13, 2011 11:01am Sep 13, 2011 11:01am
I have the same problem before, this happened when i using import data > from web that can automatically refresh every 5 minutes. Then i just use xml map at developer menu using rss feed. So far no data problem.
  • #7
  • Sep 13, 2011 11:12am Sep 13, 2011 11:12am
Thanks guys ... wished you had chipped in with that earlier! ... the swear box is overflowing ;-))

Merlin ... not entirely understand what you mean (xml / rss feed) ... can we do that in XL and does it work for the DDE link (Live data link)

And yes Google loaded after XL file appears to be working.
If you think I'm mad, I must be mad
  • #8
  • Sep 13, 2011 11:36am Sep 13, 2011 11:36am
Ya, u can get rss feed from a website that provide rss feed format. Using xml u can get the data especially news to your excel. Besides u can combined DDE data from mt4 & xml together in one page. Therefore u can view a live price thru DDE & news or whatever u map together. Here's an example :

http://freepixload.com/images/1ada.jpg

http://freepixload.com/images/3qpq.jpg
  • #9
  • Sep 13, 2011 11:43am Sep 13, 2011 11:43am
Thankyou.

Will I ever keep up with all this technology??

The marvels of modern science and just to think that I was created with simple DNA ;-))
If you think I'm mad, I must be mad
  • #10
  • Sep 13, 2011 11:53am Sep 13, 2011 11:53am
I learn from Youtube...hah
  • #11
  • Sep 13, 2011 1:52pm Sep 13, 2011 1:52pm
Quoting merlintrade
Ya, u can get rss feed from a website that provide rss feed format. Using xml u can get the data especially news to your excel. Besides u can combined DDE data from mt4 & xml together in one page. Therefore u can view a live price thru DDE & news or whatever u map together. Here's an example :
I have imported data before, but I didn't know about the RSS...thanks for posting that.
  • #12
  • Mar 4, 2012 11:56pm Mar 4, 2012 11:56pm
Quoting merlintrade
Ya, u can get rss feed from a website that provide rss feed format. Using xml u can get the data especially news to your excel. Besides u can combined DDE data from mt4 & xml together in one page. Therefore u can view a live price thru DDE & news or whatever u map together. Here's an example :

http://freepixload.com/images/1ada.jpg

http://freepixload.com/images/3qpq.jpg
Hello Merlin, I can't see the attachments you posted. Could you email to me. I will PM you
  • #13
  • Last Post: Mar 4, 2012 11:58pm Mar 4, 2012 11:58pm
Quoting merlintrade
I have the same problem before, this happened when i using import data > from web that can automatically refresh every 5 minutes. Then i just use xml map at developer menu using rss feed. So far no data problem.
I can't PM you because I am junior member. Can you email me at [email protected]. Thanks
0 traders viewing now