Color Coded Gap Watchlist Columns for ThinkorSwim

[ZION]

@Sonny, Thanks!

 

[rlohmeyer]

This thread has been extremely useful in developing watchlist columns to filter candidates for trading based on bullish signs. I have columns related to percent change from close and relative volume for both premarket and the regular trading session. Picture is below.

I am having trouble with one column I would like to use as a final filter for chosing candidates after the market opens. Presently it is based on just the close price being above the open. It is the first column in the watchlist and it gives me a green go or red no.
The coding for this watchlist plot is:

#Close above Open:
def AP = AggregationPeriod.DAY;
input cl = close;
input op = open;
plot co = cl>op;
co.assignValueColor(if cl>op then color.green else color.red);

However I would like to plot 2 conditions within the column indicator but cannot figure out the coding for the plot. I would also like it to give me binary response, say 0 for no and 1 for yes, like the above code. Here is what I have thus far. Anyone help I could get would be appreciated. I have learned a lot about coding recently and been able to cobble together quite a bit. But am stumped here yet again.

#Open above Yesterday Close and Close Above Open:
def ap = AggregationPeriod.DAY;
def op = open(period = ap);
def ycl = close(period = ap)[1];
def cl = close;
def cond = op > ycl[1] and cl>op;

 

[Robby Luca]

Found script in here that @Sonny posted to get Relative Volume during Premarket.

Some results are NaN. Is there a way to fix that?
Also, there script only works during premarket and does not make sense during regular hours. Any way to fix that?

def isRollover = GetYYYYMMDD() != GetYYYYMMDD()[1];
def beforeStart = GetTime() < RegularTradingStart(GetYYYYMMDD());
def vol = if isRollover and beforeStart then volume else if beforeStart then vol[1] + volume else Double.NaN;

def PMVol = if IsNaN(vol) then PMVol[1] else vol;
def Agg = AggregationPeriod.DAY;
def AvgVol = average(Volume(period=Agg),60)[1];

def RV = Round((PMVol/AvgVol),2);
#def L = Lg(RV);
#def p = if L>=1 then 0 else if L>=0 then 1 else 2;
#def y2 = Round(RV,p);

plot z = RV;

Third question; there's a part of the code I do not use. Can anyone explain what it does and why it's in there?

#def L = Lg(RV);
#def p = if L>=1 then 0 else if L>=0 then 1 else 2;
#def y2 = Round(RV,p);

 

[axlerod]

No, this was a column for Premarket Relative Volume but did not work. You can get the PM relative volume as a chart label in my other thread.

So after reading through everything slightly confused.

I have 2 scripts for RV1

This one referring to this post https://usethinkscript.com/threads/color-coded-watchlist-columns-for-thinkorswim.2977/post-28578

def isRollover = GetYYYYMMDD() != GetYYYYMMDD()[1];
def beforeStart = GetTime() < RegularTradingStart(GetYYYYMMDD());
def vol = if isRollover and beforeStart then volume else if beforeStart then vol[1] + volume else Double.NaN;
def PMV = if IsNaN(vol) then PMV[1] else vol;
def AV = AggregationPeriod.DAY;
def x = Average(Volume(period=AV)[1],60);
def y1 = Round((PMV/x),2);
def L = Lg(y1);
def p = if L>=1 then 0 else if L>=0 then 1 else 2;
def y2 = Round(y1,p);
plot z = y2;
z.assignValueColor(if z>=10 then color.CYAN else if z>=1 then createcolor(255,153,153) else createcolor(0,215,0));

The the original code on page 1

def x = Average(volume, 60)[1];
def v = volume;
plot r = Round((v/x),1);
r.assignValueColor(if r >= 20 then color.CYAN else if r>=5 then createcolor(255,153,153) else createcolor(0,215,0));

Which one do I use? Or Do i use both and one called Pre Market RV1 and the other RV1 ?

Thank you very much also the other columns you posted on page 1 I set all to 1d time is that correct? @sunny

 

[bss05]

Using the RV1 is incredibly helpful. Thanks so much Sonny. Is there any way one can make a scan that only accepts stocks with an RV1 over a certain amount? Be amazing to just have ones over 20 RV or so.

 

[murkr]

@bss05 This may help: https://usethinkscript.com/threads/...egy-and-momentum-scanner-for-thinkorswim.3002

I've never created a watchlist before. Can someone share a tutorial on how to add the info in post #1 to my scan section in TOS?

@Sonny If I'm setting this put and I plan to look at the 1-minute chart on gapped stocks should I change this to 1-minute (see picture) for all of the entries in post #1 or should I keep it as the default D?

