summarize watchlist column

[Bambamr]

is there a way to summarize or total a column of a watchlist?

I created a watchlist custom column that tells me if each symbol in the watchlist is at a seven period hi. I then sort this watch list by the new column. I find it interesting to watch the number of symbols at a high go up and down. (to me, it is almost like watching the watchlist "breathe"). Is there a way I can add up the number of highs and then maybe chart that number over time?

Here's my custom column
plot sevenbarhi = close >= highest(close,7);

 

[halcyonguy]

is there a way to summarize or total a column of a watchlist?

I created a watchlist custom column that tells me if each symbol in the watchlist is at a seven period hi. I then sort this watch list by the new column. I find it interesting to watch the number of symbols at a high go up and down. (to me, it is almost like watching the watchlist "breathe"). Is there a way I can add up the number of highs and then maybe chart that number over time?

Here's my custom column
plot sevenbarhi = close >= highest(close,7);

no, a column study running on 1 row, doesn't know about the other rows.

i would change your formula, to be a %. then show those numbers, and sort the column.
set the time to an hour , with a price range factor of 0.2


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

column study

column link
http://tos.mx/Tv125Ez

# sevenbarhi2

# column study 
# https://usethinkscript.com/threads/summarize-watchlist-column.11950/
#plot sevenbarhi = close >= highest(close,7);

def factor = 0.2;
def r1 = factor * 1;
def r2 = factor * 2;
def r3 = factor * 3;
def r4 = factor * 4;

def hi = highest(close,7);
plot sevenbarhi = round((100 * (close - hi) / hi), 1);
sevenbarhi.setdefaultcolor(color.black);

assignBackgroundColor(
if sevenbarhi > -r1 then color.white
else if sevenbarhi > -r2 then color.light_green
else if sevenbarhi > -r3 then color.green
else if sevenbarhi > -r4 then color.dark_green
else color.orange);
#

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

other studies for testing

upper

# sevenbarhi2_upper

def factor = 0.2;
def r1 = factor * 1;
def r2 = factor * 2;
def r3 = factor * 3;
def r4 = factor * 4;

def hi = highest(close,7);
plot z = hi;

def sevenbarhi = round((100 * (close - hi) / hi), 1);

addlabel(1, sevenbarhi + "%",
if sevenbarhi > -r1 then color.white
else if sevenbarhi > -r2 then color.light_green
else if sevenbarhi > -r3 then color.green
else if sevenbarhi > -r4 then color.dark_green
else color.orange);
#

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

lower

# sevenbarhi2_lower

declare lower;

def factor = 0.2;
def r1 = factor * 1;
def r2 = factor * 2;
def r3 = factor * 3;
def r4 = factor * 4;

def hi = highest(close,7);
plot sevenbarhi = round((100 * (close - hi) / hi), 1);
sevenbarhi.setdefaultcolor(color.yellow);

addlabel(1, sevenbarhi + "%",
if sevenbarhi > -r1 then color.white
else if sevenbarhi > -r2 then color.light_green
else if sevenbarhi > -r3 then color.green
else if sevenbarhi > -r4 then color.dark_green
else color.orange);
#