[Sparrow]

To clear up one point before the question arises, I merely mark the trade confirmations and copy them into a text file, I don't use the available excel file itself.

Also the way how pips in the summary are calculated is this:
I weight pips by volume traded, so if one trade is twice the size it will be counted as twice as many pips, but in the list it appears as the normal pips amount.

For the net pips calculation the gross pips are divided by gross profit, commissions is now multiplied by the number and subtracted from the gross pips figure.

Hope I haven't confused anyone.

I am pretty sure the script works well enough to get good results, but I've only tested it with my trading style.