I wanted to update my sector performance table for 2014. However, when I went to Library/Columns/ Yearly Return column set TC V12 have as the last year 2013 and doesn't update the set for 2014. do you know how I could update my set for 2014 performance.

Thank you for your help.

LK

Probably the easiest way to do this is with the Custom Date Sort feature.

Basics of Custom Date Sort (5:32)

You will want to switch to a long time frame (Yearly should work in this case) and select Tools | Custom Date Sort from the menus.

You will then drag the pointer from the 2013 bar to the 2014 bar in a yearly time frame or the last bar in 2013 to the last bar in 2014 in a shorter time frame (but using the longest time frame you can should be best if you want the WL Column to last for many years).

Make sure it is set to % Change and select Sort. Then choose Add Column in the WatchList where you want to add the Column.

You can right-click on the name of the WatchList Column at the top of the WatchList and select Edit Columns to change the Header for that WatchList Column.

Adding & Editing Watchlist Columns (4:23)

Thank you Bruce

You're welcome.