Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Formula Change Doesn't Change Saved Column Based on that Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bobre1
Posted : Friday, February 1, 2013 11:18:42 AM
Registered User
Joined: 10/7/2004
Posts: 886

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

 

 

Bruce_L
Posted : Friday, February 1, 2013 11:27:04 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bobre1
Posted : Friday, February 1, 2013 11:38:29 AM
Registered User
Joined: 10/7/2004
Posts: 886

Thank you Bruce.

Bob

Bruce_L
Posted : Friday, February 1, 2013 11:40:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.