Export live data to Excel

To add comments, please log in or register
Forex Trader
114368
Forex Trader  
How could I export live data to Excel from MetaTrade? I would like to export Open, High, low and Close, also Vol and time to a excel worksheet.
Forex Trader
114368
Forex Trader  
You use the DDE that comes with MT4
Place these codes in individual excel cells
=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD
Change the symbol for different crosses.
You will also need to go to Tools / Options and tick the enable DDE box
Forex Trader
114368
Forex Trader  
Yes, I know that much, I mean live data that fills into cells in the excel worksheet at specified user intervals. Also the Open and Close data.
You see I need this in order to use this data in a Neural Network
Forex Trader
114368
Forex Trader  
You use the DDE that comes with MT4
Place these codes in individual excel cells
=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD
Change the symbol for different crosses.
You will also need to go to Tools / Options and tick the enable DDE box


When you say ""You use the DDE that comes with MT4", which file is that. The DDE-Sample.xls?
Do you create one file for each pair?
What do you name them?
Thanks
Forex Trader
114368
Forex Trader  
What I want is to be able to have a dynamic excel worksheet, that is one that grows with the data beeing feed by
MT4.
By the answers Im getting it seems that may be Im not making myself very clear..
I want to start the day with an empty excel sheet, as the minutes tick by, I want the values for the Day, Time, Open, High, Low, Close and Volume to appear in each row of my excel worksheet.

Is this possible?, and if not can it be incorporated in future updates?

Basically, because there are a few excel add ins that have Neural Network capabilities that can be used nicely for
system development.

thanks
Forex Trader
114368
Forex Trader  
ted 16.03.05 03:52

You just need to tick the box mentioned and the dde will run automatically when you are logged onto mt4.
This is a link to an excel workbook that I have set up that uses the mt4 dde..

Make sure you are logged into MT4 and the dde is enabled before you open the workbook.

http://www.stideas.com/download_indicator_zip_file.htm
Forex Trader
114368
Forex Trader  
Thank you very much, it lookg good let me play around and Ill get back to you
Forex Trader
114368
Forex Trader  
you can open the dde-sample of MT4 in the visual basic editor. all the calls are in there.
Forex Trader
114368
Forex Trader  

Hi,


i cannot download the file, but I'd like to do the same so I need a huge amount of data of Day, Time, Open, High, Low, Close and Volume

Forex Trader
114368
Forex Trader  
mpfx :
You use the DDE that comes with MT4
Place these codes in individual excel cells
=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD
Change the symbol for different crosses.
You will also need to go to Tools / Options and tick the enable DDE box
hello,
I wanted to export excel sheet on the symbols of the future on my MT4, es for oil symbol is: =MT4|BID!# CLH9 but excel does not accept the symbol #
What should I do?
there is an alternative solution?
thanks
Forex Trader
114368
Forex Trader  


BJF Trading Group sells the software "MetaTrader 4 DDETool "

DDETool makes it possible import any data in real time from MetaTrader 4 to third-pary software (supported DDE protocol). For example, we can import quotations (or indicator's value) from MetaTrader to MS Excel for real time analysis.



123
To add comments, please log in or register