Excel to Orders for MT5
Why do you need this script?
If you have lots of analyzed orders in Excel where need to be placed on MT5 , this script will be very handy and time saver for you.
All your orders are processed in seconds and your order's results are written to an output file.
How it works?
1. Prepare .xls file and save it as
Input csv structure:
- Ref no (string) [ free format unique ref no , it is up to you. ]
- Symbol (string)
- Cmd (string) [ BUY , SELL , BUY_LIMIT , SELL_LIMIT , BUY_STOP , SELL_STOP , BUY_STOP_LIMIT , SELL_STOP_LIMIT ]
- Volume (double)
- Price (double)
- Slippage (int)
- Stoploss (double) 0 (Zero):Means No Stoploss value
- Takeprofit (double) 0 (Zero):Means No Takeprofit value
- Comment (string)
- Magic (int)
- Stoploss Pips (int) 0 (Zero):Means No Stoploss value calculation
- Takeprofit Pips (int) 0 (Zero):Means No Takeprofit value calculation
- Stop Limit (double) valid for only BUY_STOP_LIMIT , SELL_STOP_LIMIT orders.
Ref no (String);symbol (string);cmd (int);volume (double);price (double);slippage (int);stoploss (double);takeprofit (double);comment (string);magic (int);slPips (int);tpPips (int);stopLimit(double)
ref101;EURUSD;BUY;0.01;0;5;1.09;1.12;my eur comment;35600;200;200;
ref102;EURUSD;SELL;0.02;0;5;1.12;1.09;my eur comment;35601;300;300;
ref103;EURUSD;BUY_LIMIT;0.01;1.1;5;1.09;1.12;my eur comment;35602;400;400;
ref104;EURUSD;SELL_LIMIT;0.02;1.12;5;1.14;1.09;my eur comment;35603;500;500;
ref105;EURUSD;BUY_STOP;0.01;1.13;5;1.11;1.14;my eur comment;35604;600;600;
ref106;EURUSD;SELL_STOP;0.02;1.09;5;1.11;1.07;my eur comment;35605;700;700;
ref107;USDRUB;BUY;0.02;0;5;0;0;this ruble ;35606;10000;20000;
Excel to Orders
script on any currently opened chart window in your terminal.
After initiating the script , your records are processed one by one and result .csv file is created in the same sub-directory of MT5
Result csv structure:
- Ref no (string)
- Symbol (string)
- Cmd (int)
- Volume (double)
- Price (double)
- Slippage (int)
- Stoploss (double)
- Takeprofit (double)
- Comment (string)
- Magic No(int)
- Stoploss Pips (int)
- Takeprofit Pips (int)
- Stop Limit (double)
- Ticket (int)
- Error Code (int)
- Error Description (string)
Last 3 columns are appended at the end of your input record.
Ref no (String);symbol (string);cmd (int);volume (double);price (double);slippage (int);stoploss (double);takeprofit (double);comment (string);magic (int);slPips (int);tpPips (int);stopLimit(double);Ticket (int);Error code (int);Error description (string)
ref101;EURUSD;BUY;0.01;0;5;1.09;1.12;my eur comment;35600;200;200;0;0;10016;Invalid stops
ref102;EURUSD;SELL;0.02;0;5;1.12;1.09;my eur comment;35601;300;300;0;0;10016;Invalid stops
ref103;EURUSD;BUY_LIMIT;0.01;1.1;5;1.09;1.12;my eur comment;35602;400;400;0;658439996;10009;Request executed
ref104;EURUSD;SELL_LIMIT;0.02;1.12;5;1.14;1.09;my eur comment;35603;500;500;0;0;10015;Invalid price
ref105;EURUSD;BUY_STOP;0.01;1.13;5;1.11;1.14;my eur comment;35604;600;600;0;0;10015;Invalid price
ref106;EURUSD;SELL_STOP;0.02;1.09;5;1.11;1.07;my eur comment;35605;700;700;0;658439997;10009;Request executed
ref107;USDRUB;BUY;0.02;0;5;0;0;this ruble ;35606;10000;20000;0;658440002;10009;Request executed
ref108;EURUSD;BUY_STOP_LIMIT;0.01;1.1443;5;0;0;my BUY_STOP_LIMIT;35607;0;0;1.1441;658440009;10009;Request executed
ref109;EURUSD;SELL_STOP_LIMIT;0.02;1.1411;5;0;0;my sell_STOP_LIMIT;35608;0;0;1.1414;658440014;10009;Request executed
3. You may open your result file
with excel to view the return codes of your order records.
Please report any bug issue or free of charge development request (firstname.lastname@example.org) upon your needs.
This is the MetaTrader 5 version, check out the MetaTrader 4 version at Verdure Community Balance Alert. Overview With Verdure Community Balance Alert, you will get notifications (alert, email or push notification on mobile terminal) of credit and debit transactions on your MQL5.community account. You get up to date account status on the move wherever you may be. It helps you to treat your MQL5.community account like your bank account. You can also set threshold alerts as you would on your ban
VR Orders History MT5 is a professional script for downloading trading history in the csv format (EXCEL). This universal script can run both on hedging and netting accounts. The script divides the report into two stages: The first stage includes existing current positions and deals, which have opened these positions. The second stage includes historical positions and associated deals. VR Orders History MT5 can download the trading history of any financial instrument (currency pairs, CFDs, Future
This is the 60-seconds free demo version of Easy Chart Shifter. You can find the full version on: https://www.mql5.com/en/market/product/49695 Easy Chart Shifter (60-sec demo version) This indicator is made to make the moving the chart easier. By it, you can simply drag the chart in all 4 directions using the mouse. If you monitor is touch screen, you can use pen or finger also. You can shift the chart in both vertical and horizontal directions, using the mouse/pen/finger (for touch monito
A script for quick reversing positions and/or orders. If you need to reverse a position with the same volume, open an opposite position of a different volume, this script will save you from routine! Allow AutoTrading before running the script. Instructions: Run the script on the chart. This script is a limited version of the market product https://www.mql5.com/en/market/product/638 and allows reversing only positions. Input parameters are not required. Parameters such as changing the type of exi
The SynchroCharts utility allows to simultaneously view quotes history on multiple charts by synchronizing charts by time and timeframe. After starting, the utility creates a dashboard on all charts: ÷ - allows to enable/disable the display of the crosshair on the current chart; ∞ - enable/disable synchronous display of the first visible bar of the current chart with the main one. The timeframes of the charts are also synchronized. Settings: Speed refresh - The refresh rate of the charts: th
Script for quickly selecting a tool with high correlation. The script is placed on the tool to which you need to select the second correlating one. Then you can change the number of bars to calculate and the timeframe. The script iterates through all available symbols in the market overview and returns the 20 most correlated ones. You can use the selected pairs to trade with THE new SH expert Advisor
This is a useful script allowing to receive the following data: Short names of indicators (INDICATOR_SHORTNAME) which are currently running in all open charts of the trading terminal; windows/subwindows where the indicators are located (0 means the main window of each chart); the total number of indicators in currently open charts of the trading terminal; timeframes, symbols and IDs of charts and "Chart" graphical objects, which are currently open in the trading terminal; the total number of ope
Smart AutoScroll utility is designed to improve the standard functions of the terminal auto-scrolling. By default, the chart is automatically moved to the current prices when a new tick arrives. This may be inconvenient when browsing the history. The utility corrects this inconvenience. If you start to view the history, the software will automatically disable the auto-scroll function. If you scroll the chart to the current prices again, the auto-scroll will turn on automatically.
Presentation The URL html and xml to csv is designed to get contents from URLs with html or xml content, and to download it to an output format as a txt or as a csv file. It enables to get the whole web sites page, starting with the http protocol, in a document for a further use and in additional with downloading directly on the MetaTrader applications and on the desktop. It is a good advantage for taking the most data from events and economic calendars, and also publications related to the inst
this EA is mainly designed for manual traders. you can buy long and sell short with the preset Lots percents.You can also close all orders just by clicking a button. The great advantage about this EA is that you will fullly trade just by arrows and color which are offered by inside indicator! so come to enjoy it ! you will find it to be a very useful tool for your trading!
The ZoomIN MT5 indicator is designed for quickly viewing the selected bar on the smaller timeframes in a pop-up window. Once launched, the indicator works in the background, does not take up space on the chart and does not consume system resources. When the indicator is activated by the Shift + i combination (can be changed in the settings), a pop-up window with a chart of a smaller timeframe is created. The displayed timeframe can be changed by a left-click on the magnifying glass icon. To hide
This indicator is especially for the binary trading. Time frame is 1 minutes and exp time 5 or 3 minutes only. You must be use martingale 3 step. So you must put lots size is 10 % at most. You should use Mt2 trading platform to connect with my indicator to get more signal without human working. This indicator wining rate is over 80% but you may get 100% of profit by using martingale 3 step. You should use MT2 Trading Platform to connect meta trader platform and binary platform . You can get mt2
Risk Optimizer is the absolute solution for applying risk management on your account. Bad risk management is the main reason that causes traders to lose money. Risk Optimizer calculates and suggests the correct lot size for each position according to your personal, customized risk profile. You can give directly your preferred risk as percentage (%) for each position or you can trust our algorithms to calculate and optimize according to your risk category selection. But it is not only that! Selec
这是一个MT5的脚本，帮助把交易记录按照品种分类统计。 参数 Select Period: 这是7个选项的参数，分别是上个月，本月，上周，本周，今天，指定日期。 Specify Starting Date: 输入一个起始日期，如果上面参数你选择的是指定日期的话。 Specify Ending Date: 输入一个截止日期，如果上面参数你选择的是指定日期的话。 如果参数Select Period 选择的不是 指定日期，那么后面的两个参数就不用填写了。 脚本会有一个文件输出结果，文件保存在MQL5\Files文件夹中。 希望对你有帮助，真心希望对你有帮助，我觉得会有帮助。 必须满足300个字，我必须说些废话，好了好了，希望对你有帮助。
This utility provides the ability to use hot keys in manual trading instantly responding to the current market situation. You can assign hot keys to open/close positions by their type, open/close all positions on the current chart and remove all orders on the current chart. You can also assign hot keys for five predefined trade volumes and switch between them if necessary with no need to change the volume manually from time to time. It is also possible to set the auto calculation of a trade volu
This tool makes the standard Auto-scrolling feature of the terminal more convenient to use. In the standard version, if the auto-scrolling is enabled, you cannot scroll the chart back, as it returns to the start with every new tick. To do it, you need to disable auto-scrolling before moving the chart. This tool automatically disables auto-scrolling if you start moving the chart to view the price history. And if you move the chart to the start, to the new prices, it will turn on the auto-scrollin
Color your charts with the most beautiful set of predefined color schemes. You can choose to color a single chart or all open charts. This script will color your charts - neither more nor less. All existing chart settings will be left untouched. Color Schemes Blueprint Coup de grâce Curiosity Killed Gamebookers Peppermint Ruby Blue TradeStation
The panel displays the following parameters for open positions: Symbol - symbol name Positions - total number of positions on a symbol calculated as a sum of BUY and SELL positions Volume - total volume of positions on a symbol calculated as a sum of BUY and SELL position volumes Buy Volume - volume of BUY positions on a symbol Sell Volume - volume of SELL positions on a symbol Profit - total profit of positions on a symbol calculated as a sum of BUY and SELL position profits Buy Profit - pro
This indicator is designed to provide all useful information about symbol, account, positions and profit. It is developed for improving trader's money management. Parameters Calc can be divided to separate blocks. Each block is possible to hide, set its own color and other properties. Block symbol: This block displays information about actual SPREAD, POINT VALUE (in deposit currency for 1 lot), SWAP LONG and SHORT. Show symbol info - display/hide this block Color of symbol info - color of this
This is a free order dashboard tool designed for popular No Nonsense Forex (NNFX) strategy traders on MT5. The BUY, SELL buttons will create trades with SL and TP that are based on ATR. Lot size is based on the % of the balance. All these are customizable under settings. CLOSE button will close all trades. P/CLOSE will partially close the trades and move the SL to Breakeven. It also features EURO FX VIX which is automatically updated from barchart.com. You can specify when you need to update i
Overview The script displays information about the trade account: Information about the trade account: Account - account number and type (Real, Contest or Demo); Name - name of the account owner; Company - name of a company that provide the access to trading; Server - trade server name; Connection State - connection state; Trade Allowed - shows whether trading is allowed on the account at the moment; Experts Allowed - shows whether it is allowed to trade using Expert Advisors; Balance - account
The Zoom indicator allows you to see the price behavior inside a selected bar. By moving a vertical line on the indicator chart, the selected bar will be displayed as a rectangle on lower time frame charts of the same symbol. For example, you can add the Zoom indicator to the daily chart. In external parameters, you can only set the color of the vertical line ( Line Color ) and the color of the rectangle ( Area Color ). The second chart window must be open on a lower time frame. It can be any ti
Simple yet effective one-click trading panel with adjustable lot size, stop loss and take profit. You can adjust yourself where it is placed on the chart by adjusting the x-axis and y-axis. On a 5-digit broker, the StopLoss and TakeProfit values are set in points, not in pips. Inputs LotSize : minimum lot size of 0.01 StopLoss : make sure your symbol and spread allows the value. TakeProfit : make sure your symbol and spread allows the value. XAnchor : positioning on the chart from right to lef
This utility displays the name of the current symbol and the current period in the chart background in a large font. It is a very convenient visualization function, e.g. when you use multiple charts with different symbols, period or when saving a chart screenshot. The information is displayed in two lines. In the first line, the chart symbol and current timeframe are shown in a larger font (e.g. AUDUSD,h1 ). In the second line, the full name of the current symbol is displayed in a smaller font (
Export Deals to CSV - Excell File location: HistoryDeals/<SERVER>/<LOGIN>.<DATETIME>.csv Works as an Script, reading all DEALS in history and exporting it as a plain text CSV file There's no option to change. There's no WebRequest. There's no DLL use. I need to write 300 characters to allow this product being exposed at MQL5 market place. It's simple to use, plug it in graph and wait completion.
这是 EasyPen 的演示版本。它被设计用于，以漂亮、创新的方式来创建和管理您的所有图表分析，随笔，注解以及更多。该应用得益于新的 MQL5 所提供的在其它旧版 MQL 中从所未见的技术。 一款应用改变所有。 目前没有存在的绘图应用，可以达到 EasyPen 的定制水准。改变画笔颜色, 选择笔刷大小, 保存绘图, 保持绘图在指定位置和图表, 以及更多。利用超过 210 种颜色和 6 个笔刷大小, 您可以制作您希望看到的任何事物。 简洁与功能性 EasyPen 是漂亮和易用的。界面简洁、直观，但在其温柔外表的背后，EasyPen 可产生强大生产力冲击！用画笔来表达您自己, 可定制多色彩和线宽。 特点: 在图表上绘图; 使用 "填充" 功能改变大型区域颜色; 在图表上添加您喜好的指标, 并在它们之上绘图; 希望更大 - 滚动您的图表并继续绘制。您之前的绘图将被加载到图表上，并且不会消失; 通过鼠标在屏幕上点击，简单的删除; 保存您的绘图，并在以后出示给您的朋友; 选择您希望的任意颜色 - 此处有它们的全部; 选择 6 个不同的笔刷大小; 平滑和快速绘图; 独立背景色。 EasyPen 提
This is a simple utility which displays an amount of RAM required by the terminal. It also displays the version of the terminal, memory volume, which potentially can be occupied by the terminal, and total amount of available memory. Volume of potentially available memory for x64 version of the terminal amounts to 128 TB. Nevertheless a real memory volume, which can be used, depends on the amount of real and virtual memory available for the system (it is impossible to calculate this value).
The TradeHistoryParsing is a utility for working with the trade history obtained from the MetaTrader 5 terminal. The product is based on the " RegularExpressions in MQL5 " library. It allows to quickly get the required data on your trading history. The filtering results are displayed as a table, a summary of mathematical statistics is provided below the table. Working with the tool Export the trade report as an html file and place it into the "sandbox". After that, when launching the EA, speci
The simple solution for quickly trading operations and controlling positions on multiple trading symbols. The panel interface is simple and intuitive. For a comfortable trader's work, the panel includes: the hotkey manager to help you manage all trade operations and chart timeframes; built-in MultiCharts indicator for monitoring multiple trading symbols and generating trading signals; overview of trading statistics for any period of time, as well as various useful information about the trading s
The Quick Style utility is designed for facilitation and acceleration of working with the properties of graphical objects. Left-click a graphical object while holding the Shift key to open the quick access window for configuring the object properties. In the window, you can change the color, style and line width with one click, including those of other graphical objects. All changes are displayed immediately. To close the Quick Style , simply click the free space on the chart. The utility is eas
2. New <Stoploss Pips> field is added. Stoploss value can be calculated with this field unless it is not ZERO.
3. New <Takeprofit Pips> field is added. Takeprofit value can be calculated with this field unless it is not ZERO.
4. New 2 order types are added namely BUY_STOP_LIMIT and SELL_STOP_LIMIT.
4. New <Stop Limit> field is added which can be used for only in BUY_STOP_LIMIT and SELL_STOP_LIMIT orders.