custom mt4 statement.htm

How can I add PIP gain for each trade in statement.htm?

I import it into Excel and do the calcs there.

It is manual work....How can I do it automatically by modifying statement.htm

the mt4stat has that function when I upload to them.

Do you have excel formula to do the calculation?

=IF(C7="buy",J7-F7,F7-J7)
When I open my statement from GoMkts the buy/sell is in Col C, Entry price in Col F, Exit price in col J, and the first row of data is row 7.
"Your mileage may vary". If so, just adjust the column letters and starting row. Place this over to the right - like in Col R, and then select it, and copy it down to the last line of your data. One problem I do not have a solution to yet is the missing comma in the thousands position, like 1 2345.67 the space is a deal killer - probably not a problem here but it is in computing the dollars.

This is Uber after the fact, but I found the .HTM file located in the template folder.
Does anyone have any custom "statement" files they made?
I assume with web page knowledge, these can be changed.