Importing Values from Excel into MT4

thread: Importing Values from Excel into MT4

  1. #1
    Junior Member javier03bcn's Avatar
    28

    Importing Values from Excel into MT4

    Hi, I am sorry if somebody already answered this but I could not find it in the forum.

    I am wondering if it's possible to construct an EA that will draw lines at a chart taking values from an excel spreadsheet.

    In particular I would require an horizontal line drawn at the price of a cell an upgraded everytime the cell modifiions worth.

    Is this viable with MQL4? Someone could point out the way to?

    Due

  2. #2
    Junior Member soyjoram's Avatar
    9
    EXCELLINK ADDON (free)


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

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

  3. #3
    Junior Member javier03bcn's Avatar
    28
    Thank you. I'll appear on both options.

    Regards,

  4. #4
    Junior Member Kavalieri's Avatar
    21
    Specifically I would need a flat line drawn in the price of a mobile an updated everytime the cell modifiions worth.

    Is this feasible with MQL4? Someone could point out to?
    Yes, it's possible. 1 way:

    In MT4, create a script to listen for the new price from your Excel spreadsheet using your favourite IPC method for communiion. There are many different IPC methods for sending messages between apps, but pipes may be a fantastic selection for this task. When a new price is obtained, the script may draw the line in the appropriate price. There are multiple examples of the type of functionality in this forum (search for named pipes).

    In Excel, write code to deliver the new price to MT4 through precisely the exact same IPC method you employed in the MT4 script. See the Worksheet.Change or even Worksheet.Calculate occasions depending on your needs.

  •