Equal-Weighted Total Return Index

Optuma General Discussion
1

Hi,

I use the following script to calculate an Equal-Weighted Price Return Index for the growth sector indices.

// Calculating the Equal-Weighted Index of Growth Sector Indices
POWER(POWER=0.3333, SP500-45:SPI * SP500-25:SPI * SP500-50:SPI)

Is it possible to calculate an Equal-Weighted Total Return Index of the growth sector indices?

Best wishes,
Thomas

2

Hi Thomas,

Total Returns data is different for indices - they are are calculated separately by S&P and have ‘TR’ added to their symbols. Using SP500-45TR, -25TR, and -50TR in your formula should work.

3

Thanks, Darren, and nice to have you back.