Registered User Joined: 10/7/2004 Posts: 1,178
|
Under "Library", one choice is "Column Sets" and then "Yearly Return".
The "Yearly Return" column set shows annual returns from 2005 through 2015, but this is not updated for by Worden for 2016 returns.
In addition, the actual formulas are not available to TC2000 subscribers.
Thus, one is unable to see whether these formulas take into account eliminating stock market holidays as well as Saturdays and Sundays.
In trying to work out an accurate annual formula for the year 2016, after checking 2015 and 2016 calendars, I submit the two options below.
100 * (C'12/30/15' / C'01/04/2016' - 1)
100 * (C'12/30/2015' / C'12/30/2016' - 1)
If both of these are incorrect please provide the accurate formula.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
First off, change the time frame to yealy. There are only 500 or 501 bars in the daily time frame, so the formula will stop working in relatively short order if you leave the time frame set to daily.
I probably wouldn't do it the way it is done with years across the top. I would probably have something like YTD for the current year and then 1 year ago:
100 * (C1 / C2 - 1)
2 years ago:
100 * (C2 / C3 - 1)
Etc.. That way I never have to change it.
But the formula for 2016 if you want to use dates would be the following.
100 * (C'12/30/2016' / C'12/31/2015' - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Bruce, I just checked again based on the chart rather than the calendar. I believe the most accurate formula for the annual return in 2015 would be the one below:
100 * (C'12/31/15' / C'12/30/2016' - 1)
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I mean for 2016
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You have the dates right, but the formula is backwards. The end date needs to be in the numerator and the start date needs to be in the denominator.
100 * (C'12/30/2016' / C'12/31/2015' - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Thanks, I'll try this and then check it against the "Custom Date Sort" tool.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|