I wrote a formula to monitor "percentage gain/loss month to date." That formula during the month of January is:

100 * (C / C'12/31/2012 -1).

I then create and save a column based on that indicator to create a percentage gain/loss for a list of ETF's, by month, and month to date. Each month I add a new column.

At the end of the month, I edit the indicator to close the month out, so it reflects only the January performance in the table going forward in time to:

100 * (C'1/31/2013' / C'12/31/2012' -1)

I would expect that changing the formula would be reflected in the saved column that uses that formula.

In the table though, the column based on this saved formula continues to reflect the original formula calculation rather than the edited formula.

I have to delete the "January Percent Gain/Loss" column and recreate it.

Am I misunderstanding something or is this intended?

Thanks,

Bob

It is the intended behavior.

The WatchList Column is based on a copy of your formula and is not linked to the formula in any way. This allows you to do things like change the time frame of the formula in the WatchList Column without changing the original formula or the same formula being used in another WatchList or as an EasyScan Condition.

You will need to replace the WatchList Column if you make changes to your formula after the WatchList Column is created.

Thank you Bruce.

Bob

You're welcome.