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
125
PaulDawidowicz 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
100
mpfx 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
125
PaulDawidowicz 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
2
ted 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
125
PaulDawidowicz 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
100
mpfx 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
125
PaulDawidowicz 2005.03.16 07:53 
Thank you very much, it lookg good let me play around and Ill get back to you
avatar
44
ernst773 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
1
Bicskey 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
1
aabye 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
44
Alexac04 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  
Download MetaTrader 5 (450 Kb, web installer) — a new terminal for financial markets