Additional "Change %" periods in Watchlist column

How can additional periods (e.g. 6 months, 12 months) be added to the list available under “Change %” column in a Watchlist?

Hi Chris,

To calculate any % use the CHANGE() function, and click on the text to set the required interval, eg 1 month:

Note that the formula is divided by 100 so that it can be displayed as a %, in the watchlist by changing the Column Type, but that isn’t required:


Don’t forget you can download examples of workbooks and watchlist formulas from here: