Reply To: Market Capitalization

Optuma Forums Optuma General Discussion Market Capitalization Reply To: Market Capitalization

#67005
Darren
  • Topics: 69
  • Replies: 737
  • Posts: 806

Hi Donald,

Yes you would do that, but first you would need to download the historical daily market cap data for each constituent (fundamental data is only downloaded when the chart is opened).

The best way to do this is to open a watchlist of the S&P500 and below a price chart add a Data Field tool set to Market Cap. Then click the Cycle Codes icon in the watchlist title bar to automatically scroll down the list to download the data in the chart (right-click the cycle codes icon to set the speed to something like 6 seconds).

Capture

Once all 500 have been cycled through and the market cap data has been downloaded then run the breadth calculation to sum the values and then add the watchlist column to calculate the percentage.

Pin It on Pinterest