This forum is in read-only mode now. You may discuss your questions on forums of MQL4.community and MQL5.community

Export live data to Excel


Back to topics list  | 1 2
avatar
Trader 2005.03.15 06:13 
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.
avatar
Trader 2005.03.15 07:48 
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
avatar
Trader 2005.03.15 14:44 
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
avatar
Trader 2005.03.16 03:52 
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
avatar
Trader 2005.03.16 06:11 
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
avatar
Trader 2005.03.16 06:52 
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

avatar
Trader 2005.03.16 07:53 
Thank you very much, it lookg good let me play around and Ill get back to you
avatar
Trader 2005.03.16 10:45 
you can open the dde-sample of MT4 in the visual basic editor. all the calls are in there.
avatar
Trader 2008.10.28 16:15 

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

avatar
Trader 2009.01.26 02:40 
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
avatar
Trader 2009.01.26 20:37 


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.



Back to topics list   | 1 2