Select the TOP-20 balanced passes with ChatGPT

Two binary MetaTrader 5 result files are attached to this message:

1. the main optimization / Back / IS file;
2. the Forward file.

Identify them automatically from the dates in their file names:
— the earlier period is the main optimization / IS;
— the next, later period is Forward.

Analyze both files, match results by the original “MT5 Pass” identifier, and create a ready-to-download `.xlsx` Excel file containing the TOP-20 most balanced results.

Important: match records only when their MT5 pass numbers are identical. Do not match them by row number, record order, or chart-point coordinates.

For `.opt` files in this format, use this binary structure:

— results array starts at byte 19866;
— record size: 320 bytes;
— Pass ID: signed int64 little-endian at offset +0;
— followed by 27 float64 little-endian values at offset +8;
— followed by 14 int32 little-endian values at offset +224;
— followed by 5 int64 little-endian values at offset +280.

Extract from each record:

— MT5 pass number = int64 at offset +0;
— profit = the third float64 value, doubles[2];
— relative drawdown percentage = doubles[20];
— trade count = ints[1].

First verify that:

— each file size follows this formula:
(file size − 19866) / 320;
— the result is an integer;
— every Forward pass exists in the IS file.

For each Forward pass, find the matching IS pass and calculate:

Average profit:
(IS profit + Forward profit) / 2

Similarity:
MIN(IS profit, Forward profit) / MAX(IS profit, Forward profit)

Include a pass in the main selection only when all these conditions are met:

— IS profit > 0;
— Forward profit > 0;
— at least 30 IS trades;
— at least 30 Forward trades;
— IS relative drawdown ≤ 10%;
— Forward relative drawdown ≤ 10%;
— profit similarity ≥ 66.7%, meaning the larger result is no more than 1.5 times the smaller result.

Sort the filtered results:

1. average profit descending;
2. when averages are equal, similarity descending;
3. then the smaller of the two profits descending.

Take the first 20 passes. If fewer than 20 pass the filters, include every result found and do not add weaker results just to fill the table.

Create an Excel file with one sheet named “TOP 20”.

The table structure must be exactly:

| Pass | IS profit | FW profit | Average | Similarity | Trades IS/FW | DD IS/FW | Comment |

Fill the columns as follows:

— “Pass” — the original MT5 pass number;
— “IS profit” — the main optimization profit;
— “FW profit” — the Forward profit;
— “Average” — the average profit for both periods;
— “Similarity” — the similarity percentage;
— “Trades IS/FW” — format “142 / 116”;
— “DD IS/FW” — format “7.44% / 6.52%”.

Build the comment from the first matching rule:

1. the first ranked row — “Max average”;
2. similarity ≥ 97% — “Almost equal”;
3. similarity ≥ 90% — “High similarity”;
4. maximum drawdown across both periods ≤ 4% — “Low DD”;
5. if the larger profit is at least 1.25 times the smaller one:
   — “FW above IS” when Forward is higher;
   — “IS above FW” when IS is higher;
6. similarity ≥ 80% — “Similarity above 80%”;
7. otherwise — “Comparable periods”.

Excel formatting:

— first row: merged heading “First candidates”;
— second row: column headings;
— dark-blue heading background with bold white text;
— highlight the first 5 results with a light-blue background and bold text;
— display profits and averages with two decimal places;
— display similarity as a percentage with one decimal place;
— add cell borders;
— freeze the first two rows;
— enable table filters;
— set readable column widths;
— check for formula errors: #REF!, #DIV/0!, #VALUE!, #NAME?, #N/A.

Name the file:

MT5_TOP20_IS_Forward_<shared_hash_from_file_names>.xlsx

Do not provide a long text explanation and do not ask clarifying questions. After processing, return only the Excel download link and briefly state how many passes met the filters.