Macro adjustment

I have a FIFO (Trading ) spreadsheet ... Need someone who can review the sheet/macros... make timely adjustments and be a realiable developer for future enhancments.... ( automation / Google sheet(possibly) ) For now ... I have a FIFO (Trading ) spreadsheet ... FIFO working ...calculating a sheet detailing stocks prices and buy / sell dates etc.... and gives a status of a type of stock after calc ... either ... SoldOUT , BoughtElsewhere or Tokens Sold or Unsold There is also a summary sheet taking the last calculated line of each stock and creates a summarized list of all stocks status's / remaining amounts etc... The JOB.. ... (Summary page needs adjusted so it follows 5 rules when displaying each stock.. currently 3/5 correct ) Summary sheet grouped by Stock... and stock trades can be reterived by date format filter.. Sheet has pivot table .+ vba macros.. 5 rules should be followed ( see pic for 1 to 5 ) for summary sheet ... (however summary sheet should follow rule 5 to 1 in order to display stocks correctly ) See typical code for rule checks... that would need adjusted) see example data.... (created to fall under a specific rule,,for testing purposes ) see summary sheet pic ... for testing .. the stock (exchange coloum) ... Notice... the Stock names are actually created to reflect what should be presented in the 4 colored coloums to the right).. for easy reference.. (instead of say APPLE, Microsoft, Tesla stock .. for example) .... so in doing it this way you can see rule 1,3,4 is working ok.. the others need tweaked ! NOTE : If you review the data sheet .. you can see the coloums/cells that need to be referenced by the macro to make the rules work ... if things work out I've got more ideas for further adjustments/project work than can be done to enhance sheet ..