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)
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: