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

Help with importing data into Excel Spreadsheet...


Back to topics list
avatar
15
ChrisAdams 2006.10.16 21:48 
Hello:

Could someone tell me how to automatically import MT-4 data (using DDE Server) into excel. Each day I would like import the 5:00 PM ET "Opening" Price (which I believe would be the 21:00 open in the MetaQuotes version of MetaTrader) for the following currency pairs: EUR/USD, GBP/USD, AUD/USD, NZD/USD, USD/JPY, USD/CHF, and USD/CAD. Each currency pair would have a single field in the excel spreadsheet (the 21:00 "open price") that I would like to automatically fill each day with their respective prices. Any help would be appreciated. Thanks.

Chris

avatar
4
IanSmith 2006.11.15 07:27 
Recent builds of MetaTrader come with an example. The filename is DDE-Sample.xls

email ian at bestforextools dot com if you have questions or need the file.
avatar
2
Mukesh888 2006.11.26 08:17 
Ian,

How do we get previous day's OHLC into excel ?

Thanks.
Mukesh

avatar
17
soniabvc 2009.06.12 19:21 
You can export indicators and prices from MT4 to Excel and execute orders from excel to several MT4s + other cool staff. It is explained here www.fxdialogue.com.
Back to topics list  
Download MetaTrader 5 (450 Kb, web installer) — a new terminal for financial markets