I have a "Secotr Indexes" created long time ago, I beleive it was a default.  I have a column for each year, ie.e 2015, 2014, 2013.  I do not remember how to add 2016 and 2017, can you please highlight how to do that?

Thanks

You can use the following formula set to a yearly time frame for 2017:

100 * (C'12/29/2017' / C'12/30/2016' - 1)

At least until the end of the year, this should return the same results as the following year-to-date formula (also using a yearly time frame).

100 * (C / C1 - 1)

And the following formula set to a yearly time frame for 2016:

100 * (C'12/30/2016' / C'12/31/2015' - 1)

You can add the formulas as WatchList Columns in TC2000 v17 as follows.

• Select Add Column (the + in an orange circle at the top of the WatchList).
• Select Write New Formula.
• Give the PCF a name (probably 2017 or 2016).
• Set the TimeFrame to Yearly.
• Select OK.
• Right-click on the name of the WL Column at the top of the WatchList and selec Edit.
• Select the Properties tab.
• Set the Header (probably 2017 or 2016).
• Change Positive Color to green.
• Change Negative Color to red.
• Uncheck Abbreviate Vals.
• Set the Refresh rate low for 2017 (all but current year should be Manual).
• Select OK.

Thanks Bruce, great writing, the instructions were perfect.

You're welcome.