% Change custom column

[marciokoko]

I saw a Ken Rose tutorial where he uses this script to add a % YTD change to a list of tickers but it doesnt work for me. I get the values but they are incorrect:

def date = getYear();
def JanFirstClose = fold counter2 = 0 to 255 while date == Date[counter2] do close[counter2];
Plot YTDReturn = ((close/janFirstClose)-1)*100;
AssignBackgroundColor(if YTDReturn > 0 then color.Green else color.Red);

So for example i get this data for NIO: -8.63 today when its trading at 30.5. i would have to look back to jan 19 2021, which tos says closed at 58.44 which would be a 58.44/30.5= 91% drop.

If it were back to the open of Jan22, when it traded at 33.47 on jan 3 2022 = 33.47/30.5 = 9.7%.

Any ideas what I might be doing wrong?

Thanks

 

[halcyonguy]

I saw a Ken Rose tutorial where he uses this script to add a % YTD change to a list of tickers but it doesnt work for me. I get the values but they are incorrect:

def date = getYear();
def JanFirstClose = fold counter2 = 0 to 255 while date == Date[counter2] do close[counter2];
Plot YTDReturn = ((close/janFirstClose)-1)*100;
AssignBackgroundColor(if YTDReturn > 0 then color.Green else color.Red);

So for example i get this data for NIO: -8.63 today when its trading at 30.5. i would have to look back to jan 19 2021, which tos says closed at 58.44 which would be a 58.44/30.5= 91% drop.

If it were back to the open of Jan22, when it traded at 33.47 on jan 3 2022 = 33.47/30.5 = 9.7%.

Any ideas what I might be doing wrong?

Thanks

i'm not sure how far back you want to look back.
in your 1st sentence, you mention YTD , year to date. which implies a change since the beginning of the year.
later you mention looking back to jan 19 , 2021 ?? which implies 1 year ago.

the study is looking at data from the 1st trading day of the year, so YTD.


then this
... 58.44/30.5= 91% drop. which is wrong. 58.44 to 30.50 is a 48% drop.
... at 33.47 on jan 3 2022 = 33.47/30.5 = 9.7%. 33.47 to 30.5 is a 8.9% drop

------------------------------------

to test your study, i copied it into a column. i set the time to day.

i set it to the most basic version it could be.
i changed it to plot just counter2, so i could see what index it was using.
the numbers in the column came out to 10. 10 days before today was the first day of the year.
that part is working.

def date = getYear();
def JanFirstClose = fold counter2 = 0 to 255
  while date == Date[counter2]
  do counter2;
plot z = JanFirstClose;

then i changed it so it just displayed the close price of x bars ago. (now i know it to be 10 bars ago, jan 3)
i compared the column numbers of several stocks, to chart bars and verified the prices are from jan 3.

def date = getYear();
def JanFirstClose = fold counter2 = 0 to 255
  while date == Date[counter2]
  do close[counter2];
plot z = JanFirstClose;

it is getting the correct daily close price, of the first trading day of the year.
so either that isn't the date you think it is or your % math is wrong.