As in index investor, I occasionally look up the representation of a particular ticker in an index on a big news day for a company (lookin' at you, Elon) but since I hold SPY and QQQ in equal portions, I was curious about specific overlaps and also average exposure, so I made this spreadsheet.
It's a screenshot sorted by average ((S&P+NASDAQ)/2) weight.
This would probably fun to do some visualizations with so maybe I'll play around with that at work tomorrow.
I just figured someone else might find this interesting!
Submitted November 23, 2021 at 11:59PM by us1838015 https://ift.tt/3nLAzV7
