Let me know if there's a better place for this. I'm trying to put together a chart to see what's moving the sp500 and conversely spx and spy most. I saw that [https://www.slickcharts.com/sp500](https://www.slickcharts.com/sp500) basically had the day movement for all the component companies and so i took that table ported it into excel and then multiplied the price change by the weight% but that wasn't right as i got a total of 0.54.
I through i might need a multiplier but when i did the same with % weight and % change I got 53, which isn't right as the % change was 0.24 for the day.
is this something someone already had made or what am i missing?