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(INT_TYPE=Week)

Change Interval Week

Change over the last 2 months:

CHANGE(INT_TYPE=Month, INT_COUNT=2)

Percentage change from a specific date

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

Note

divide the formula by 100 to display the results as a % in a watchlist by changing the Column Type to Percentage.

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:

https://forum.optuma.com/t/perfomance-between-two-static-dates/3859