6 Month ROC with 1 month offest

Optuma Scripting
1

Hello,
Is there a way to calculate a 6-month ROC with a 1-month offset. Tried doing it manually using below, but was not getting accurate results.
(CLOSE(Month(PERIODAMOUNT=1), OFFSET=-1)-CLOSE(Month(PERIODAMOUNT=1), OFFSET=-7))/CLOSE(Month(PERIODAMOUNT=1), OFFSET=-7)

2

Hi Thomas,

Try it without the negative offsets, or this is another way using square brackets for the offsets:

C1=MONTH();
(C1[1]-C1[7]) / C1[7]

It can be multiplied by 100 to get the percentage, or if used in a watchlist column change the Column Type to Percentage, and customise the label colours for positive / negative:

image