As a stock market investor, I used to track all my investments in an excel file. After some time I hit the technical limits of what an excel file can do.
That's why I created statfolio.net, a portfolio tracker that automates all the statistics I had in my old excel file + other goodies like automatic dividend tracking and price refresh. Using Statfolio, you can analyze the performance of your portfolio at sector/industry/holding level.