CommunityPowerEA Parser Tester Log - MT5

Avatar
  • updated

Hello community,

I share a script in Python that parsing the log of "Strategy Tester" which exports it to Excel (CSV).

I had the problem of not being able to remove statistics from operations and some other data from when it tasted a strategy, so I decided to make this script.

This is just the beginning. There is a lot to do in the script. Missing many more options, such as Trailing Stop, errors, etc.


I decided in this first version, not to talk the errors in operations but in future it could be optional to export errors to Excel.

The script did it on a weekend and have a muucho to be optimized.


I invite any of the community that improves it.

I share a repository in Github where they could share ideas or here it would also be very beneficial for everyone.

https://github.com/ulises2k/communityPowerea_Parser_Testerlog

The use is very simple, they need python 3.8 that can be downloaded from:

https://www.python.org/downloads/

You should edit the file and modify this variable to fit your profile:

Image 1553

You can use Visual Studio Code to edit and test the script or any editor/debug you want from Python.

https://code.visualstudio.com/download

In Windows you can simply run the following command in "cmd.exe"

Image 1554

Then open the 20210705.csv file with Excel and can filter by column, for example create statistics.

Image 1555

It would be good to share ideas and formulas.

It occurs to me for example, add a more column where you can get the spread at the time of the operation. I think that at this time the script could not, but if I'm thinking about the next version.

I encourage everyone to improve this excellent EA

CommunityPowerEA_parser_testerlog.py

Avatar
Ulises Cune

This version add:

Sum TakeProfit

For example:

Sum TakeProfit ($1.00) has been reached ($1.52 >= $1.00)!


CommunityPowerEA_parser_testerlog.py

Avatar
Ulises Cune

This version adds

Partial close for SELL-seriesPartial close for BUY-series


CommunityPowerEA_parser_testerlog.py


Avatar
Ulises Cune

This version add:

  • Signal to delete pending buy|sell-order
  • order canceled [#2 buy stop 0.1 EURUSD at 1.13532]
  • OrderSend( EURUSD, buy stop
  • | OrderDelete( 15 ) - OK!
  • stop loss triggered #3 sell 0.1 EURUSD 1.13731 sl: 1.13475 [#4 buy 0.1 EURUSD at 1.13475]

Check Changelog here

CommunityPowerEA_parser_testerlog.py

Avatar
Ulises Cune

New version add:

TesterWithdrawal

You can use the SUM function to add the amount of withdrawals and the profit made

CommunityPowerEA_parser_testerlog.py

Avatar
Ulises Cune

Fix, search and replace + and " " value TesterWithdrawal

CommunityPowerEA_parser_testerlog.py

Avatar
Ulises Cune

New Version add

Global Account (All Properties)

With this, I already have 90% of all the log options identified.

I have added the immobilization of the first row and the filter of each column


I have added a 2nd Tab with some formulas like SUM, MIN, MAX, COUNT, AVERAGE, Martingale and Volume as an example.

Examples (Default Set):

20220612-210419.xlsx
20220612-210419.csv

Script Python:

CommunityPowerEA_parser_testerlog.py

Run:

c:\Python310\python.exe CommunityPowerEA_parser_testerlog.py