Parse data and combine values for duplicate entries for the same date

Here is where i need some severe help and I've been studying the past two days trying to figure this out. For the VBA version, the task is to generate output shown in the “Desired_Output” worksheet using data in the “Raw” worksheet. I figured I'd compileing the results that I wanted, would be the best way to explain. Attached is the workbook with several work sheets, one with the raw data, one for the output of our vba code and one for the desired output how i want it to generate the results. Now I would like this to be able to be done in a way that makes the code as flexible as possible. Like if I were using different dates or different "stocks" if possible. If anyone can help me seriously you would make me the happiest camper ever. I dont know how to go about this i have several idea's but none that are panning out.