In this video, you will learn about how to connect your MetaTrader software to excel software and view items live. You can watch bid price, ask price, etc. from your excel software.
In order to do this, you need to first launch your MT4 platform. Then find tools, options items on the menu. Then find the enable DDE server in this window and select it. You need to launch the DDE-Sample.xls file inside the installation folder of your MT4.
This excel sheet now connects your MT4. You can see 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.
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.