CommunityPowerEA Parser Tester Log - MT5

Ulises Cune

3 years ago
updated 2 years ago

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:

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"

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

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

Replies 16

Newest first
Newest first Oldest first

2 years ago

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:

Run:

c:\Python310\python.exe CommunityPowerEA_parser_testerlog.py

Fix, search and replace + and " " value TesterWithdrawal

New version add:

TesterWithdrawal

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

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

This version adds

Partial close for SELL-series & Partial close for BUY-series

Sum TakeProfit

For example:

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

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

shinnsohai

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

You must have Python 3 installed

You must edit the file CommunityPowerEA_parser_testerlog.py and modify DATA_FOLDER