Daily Weekly Monthly Data Consolidation

I have been working on a spreadsheet to consolidate & summarise daily market data into both WEEKLY Summaries & MONTHLY summaries each in separate spreadsheet TABS)& now stuck with the next phase. I am seeking help with formulae to help translate / summarise relevant data according to the logic embedded in the first page of my actual spreadsheet, which is attached.

Thanks..