Forum Discussion
Excel Investment portfolio
Hello so I have an investment portfolio with like stocks. When I input one of my Index funds it shows up as #FIELD! in the industry. How can I get the industry for a index fun to show up as index fun...
The index is swppx
Oh, and I just realized that there is NO industry, per se, to connect with the S&P 500 index. It is, after all, an index that crosses MANY industries, and just is the largest 500 companies in the S&P. So THAT is probably the real reason you get, in essence, an error message for Industry. Individual companies will be part of an industry; some mutual funds and ETFs, as well, can be industry specific (Consumer Goods comes to mind, or Pharmaceuticals, or Healthcare), but the S&P 500, no.