Sometimes you need to do a thorough analysis of orders with additional tools (besides the terminal), such as Microsoft Excel. It is great for filtering and sorting your trades in rows and columns, can also help build a profitability schedule, drawdown, find out the total deposit, check the warrants for the magic number, identify the weaknesses and strengths of your system.
The DaVinci From History To File script will record information about your closed orders, top-up/withdrawals, or pending orders in a .csv file. This format refers to and opens through Excel files.
Also, the script will check for you whether the trading history is fully deployed, and if not, with WinAPI it will fully display (you need to allow in the settings import DLL) to record the results correctly.
|File Name||The name of the file where the script will work.|
|Write Swap||Write down the data about the paid swap in the file.|
|Write Comission||Write down the broker’s commission data.|
|Write Comment||Record orders comments|
|Write Magic Number||Record magic numbers|
|Write Pending Orders||Write deferred (not working) orders to file|
|Write Deposit/Withdrawals||Write down all the information about the top-up of the account, as well as withdrawals.|
An example of how the script works:
The script is transferred, as usual, by the mouse to the graph, or with the right mouse button – Execute on the graph. The EA will start the analysis, it may take some time, depending on the number of orders in your trading history. The top left screen will display information about the process as a comment. As a result, we get a record in the magazine:
Done… Wrote file name: ‘My Orders History.csv ‘to the folder …/MQL4/Files
The resulting file will be preserved in the root folder of your terminal kind: C:’\Users\’Admin’\AppData’\Roaming’\Meta’Terminal’\1FC855301\Path
We will open the file through Excel and see a table of this type:
It shows all the basic information on your trade. Now through the program you can do sorting, deleting unnecessary results, counting profits by day, months. Through the filter option, you can only display orders that interest you: in a certain direction, by magic number or by comment.
You can also add a couple of buttons to build a profitschedule by manually introducing a formula to add up the profits of each trade. We got this schedule of our adviser:
As you can see, the yield curve is flat, the drawdown EA quickly worked and again went into profit. Exactly the same schedule can be made for a different time period, or for orders from different trading advisors, if there are several on the trading account.
That’s all, we hope this script will be useful to you.
Simplicity is the key to success!