Quoting BenQDislikedWackena,
In your attachement to this post, how did you get the results to partition out by pairs?Ignored
1. Opening the DetailedStatement.htm with Excel.
2. Select all data, starting just below the Deposit line and stopping just before the p/l line.
3. Click sort in the top menu Data drop down.
4. Check "no header row".
5. Sort by column E - ascending.
6. Click OK.
7. Select first sorted cell in column E.
8. Click Subtotal in the top menu Data drop down.
9. Click OK at next prompt window "MicroSoft Excel cannot determine..."
10. Select column E in "At each change in".
11. Select only column N in "Add subtotal to".
12. Click OK.
The rest is manual, such as pair win/loss/profit spreadsheet. I delete name and account number and add blank rows before and after each pair total line.
Wackena