• Información general
  • Comentarios (2)
  • Discusión (4)

Excel to Orders

Why do you need this script?

If you have lots of analyzed orders in Excel where need to be placed on MT4 , this script will be very handy and time saver for you.

All your orders are processed in seconds and the your order's results are written to an output file.


How it works?

1. Prepare 10 columns .xls file and save it as

...MQL4\Files\Excel_to_Orders.csv

Input csv structure:

  1. Ref no (string) [ free format unique ref no , it is up to you. ]
  2. Symbol (string)
  3. Cmd (int) [ BUY ( 0 ) , SELL ( 1 ) , BUYLIMIT ( 2 ) , SELLLIMIT ( 3 ) , BUYSTOP ( 4 ) , SELLSTOP ( 5 ) ]
  4. Volume (double)
  5. Price (double)
  6. Slippage (int)
  7. Stoploss (double)
  8. Takeprofit (double)
  9. Comment (string)
  10. Magic (int)


2. Run

Excel to Orders

script on any currently opened chart window in your terminal.

After initiating the script , result .csv file is created in the same sub-directory of MT4

...MQL4\Files\Excel_to_Orders_Results.csv

Result csv structure:

  1. Ref no (string)
  2. Symbol (string)
  3. Cmd (int)
  4. Volume (double)
  5. Price (double)
  6. Slippage (int)
  7. Stoploss (double)
  8. Takeprofit (double)
  9. Comment (string)
  10. Magic (int)
  11. Ticket (int)
  12. Error Code (int)
  13. Error Description (string)

Last 3 columns are appended at the end of your input record.


3. You may open your result file

...MQL4\Files\Excel_to_Orders_Results.csv

with excel to view the return codes of your order records.

Please report any bug issue or free development request (volkanyurci@gmail.com) upon your needs.

fishwife
14
fishwife 2019.08.07 15:00 
 

Works great - just what I was looking for to quickly transfer my orders from excel to MT4. Thanks for providing this

Matthew Todorovski
12790
Matthew Todorovski 2018.06.16 11:19 
 

El usuario no ha dejado ningún comentario para su valoración