Reply To: Best way to carve out XLK sector from SPY performance

Optuma Forums Optuma Scripting Best way to carve out XLK sector from SPY performance Reply To: Best way to carve out XLK sector from SPY performance

#47635
Matthew
Matthew
  • Topics: 3
  • Replies: 80
  • Posts: 83

Hi Chad,

Further to Darrens reply, you would need know the weight of the technology sector. Ie if tech went up by 5% and every other sector was flat, then the S&p would go up 1% (if tech was 20% by market cap).

Once you have this information you can setup a calc to remove tech by subtracting the value of the tech sector multiplied by the market cap of tech divided by market cap the whole Index.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close