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: