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

Adding past year performance to the Watch List Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
LK
Posted : Tuesday, February 23, 2016 1:22:54 PM
Registered User
Joined: 12/17/2004
Posts: 60

I have a Watch List with SP 500 and 10 mains composition sectors. I have performance data in it from 2004 through 2014 and YTD. It used to be that when New Year start I would go to Library and it had a link to add past year. I can not find it now. I would like to add 2015 SP500 and its sectors performance to this Watch List. This Watch List is linked with the overlay chart with SP and Sectors. Could you please help.

 

Bruce_L
Posted : Wednesday, February 24, 2016 11:16:42 AM


Worden Trainer

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

You could write an Indicator Formula which would always return the price percent change for the previous year by setting the time frame of the following to Yearly.

100 * (C1 / C2 - 1)

A daily Indicator Formula for 2015 using dates for the bars ago parameters could be written as follows.

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
LK
Posted : Thursday, March 3, 2016 9:30:52 AM
Registered User
Joined: 12/17/2004
Posts: 60

Thank you

Bruce_L
Posted : Thursday, March 3, 2016 9:37:26 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.