Net Chg

Optuma General Discussion
1

Hi Optuma team,

I have found a really strange calculation in a watchlist.

As you can see in the following screen shot the net change (Net Chg) column of the “S&P 500 52-Week New Highs-New Lows Percent” (Code: SPXHLP) show a value of “0.00” although we had a change from “-1.19” to “0.00”.
change wl

I had to mention that I created the following custom code for the “S&P 500 52-Week New Highs-New Lows Percent” (Code: SPXHLP) watchlist entry:
change cc

As you can see I multiply the raw values with “100”.

Is it possible that the “Net Chg” calculation ignores the multiplication with “100” and shows a value of “0.00” in the watchlist since the net change of the raw values (without multiplication of “100”) is so small that it shows “0.00”?

Or is there a data series error since the watchlist entry “Percent of S&P 500 Stocks below 30% RSI(14) Level” (Code: SPXR14B30) shows for the 10/30/2020 the same value as for the 10/29/2020 although the S&P 500 had a percent change from 10/29/2020 to 10/30/2020 of minus 1.21%.

Thanks,
Thomas

2

Hi Thomas,

On investigation it appears that it’s an issue with negative numbers, and has been logged for a fix in the next update. Instead you can add a column using CLOSE() - CLOSE()[1] to calculate the net change.

3

Hi Darren,

thank you for your efforts.