Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Calculating an Annual Return for 2016 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
traderlady
Posted : Monday, November 20, 2017 11:19:24 AM
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.

Bruce_L
Posted : Monday, November 20, 2017 11:38:43 AM


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
traderlady
Posted : Monday, November 20, 2017 11:41:47 AM
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)

traderlady
Posted : Monday, November 20, 2017 11:42:41 AM
Registered User
Joined: 10/7/2004
Posts: 1,178

I mean for 2016

Bruce_L
Posted : Monday, November 20, 2017 11:45:02 AM


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
traderlady
Posted : Monday, November 20, 2017 11:46:42 AM
Registered User
Joined: 10/7/2004
Posts: 1,178

Thanks, I'll try this and then check it against the "Custom Date Sort" tool.

Bruce_L
Posted : Monday, November 20, 2017 11:52:19 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.