In this video, you will learn about how to connect your MetaTrader software to Microsoft Excel software and view items live. You can watch Bid price, Ask price, High, Low and so on directly in a connected Excel spreadsheet.
In order to do this, you need to first launch your MT4 platform. Then find Tools->Options->Server item on the menu. Then find the Enable DDE server checkbox in this window and tick it. You need to launch the
This Excel spreadsheet is now connected to your MT4 platform. You can see the table of contents displaying values like Bid and Ask prices for some currency pairs. If you want, you can also add more pairs to this list. This is how you can use an Excel sheet to view items live for various currency pairs. Unfortunately, there isn't much you can do with it.
hi
i watched your video how to connect data to excel
thank you very much for this
is it possible to add extra columns for say moving average RSI etc
regards
ian
No, with the default built-in MT4 DDE server, you cannot. Unfortunately, MT4 DDE only exports Bid, Ask, High, Low, and Time variables for each symbol.
What you can do is to use one of the available expert advisors (that use either Windows DLL functions or a separate application) to provide more data to Excel via DDE.