How to Connect MetaTrader 4 to Excel

Connect MT4 to Excel using DDE

Today we will be connecting MT4 to Excel with DDE in 4 easy steps. The Excel DDE link will enable you to see the live Bid, Ask, High and Low prices all within your Excel sheet. 

1.

Open MetaTrader 4. Ensure you are logged in to your account, then click on the tools > options.

2.

Ensure "Enable DDE Server" is checked.

3.

Navigate to the installation folder where your version of MT4 is installed. Right click on your MT4 shortcut and click "Open File Location" to get to the folder.

4.

Open the DDE-Sample Excel file. When prompted by Excel, click on the "Update" then "Ok" buttons.

Changing the Forex pairs

You can change the Forex pairs by simply changing the currencies in the equations. =@MT4|BID!EURUSD =@MT4|ASK!EURUSD =@MT4|HIGH!EURUSD =@MT4|LOW!EURUSD

Want to Execute and place MT4 orders from the Trading Panel in Excel? Check out MexcelTrader today!

© 2024 MexcelTrader. All rights reserved