Hi Bruce and all,

In my TC2000 Ver 12.3, in the Pre Built Formulas in the Indicators list, there is one named "YTD % Change". It's one that's in the system (I can't change or remove). When you click on "View" the formula is 100 * (C / C1 - 1)  which is not correct and of course gives grossly incorrect data.

Is that a pre-built indicator that needs correcting, or removing?

Appreciate your thoughts.

As long as the time frame of the formula hasn't been changed from its yearly default, it is in fact the correct formula and does not return incorrect results. The advantage of this is that you do not need to change the formula each year.

You could create a Daily Indicator Formula for this (which returns exactly the same values):

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

But unlike the yearly version that is built in (the 100 * (C / C1 - 1) formula), you would need to change the formula each year.

Hi Bruce,

Thanks for the information. The one point I don't completely grasp with the formula is how it can determine YTD % Chge. I can see if you use a yearly time frame, it would give a yearly % Chge, or with a daily time frame, a change from a day ago. The Title is YTD % Change, so can you accurately get, say the YTD change from 12/31/12 to today just using the Closing price and Closing 1 day ago?

Appreciate your help.

It is just a matter of the Time Frame being used for the formula. When the Time Frame is Daily:

C = the close of the current Daily bar, which is the current price.

C1 = the close of the previous trading day.

When the Time Frame is Yearly:

C = the close of the current Yearly bar, which is the current price.

C1 = the close of the last yearly bar, which is the last close of the previous year. In this case, the close of 12/31/2012.

So unlike a formula which is constructed using dates, it will automatically change whenever a new year starts and a new yearly bar starts to form.

Hi Bruce

I am confused.  I have used the 'Recent Performane' column set and there is %Chg1Wk, %Chg1Mth, %Chg3Mth, %Chg6Mth, %Chg1Yr.

I have been experimenting and these do not seem to follow the time frame discribed above.  The formula is not messuring the time period close  to the current price.  As you described in your email to John VanKirk, 

 What formulae are being used?   Can you help me with this?  Thanks Bruce

Glen White

Those are not week to date, month to date, quarter to date, half to date and year to date WatchList Columns and are not based on calendar based weeks, months or years. They are Daily WatchList Columns using periods of 5 for a week, 21 for a month, 63 for three months, 126 for six months and 252 for a year.

You could use the same formula:

100 * (C / C1 - 1)

To create week to date, month to date, quarter to date and year to date WatchList columns by using the appropriate time frame, but there is no time frame available for a half, so that would not be possible unless you adjusted the formula at each half.

If i want to comparer the year ending figures for industry groups what formula would I use.

2012 vs 2011

If you want the Price Percent Change for 2012 and 2011, there are two was to do this. One is to use a yearly formula with relative offsets. If you are using a Yearly Time Frame, a Price Percent Change Indicator Formula for the previous year could be written as (currently 2012):

100 * (C1 / C2 - 1)

And a Price Percent Change for the year before that could be written as (currently 2011):

100 * (C2 / C3 - 1)

But these formulas would be for 2013 and 2012 in the year 2014 instead of being for 2012 and 2011 like they are now. You don't have to change these formulas each year, but the dates being represented channge from year to year because they are offsets from the current year.

You can also create Daily Formulas with fixed dates. These formulas would be specifically for 2012:

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

And for 2011:

100 * (C'12/30/2011' / C'12/31/2010' - 1)

But you would need to create a brand new formula at the end of 2013 to have a formula for that year.

Thanks, Bruce.

One more question.  Each column manually refreshes.  So if I do not click on the column and click refresh does that mean the columns will stay the same all day as long as I do not close and reload TC.

I know I can change them to 30 or 60 minutes.  Seems a hassle for every watchlist with different columns in different WL.  Maybe TC is defaults to Manual to use less CPU???

I guess I am asking how does it work.  Is the any time when they are automatically refreshed like EOD without me doing anything?

Thanks again, Bruce

Glen White

It is possible that the WatchList Columns can refresh at other times, but the only way you can guarantee that the WatchList Columns refresh is to manually refresh them or to set the Refresh Rate to something besides Manual so the WatchList Column refreshes automatically.

Hi Bruce,

I was looking at how you were using the date after the close like

C'11/16/12'

Can you use dates anywhere else like that or does it only work with C

I would like to use it with AVGC200  instead of having to count back the number of days.

Glen White

I am happy to read you were able to figure it out on your own.

Thanks, Bruce.

Understanding this YTD formula is not at all obvious since it includes no "dates", but I now understand how it is used and how it automatically works for yearly comparisons.

thanks for your help and  patiences.

John

You're welcome.