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

How to add a 2016 Column to "Sector by Year" in Version 17 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
peace
Posted : Thursday, April 20, 2017 4:37:25 AM
Registered User
Joined: 10/7/2004
Posts: 17

Hello,

At the top of the "Sector by Year" layout there are three rows of years, from 2004 to 2015. I imagine that the is done by adding a column with certain criteria and then renaming the column to the year (if the data is available). Can we do this ourselves and, if so, how do we do it?

TIA

Bruce_L
Posted : Thursday, April 20, 2017 10:01:19 AM


Worden Trainer

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

Try using the following Indicator Fomula for your WatchList Column. While it would probably work right now in a daily time frame, you will probably want to set it to a yearly time frame instead to make sure it keeps working in the future.

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

You will also probably want to edit the WatchList Column so you can change the Header to 2016, Positive Color to green, and Negative Color to red under Properties for the WatchList Column./p>



-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.