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
- Topics: 4
- Replies: 115
- Posts: 119
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.