Hi Guys,
Find my spreadsheet attached. Just enter the stock code. Under action choose Buy or Sell. This is used for calculating the STT component, which is applied only to the Sell Leg of the trade. Enter the quantity of shares in the under Quantity and price that your trade was executed at under price. The spreadsheet will do the rest of the calculation. It will also give you a total at the bottom (in Bold), which will tell you exactly how much profit/loss you made, how much is the commission and what will you be getting back. There may be a minor variation between the bank's calculations and this spreadsheet, due to rounding off rules.
Good luck.