Follow these instructions to get the market caps for all components of S&P 500 index in one document.
- Using the search tab, find the S&P 500 main series (sp500_500). Select the series and click By Index in the top right action group called Search. This will narrow your search results to include only components of this index.
- Select all the series under Security. You can select the top security, scroll down to the bottom, and then hold shift while you select the bottom one. Next, click the action at the top of the window called Market cap, which is in the green block entitled Price charts.
- The market caps for all constituents of S&P 500 have now been moved to a Browse document. Please keep in mind that it may take a moment to load due to the number of series. To open them in new Analytics document, click the “A” button in the top toolbar.
- Now you can work with the series in the Analytics tabs.