The RV calculation is (today's volume) / (60 day average daily volume). When you put in the column code, make sure you mark D for day for next to Column Name.

EDIT: after reading through the pages I found this. So I'm going to set all of them to D even though ill be looking at the 1-minute chart.

 

[scubasteve513]

@Sonny everytime try to add this to my watchlist under Custom I get invalid statements specifically concerning the parts of the code I highlighted, the following is the errors that show as well, any help you can give would be much appreciated.

Invalid statement: Cyan at 1:1
Invalid statement: CO at 37:1
Invalid statement: L1 at 47:1
Invalid statement: RV1 at 59:1

 

[BenTen]

@coolvoice3 I believe so

 

[GTRudeBoy]

Anyone else have issues with the data taking along time to load?

 

[bulldog737]

@Sonny Hey I saw that someone had something similar to this, but with the scan results it would bring up strong ut (for strong uptrend), neutral ut and such. Would you know how to build something like that?

 

[Madhu]

I have developed color coded watchlist columns which can be very helpful, especially when looking at a gap scan on the left while tracking charts on the right. These are color coded based on values. The columns eliminate all those extra zeros at the end and make it easy to spot big values. The codes are listed below. Please pass it on!

Cyan - highest
Red - 2nd highest
Green - 3rd highest
Yellow - lowest

C1 – <20, 20-40, >40
CO – <0, 0-20, 20-40, >40
L1 – 1-5, 5-10, >10
RV1 – 0-5, 5-20, >20

C1

#Pct Change from Yesterday Close
def AP = AggregationPeriod.DAY;
def y = close(period = AP)[1];
def x = Round(100*((close/y)-1),1);
plot z=x;
z.assignValueColor(if z>=40 then color.CYAN else if z>=20 then createcolor(255,153,153) else createcolor(0,215,0));

CO

#Percent change from open
plot x = Round(100*((close/open)-1),1);
x.assignValueColor( if x >=40 then color.CYAN else if x>=20 then createcolor(255,153,153) else if x>=0 then createcolor(0,215,0) else color.YELLOW);

L1

#Rounded Last
def L = Round(close,2);
plot x = L;
x.assignValueColor(if x>=10 then color.CYAN else if x>=5 then createcolor(255,153,153) else createcolor(0,215,0));

RV1

#Relative Volume
def x = Average(volume, 60)[1];
def v = volume;
plot r = Round((v/x),1);
r.assignValueColor(if r >= 20 then color.CYAN else if r>=5 then createcolor(255,153,153) else createcolor(0,215,0));

Hi Everyone,

I have few conserns, I have set up the watch list columns and set up the scan, I was trying to run the scan from 9:30 AM EST to 10:15 AM EST but It is not giving any results.

 

[tarmander]

Is there a way to have the first 15 minutes of volume as a column?

I can do it with a lower study like this:


input startTime15 = 0930;
input endTime15 = 0944;

def Active = SecondsFromTime(startTime15) >= 0 and SecondsTillTime(endTime15) >= 0;
def Vol15Mins = if Active and !Active[1] then volume
else if Active then (Vol15Mins[1] + volume)
else (Vol15Mins[1]);

plot vol15 = Vol15mins;


But when I try this as a column it gives a totally different value and it doesn't stop growing after 15 minutes

 

[tarmander]

its all good. The script I posted actually works for what I was trying to do, you just have to change the custom column time frame from daily to an intraday time frame. Thanks for circling back

 

[DudeDastic]

Is there an RVOL indicator that looks like a histogram as seen in this video? Using the RVOL Indicator to aid Trend and Trading Range Predictions | Part 7

 

[merryDay]

@DudeDastic The video appears to be the standard RVOL indicator w/ painted bars?
The last script in post#1 paints the RVOL bars. You will need to adjust what volume levels are associated with what colors.

 

[Juno (Best Day EVER)]

@bss05

You could have bought FRAN at less than $4.50 this morning. If you track your premarket scanner on TOS, it spiked at 7:30 when the news came out. You just wait for the pullback and then buy it. Then just hold it as long as it stays above VWAP and you can make 100% return in premarket.

Here is what I use for Premarket Scan:
Last: 0.2 to 15
Volume: 5000 to No Max
Custom Study Filter: After Hours Change, the close is greater then 10% (under Price Performance); check the Ext box and select 1m on the right.

As soon as you see FRAN pop up in the scan, just check the news in TOS, and buy it once it has the small pullback at 7:31.

Brilliant- I cant wait to try it out. I have the columns loaded- edit i see how to add the scan now!!! pasting here for others... "These codes are only for watchlist columns. To use these, go to a scan and click Customize at top right. Then add each code separately to Custom column. Once you do that, there should not be any errors. These values only work after 9:30am."

TY!!

 

[cswu1211]

Brilliant- I cant wait to try it out. I have the columns loaded- I cannot get the settings on the scan. I have the custom study filter open, have added a condition, I chose "close" in the price drop down on the left and then in the center chose "is greater than" I cannot find a way to choose 10% for the right side of the condition wizard... Can you please help?

@bss05

You could have bought FRAN at less than $4.50 this morning. If you track your premarket scanner on TOS, it spiked at 7:30 when the news came out. You just wait for the pullback and then buy it. Then just hold it as long as it stays above VWAP and you can make 100% return in premarket.

Here is what I use for Premarket Scan:
Last: 0.2 to 15
Volume: 5000 to No Max
Custom Study Filter: After Hours Change, the close is greater then 10% (under Price Performance); check the Ext box and select 1m on the right.

As soon as you see FRAN pop up in the scan, just check the news in TOS, and buy it once it has the small pullback at 7:31.

Which “custom study” do you use?!

 

[Juno (Best Day EVER)]

Which “custom study” do you use?!

I thought that meant add a filter in scan called "study" prom the dropdown in scanning. then dropdown to the bottom of the study choices to the one at the bottom that is called custom. and from there you get to the thinkscript editor or the condition wizard which I described in detail what I am doing there- but I canot get it to load...