RIC function script vs RIC chart

Optuma Scripting
1

I create the RIC chart for Hang Seng Index constituents against HSI, with normalization date 3/19/2020 and zero-based selected.

I also add a column in this watch list to show the same RIC % with script:

RIC(DATESEL=User Defined, START_DATE=2020-03-19, ZEROBASED=True, INDEX=HSI:WI)

However, the two figures are different.

e.g. HSBC (5.HK) shows -21.4% on RIC chart but shows -15.12% on the watch list column.

Kindly advise.

 

Capture

2

Hi May,

The time frame of the chart is set to 1 day. The time frame of the Watchlist is set to 1 Week. Any script in the Watchlist is going to use a Weekly time frame, i believe that’s the reason for the variation.

Ex5

Adjust the chart or Watchlists time frame so the two match and the values should line up.