Drop Below 9 ema and 20 ema on the Daily Candle

[pgoebel6]

Hello, I am not familiar with code but I was hoping someone could help me with the process for writing this code. I am looking to scan the market at close for stocks that open above the 9 and 20 ema and closed below both of them. I also want the 9 ema to be higher than the 20 ema. I have attached a couple of screenshots of what I am looking for.

 

[halcyonguy]

Hello, I am not familiar with code but I was hoping someone could help me with the process for writing this code. I am looking to scan the market at close for stocks that open above the 9 and 20 ema and closed below both of them. I also want the 9 ema to be higher than the 20 ema. I have attached a couple of screenshots of what I am looking for.

i made an upper study to test.
then made a column study.
then modified it to make a scan.

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

possible scan study (not tested)

# scan_sell
#https://usethinkscript.com/threads/drop-below-9-ema-and-20-ema-on-the-daily-candle.16786/
#Drop Below 9 ema and 20 ema on the Daily Candle

def na = double.nan;
def bn = barnumber();

def price = close;

#--------------------
# avg 1 & 2

input ma1_len = 9;
def len1 = if ma1_len == 0 then 1 else ma1_len;
input ma1_type =  AverageType.EXPONENTIAL;
def ma1 = MovingAverage(ma1_type, price, len1);

input ma2_len = 20;
def len2 = if ma2_len == 0 then 1 else ma2_len;
input ma2_type =  AverageType.EXPONENTIAL;
def ma2 = Movingaverage(ma2_type, price, len2);

def xup = ma1 crosses above ma2;
def xdwn = ma1 crosses below ma2;
def up = ma1 > ma2;
def dwn = ma1 < ma2;

#  open above the 9 and 20 ema and closed below both of them
def sell_rule1 = (open > ma1 and open > ma2 and close < ma1 and close < ma2);
#  also the 9 ema > 20 ema
def sell_rule2 = (ma1 > ma2);
def sell = (sell_rule1 and sell_rule2);

def buy_rule1 = (open < ma1 and open < ma2 and close > ma1 and close > ma2);
def buy_rule2 = (ma1 < ma2);
def buy = (buy_rule1 and buy_rule2);

plot z = if sell then 1 else 0;
#

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

test study
column study - set to day

zemax1
http://tos.mx/qmDAlnl

# zemax1

# mod the upper study for column
# price_below_ema_day_close

#https://usethinkscript.com/threads/drop-below-9-ema-and-20-ema-on-the-daily-candle.16786/
#Drop Below 9 ema and 20 ema on the Daily Candle
#pgoebel6  10/11

# scan the market at close for stocks that,
#  open above the 9 and 20 ema and closed below both of them
#  also the 9 ema > 20 ema


#def lastbar = !isnan(close[0]) and isnan(close[-1]);

def na = double.nan;
def bn = barnumber();

def price = close;

#--------------------
# avg 1 & 2

input ma1_len = 9;
def len1 = if ma1_len == 0 then 1 else ma1_len;
input ma1_type =  AverageType.EXPONENTIAL;
def ma1 = MovingAverage(ma1_type, price, len1);

input ma2_len = 20;
def len2 = if ma2_len == 0 then 1 else ma2_len;
input ma2_type =  AverageType.EXPONENTIAL;
def ma2 = Movingaverage(ma2_type, price, len2);

def xup = ma1 crosses above ma2;
def xdwn = ma1 crosses below ma2;
def up = ma1 > ma2;
def dwn = ma1 < ma2;

#  open above the 9 and 20 ema and closed below both of them
def sell_rule1 = (open > ma1 and open > ma2 and close < ma1 and close < ma2);
#  also the 9 ema > 20 ema
def sell_rule2 = (ma1 > ma2);
def sell = (sell_rule1 and sell_rule2);

def buy_rule1 = (open < ma1 and open < ma2 and close > ma1 and close > ma2);
def buy_rule2 = (ma1 < ma2);
def buy = (buy_rule1 and buy_rule2);

plot z = if buy then 1 else if sell then 0.5 else 0;
z.setdefaultcolor(color.black);

AssignBackgroundColor(if buy then color.green else if sell then color.red else color.gray);
#

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

test study - upper

#price_below_ema_day_close

#https://usethinkscript.com/threads/drop-below-9-ema-and-20-ema-on-the-daily-candle.16786/
#Drop Below 9 ema and 20 ema on the Daily Candle
#pgoebel6  10/11

# scan the market at close for stocks that,
#  open above the 9 and 20 ema and closed below both of them
#  also the 9 ema > 20 ema


#def lastbar = !isnan(close[0]) and isnan(close[-1]);

def na = double.nan;
def bn = barnumber();

def price = close;

#--------------------
# avg 1 & 2

input ma1_len = 9;
def len1 = if ma1_len == 0 then 1 else ma1_len;
input ma1_type =  AverageType.EXPONENTIAL;
def ma1 = MovingAverage(ma1_type, price, len1);

input ma2_len = 20;
def len2 = if ma2_len == 0 then 1 else ma2_len;
input ma2_type =  AverageType.EXPONENTIAL;
def ma2 = Movingaverage(ma2_type, price, len2);

def xup = ma1 crosses above ma2;
def xdwn = ma1 crosses below ma2;
def up = ma1 > ma2;
def dwn = ma1 < ma2;

#  open above the 9 and 20 ema and closed below both of them
def sell_rule1 = (open > ma1 and open > ma2 and close < ma1 and close < ma2);
#  also the 9 ema > 20 ema
def sell_rule2 = (ma1 > ma2);
def sell = (sell_rule1 and sell_rule2);

def buy_rule1 = (open < ma1 and open < ma2 and close > ma1 and close > ma2);
def buy_rule2 = (ma1 < ma2);
def buy = (buy_rule1 and buy_rule2);

addchartbubble(1, low*0.995,
buy + "\n" +
sell
, (if buy then color.green else if sell then color.red else color.gray), no);


# AssignBackgroundColor

input show_lines = yes;
plot z1 = if show_lines and len1 > 1 then ma1 else na;
z1.setdefaultcolor(getcolor(1));
#z1.setlineweight(1);
z1.hidebubble();

plot z2 = if show_lines and len2 > 1 then ma2 else na;
z2.setdefaultcolor(getcolor(2));
#z2.setlineweight(1);
z2.hidebubble();
#