1 Example: If price is Rs. 55 per share and 1000 shares are purchased then 55x1000 = Rs. 55,000. 0.15% of 55,000 is Rs. 82.5. Three paisas per share is 1000 x 3 = 3000 paisas i.e. 3000/100 = Rs. 30. In this case Rs. 82.5 is higher. ii. Total brokerage paid, iii. Profit or loss in each trade, iv. Total profit or loss, and v. Current portfolio of stocks with prices on the day vi. You may increase the number of Rows in the excel sheet if there are more entries on the same date and there are more shares to be shown in the balance. 1 Example: If price is Rs. 55 per share and 1000 shares are purchased then 55x1000 = Rs. 55,000. 0.15% of 55,000 is Rs. 82.5. Three paisas per share is 1000 x 3 = 3000 paisas i.e. 3000/100 = Rs. 30. In this case Rs. 82.5 is higher. ii. Total brokerage paid, iii. Profit or loss in each trade, iv. Total profit or loss, and v. Current portfolio of stocks with prices on the day vi. You may increase the number of Rows in the excel sheet if there are more entries on the same date and there are more shares to be shown in the balance