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

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
Avatar
Ulises Cune

Fix, search and replace + and " " value TesterWithdrawal

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

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

This version adds

Partial close for SELL-seriesPartial close for BUY-series


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
Quote from shinnsohai

Cool, this will be beneficial for us to analyze through PowerBI or Tableau.

Not sure if I can add a wish of Capturing the set file's parameters to the subsequent sheet as well.

yes, sure, tell me

Avatar
shinnsohai

Cool, this will be beneficial for us to analyze through PowerBI or Tableau.

Not sure if I can add a wish of Capturing the set file's parameters to the subsequent sheet as well.

Avatar
Ulises Cune

Hello,

After a long time, I upload a new version of this script that parses the CommunityPower log and exports it to Excel to be able to see in detail the operations carried out, filter data and create statistical graphs with Excel.

It is not complete, but a large part of the "Expert Log" is analyzed.

Script en Python 3

CommunityPowerEA_parser_testerlog.py

You must have Python 3 installed

You must edit the file CommunityPowerEA_parser_testerlog.py and modify DATA_FOLDER

Run (open cmd.exe and write this):

c:\Python310\python.exe CommunityPowerEA_parser_testerlog.py -mt5_visual_mode_checked off


Parameter:

-mt5_visual_mode_checked off

-mt5_visual_mode_checked on


Example Result (Default Set):

20220528-141106.xlsx
20220528-141106.csv

Avatar
Andrey Khatimlianskyi

Cool!

Please, share the results of your analysis, if any.