Using S&P500 return in a formula

Research
1

Hi!

I need help figuring out how to get the S&P500 return to plug into a formula. What is the syntax? Please help!

Thank you so much for your help!

2

You can use [font=courier new]#Bench[/font] as the series parameter to the [font=courier new]Close[/font] function:

Close(0, #Bench) / Close(@x, #Bench) where [font=courier new]@x[/font] is 21 for one month, 62 for three month, 251 for one year, etc.

3

If you don’t have S&P 500 set up as the benchmark (you may want to use another benchmark) then substitute GetSeries(“$SP500”) for #Bench in Aaron’s formula. If you want equal weight S&P 500 (instead of float-weight) then use GetSeries(“$SP500EQ”).

Steve

4

Great, thank you very much for your help!