Importing Values from Excel into MT4

Hi, I'm sorry if someone already answered this but I couldn't find it in the forum.

I'm wondering if it's possible to build an EA that would draw lines in a chart taking values from an excel spreadsheet.

In particular I would need an horizontal line drawn at the price of a cell an updated everytime the cell changes value.

is this feasible with MQL4? Someone could point out how to?

Thanks

Yes, it is feasible. One way:

In MT4, create a script to "listen" for the new price from your Excel spreadsheet using your favorite IPC method for communication. There are many different IPC methods for sending messages between apps, but named pipes might be a good choice for this task. When a new price is received, the script can draw the line at the appropriate price. There are multiple examples of this type of functionality in this forum (search for named pipes).

In Excel, write code to send the new price to MT4 via the same IPC method you used in the MT4 script. See the Worksheet.Change or Worksheet.Calculate events depending on your needs.

EXCELLINK ADDON (free)


This Addon is written to exchange data between excel and trading tools like Tradestation, Wealth-Lab and Metatrader

https://www.fx1.net/excellink.php

Thank you. I will look up on both solutions.

Regards,