That is a lot of data you have under the pivot table.
I like this post with "historical" data showing the pattern, and then you give us a detailed view (even if it's only the last several weeks for that Ticker).
Looking forward to seeing the Q3 summary.
RE: Week 27 - Investment Summary