Totals of a Stock Portfolio

[chiswickbridge]

I am trading at the stock Market and a newbee....Need advice to added up totals of a particular trade on a specific date....the catch is the trades are of 365 days and the rows are about 7000+...Will VBA help or Excel Formulas....Either way...if VBA ...it will be helpful to execute a vba macro...
In short I need the Totals of one specific stock ( STT / Fees / Govt Tax / Qty traded in Buy or Sell / Amounts involved ) for each day and each stock.

I may have traded in 5 stock...So will need data for all 5 stock for that date

 

[alansidman]

cannot manipulate data in a picture. Please reload sample data and mocked up solution using XL2BB