Percent Change Watchlist Column Issue

[BullBear_]

Hello!

I was wondering if the more savvy coders here can help me with the below code. I'd like to get percentage change of underlying for the last month, last 2 weeks and YTD without having to manually update the code everytime. Is this possible?
Thanks!

#follow @KRose_TDA on twitter for updates to this and other custom scripts
#Script below finds the percentage return for the dates inputed
#Enter BegDate and EndDate using YYYYMMDD format (note the dates must
#be market open days Weekends will not work
#You can go back 250 bar days, 105 bar weekly, 110+ bar Monthly
#If you get NAN or other error message, check your dates to make sure they are #trading dates. If that does not correct the problem try using a longer aggregation #like Mo for Month.


input BegDate = 20220103;
input EndDate = 20220902;

def condBegDate = if condBegDate[1] > 0  then condBegDate[1] else if GetYYYYMMDD() == begDate then close else 0;

def condEndDate = if condEndDate[1] > 0  then condEndDate[1] else if GetYYYYMMDD() == endDate then close else 0;

def Pcond = ((condEndDate - condBegDate)/ condBegDate) * 100;
def Days = endDate - begDate;

plot Percnt = (Round(Pcond,2));

Percnt.AssignValueColor(if Percnt > 1.0 then Color.white else if Percnt < -1.0 then Color.white else Color.CURRENT); AssignBackgroundColor(if Percnt > 1.0 then Color.dark_GREEN else if Percnt < -1.0 then Color.dark_RED else Color.CURRENT);

#AddLabel(yes, Concat(Round(Pcond,2), "%"));

 

[SleepyZ]

Hello!

I was wondering if the more savvy coders here can help me with the below code. I'd like to get percentage change of underlying for the last month, last 2 weeks and YTD without having to manually update the code everytime. Is this possible?
Thanks!

#follow @KRose_TDA on twitter for updates to this and other custom scripts
#Script below finds the percentage return for the dates inputed
#Enter BegDate and EndDate using YYYYMMDD format (note the dates must
#be market open days Weekends will not work
#You can go back 250 bar days, 105 bar weekly, 110+ bar Monthly
#If you get NAN or other error message, check your dates to make sure they are #trading dates. If that does not correct the problem try using a longer aggregation #like Mo for Month.


input BegDate = 20220103;
input EndDate = 20220902;

def condBegDate = if condBegDate[1] > 0  then condBegDate[1] else if GetYYYYMMDD() == begDate then close else 0;

def condEndDate = if condEndDate[1] > 0  then condEndDate[1] else if GetYYYYMMDD() == endDate then close else 0;

def Pcond = ((condEndDate - condBegDate)/ condBegDate) * 100;
def Days = endDate - begDate;

plot Percnt = (Round(Pcond,2));

Percnt.AssignValueColor(if Percnt > 1.0 then Color.white else if Percnt < -1.0 then Color.white else Color.CURRENT); AssignBackgroundColor(if Percnt > 1.0 then Color.dark_GREEN else if Percnt < -1.0 then Color.dark_RED else Color.CURRENT);

#AddLabel(yes, Concat(Round(Pcond,2), "%"));

See if this helps

AddLabel(1,  "%Chg: ", Color.WHITE);

def weekchg  = (close - close(period = "WEEK")[2]) / close(period = "WEEK")[2] * 100;
AddLabel(1, " 2wks: " + Round(weekchg) + "%" , if weekchg > 1.0 then Color.GREEN else if weekchg < -1.0 then Color.RED else Color.WHITE);

def monthchg = (close - close(period = "MONTH")[1]) / close(period = "MONTH")[1] * 100;
AddLabel(1, "Month: " + Round(monthchg) + "%", if monthchg > 1.0 then Color.GREEN else if monthchg < -1.0 then Color.RED else Color.WHITE);

def ytdchg   = (close - close(period = "YEAR")[1]) / close(period = "YEAR")[1] * 100;
AddLabel(1, "YTD: " + Round(ytdchg) + "%", if ytdchg > 1.0 then Color.GREEN else if ytdchg < -1.0 then Color.RED else Color.WHITE);

 

[Angela111111]

tos link pls

 

[SleepyZ]

tos link pls

https://tos.mx/pMkF2N2

 

[BullBear_]

@SleepyZ : Much appreciated for helping out! I inserted the code you quoted above however there's a discrepancy with TOS calculations, for example AAPL graph (and the manual code I provided initially) give -14.39% and your suggested code gives -12.25% YTD. Do you know what's causing the difference? Thanks again.

 

[SleepyZ]

@SleepyZ : Much appreciated for helping out! I inserted the code you quoted above however there's a discrepancy with TOS calculations, for example AAPL graph (and the manual code I provided initially) give -14.39% and your suggested code gives -12.25% YTD. Do you know what's causing the difference? Thanks again.

Yes, I used the close of the prior year of 177.57 to compare to the current close. Your chart timeframe starts at 1/3/2022, so you used the close of of 182.01 from that bar. I think the code I provided is correct. TOS will generally only use bar data from bars displayed on the chart you are viewing as in this case.

 

[xleb27]

@SleepyZ : Much appreciated for helping out! I inserted the code you quoted above however there's a discrepancy with TOS calculations, for example AAPL graph (and the manual code I provided initially) give -14.39% and your suggested code gives -12.25% YTD. Do you know what's causing the difference? Thanks again.

that's awesome. can you share your scripts?

 

[halcyonguy]

that's awesome. can you share your scripts?

there is only 6 posts before yours. if you look you will find them.
code, post 2
link, post 4