Percentage Change since March Lows Watchlist Column

[BenTen]

I've recently wondered which stocks in my watchlist have the greatest and lowest percentage change since the stock market "crash" in March 2020. Here's a watchlist column and label to help you identify the stock percentage change since the pandemic panic low on March 23.

Watchlist column

# Stocks Percentage Change since March lows
# Assembled by BenTen at UseThinkScript.com

def close_value = close(period = AggregationPeriod.DAY);
def date1 = GetYYYYMMDD() == 20200323;
def date2 = GetYYYYMMDD() == GetYYYYMMDD();
def prev = if date1 then close_value else prev[1];
def current = if date2 then close_value else current[1];

def test = Round((current - prev) / prev);
#AddLabel(yes, Concat("", test), color.orange);

AddLabel(1, "" + AsPercent(test), color.orange);

For your watchlist column, be sure to set the aggregation period to D for Daily.

Label for your chart

# Stocks Percentage Change since March lows
# Assembled by BenTen at UseThinkScript.com
def close_value = close(period = AggregationPeriod.DAY);
input source = 20200323;
def date1 = GetYYYYMMDD() == source;
def date2 = GetYYYYMMDD() == GetYYYYMMDD();
def prev = if date1 then close_value else prev[1];
def current = if date2 then close_value else current[1];

def test = Round((current - prev) / prev);
#AddLabel(yes, Concat("Change since March's low = %", test), color.orange);

AddLabel(1, "Change since March's low = " + AsPercent(test), color.orange);

 

[StockTect2020]

How do I add this to my watchlist?

 

[BenTen]

@StockTect2020 Watch the second half of the video below: