S&P 500 tracking portfolio

Very simple and intuitive Google Sheets Spreadsheet that can help you choose the stock were you want to invest to track SP500 companies, but instead of using the ETF, you can habe the stock and choose the ones you prefer to invest on.

You'd just need to input the total value to invest, and the tool will suggest the number of stocks for each ticker to maximize representation of SP500 while diversifiying your investment. In a simple dashboard, it will show you the weighted representation of the index, the amount of different companies suggested, and the weighted cap of the different industries, both in the index and the suggested portfolio.

On another sheet it'll show you suggested number of Stock Shares to purchase for the given scenario.