Want YTD % Return

June 17th, 2014, 09:21 PM

Hello, I am trying to make a custom study to display the Year-To-Date return as a column on the Marketwatch Tab
of TOS, my script looks like this with aggregation set to "D" (Daily):

plot ytdreturn = (close()-close[167])/(close[167]);

By my understanding that should give the close for today minus the close from 167 days ago, divided by the close from 167 days ago or the Year to Date % return in other words.

However, this gives me a 161% return for priceline (obviously incorrect, even if you use the 52 wk low it is impossible)
And a 133% return for the SOX (52 week low is 442, again impossible).

Can anyone please help???

June 17th, 2014, 09:54 PM

To answer my own question partially:

plot ytdreturn =100* (close(period = AggregationPeriod.DAY)-close(period = AggregationPeriod.DAY)[251])/(close(period = AggregationPeriod.DAY)[251]);

That will give approximately 1 year of returns (251 business/trading days).

Similarly:

plot ytdreturn =100* (close(period = AggregationPeriod.DAY)-close(period = AggregationPeriod.DAY)[115])/(close(period = AggregationPeriod.DAY)[115]);

Since there have been 115 trading days since the beginning of this year, the above formula gives YTD % Return. I would like to figure out a way to replace the 115 with a variable since tomorrow it will be 116, day after 117 and I don't want to have to change it every day.....

July 7th, 2014, 01:42 PM

Thanks! I was also trying to do something similar some time back.

Want YTD % Return

Discussion in ThinkOrSwim

Want YTD % Return