VR Order History trading report in Excel

Review

The VR Orders History script is designed to upload a trade report to a csv file. This format is intended for additional analysis of trading history in programs such as EXCEL, Openoffice, and Libreoffice. Thanks to the script, it is now much easier for a trader to analyze their trading history.

The program facilitates the analysis of the trading history for the MetaTrader 5 terminal. The trader sees structured trading. The entire report is based on the following principle: Position > Order on the basis of which the position was opened > Transaction on the basis of which the position was opened.

In the report created by the script, the trader can see the hidden fees, the prices at which the position was requested to open, and the real price at which the position was opened. The report also displays information about the replenishment of the balance and other non-trading transactions.

The program settings allow you to filter trading operations by a financial instrument, by a Magic number, and by the period of a trading transaction.

The program was written to facilitate the understanding and analysis of the trading process in MetaTrader 5. This is why the report for MetaTrader 5 differs from the report for MetaTrader 4. The architecture of trading orders in MetaTrader 5 has a more complex structure than the architecture of MetaTrader 4.

You can download an example report here.

Advantages

Additional analysis of your trading history will help you:

• Avoid making blunders in the future
• Identify the most profitable trading instruments
• Create a heat map of the successful trading time
• Analyze the trading history in external analyzers
• Calculate profits, losses, and volumes for selected instruments, expert advisors, and trading tactics

Algorithm of operation

The program is placed in the Scripts folder. After restarting the terminal, the program will be displayed in the terminal navigator.

Run the script on the chart, specify the desired report settings, and click run.

The script will analyze the trading history and create a file with the name of the trading account in the files folder.

You can find the report by following these steps:

1. In the terminal, click on "File"
2. Next, "Open the data directory"
3. Next, MQL4 or MQL5
4. Next, the Files folder

Profitability

The script does not trade automatically, so the yield depends on the knowledge and skills of the trader.

Recommendations

• Use the script for additional analysis of the trading strategy in programs such as EXCEL, Openoffice, and Libreoffice.
• Use the script to get the trading history from managers.

Settings

• Show Display

• History Start Date - enter the start date for the trading history.
• History End Date - enter the end date for the trading history.
• Symbols (EURUSD GBPUSD) - enter the names of the financial instruments for which you want to get reports, separated by a space, or leave the field empty to get the entire trading history.
• Magichest numbers (227 2365 4598 456113) - enter the magic numbers that you want to get reports for, separated by a space, or leave the field empty to get the entire trading history.
• Show Display
• Show positions - displays positions in the report
• Show orders - displays orders in the report
• Show trades - displays trades in the report
• Recent orders, transactions, positions - displays the specified number of recent transactions at the end of the report
• Show columns
• Column - in columns, you can choose what to display in a column in the report

Video

Updates

Planned

At the moment, there are no further development plans. You can make your suggestion in the comments section below.

What's in the archive

For MetaTrader 4

• VR-Order-history-RU.ex4 - Russian program file
• VR-Order-history-EN.ex4 - English program file

For MetaTrader 5

• VR-Order-history-RU.ex5 - Russian program file
• VR-Order-history-EN.ex5 - English program file