CHANGE() Function

Author: Optuma Team Last updated: Jul 1, 2020 19:25

The ``CHANGE()` function can be used to specify percentage change over a fixed period (eg 1 week, 3 months) or from a fixed data (eg the 2020 low on March 23rd).

Add CHANGE() to the script editor window and click on the text to change the parameters (the default setting is 1 Day), such as percentage change over the last week:


Change Interval Week

Change over the last 2 months:


Percentage change from a specific date

Change the Interval Type to Fixed and select the date from the calendar.

Change Interval Fixed

Custom Labels

Percentage change between two specific dates

This isn’t possible with the CHANGE function, but here’s a solution on the forum: