Rocket Stocks for Swing and Positional

@Happy_Singh Bro can you create an AFL for the query which is used in this thread.This is for the sake of filtering. If it is too much time consuming then leave it.
The logic part is here.

https://chartink.com/screener/copy-muathe-super-bullish-3


Scan Description:
1)
RSI(14) ON MONTHLY CHARTS MUST CROSS 3 YRS HIGH AND ALSO IF CROSSES 69.10 THEN SUPER BULLISH +
2)
[MACD(12,26,9) OR MACD(5,8,3) ] EITHER OF 2 MACD ABOVE MUST BE IN BUY MODE
THIS SCANNER PICKS STOCKS WHICH ARE READY TO BLAST BY 200% TO 500% IN COMING 2 TO 3 YRS
The above is from the link you provided, scanner looks simple enough,
good clean data with proper adjustments for bonus/rights and splits would be a challenge . .

Have made some assumptions like
1) Scanner/exploration using Monthly Data / Time frame
2) To define a 3 Year High on RSI(14) using previous 36 monthly values on Monthly TF, and
3) The Buy Mode for MACD for the above scanner is Signal Line is above MACD Line

Code:
//RSI(14) ON MONTHLY CHARTS MUST Cross 3 YRS High AND ALSO if CROSSES 69.10 THEN SUPER BULLISH +

R = RSI(14);
Cond_01a = R > Ref(HHV(R,36),-1); // Current Monthly RSI is > Previous 36 Months
Cond_01b = R > 69.01;

Cond_01 = Cond_01a OR Cond_01b;

// [MACD(12,26,9) OR MACD(5,8,3) ] EITHER OF 2 MACD ABOVE MUST BE IN BUY MODE

Cond_02a = Signal(12,26,9) > MACD(12,26); // Buy 01 on Monthly MACD
Cond_02b = Signal( 5, 8,3) > MACD( 5, 8); // Buy 02 on Monthly MACD

Cond_02 = Cond_02a OR Cond_02b;
UP = Cond_01 AND Cond_02;

Filter = UP;
AddColumn(R, "RSI");
AddColumn(Signal(12,26,9),"SGNL_01");
AddColumn(MACD(12,26),"MACD_01");
AddColumn(Signal(5,8,3),"SGNL_02");
AddColumn(MACD(5,8),"MACD_02");
Try it and let me know if its working as your requirements


.
 

sanju005ind

Investor, Option Writer
The above is from the link you provided, scanner looks simple enough,
good clean data with proper adjustments for bonus/rights and splits would be a challenge . .

Have made some assumptions like
1) Scanner/exploration using Monthly Data / Time frame
2) To define a 3 Year High on RSI(14) using previous 36 monthly values on Monthly TF, and
3) The Buy Mode for MACD for the above scanner is Signal Line is above MACD Line

Code:
//RSI(14) ON MONTHLY CHARTS MUST Cross 3 YRS High AND ALSO if CROSSES 69.10 THEN SUPER BULLISH +

R = RSI(14);
Cond_01a = R > Ref(HHV(R,36),-1); // Current Monthly RSI is > Previous 36 Months
Cond_01b = R > 69.01;

Cond_01 = Cond_01a OR Cond_01b;

// [MACD(12,26,9) OR MACD(5,8,3) ] EITHER OF 2 MACD ABOVE MUST BE IN BUY MODE

Cond_02a = Signal(12,26,9) > MACD(12,26); // Buy 01 on Monthly MACD
Cond_02b = Signal( 5, 8,3) > MACD( 5, 8); // Buy 02 on Monthly MACD

Cond_02 = Cond_02a OR Cond_02b;
UP = Cond_01 AND Cond_02;

Filter = UP;
AddColumn(R, "RSI");
AddColumn(Signal(12,26,9),"SGNL_01");
AddColumn(MACD(12,26),"MACD_01");
AddColumn(Signal(5,8,3),"SGNL_02");
AddColumn(MACD(5,8),"MACD_02");
Try it and let me know if its working as your requirements


.
So fast you have developed it. you are a genius man. I maintain EOD data and properly adjust for splits and keep purifying the data and remove unwanted scrips.

Yes it is for monthly charts only.Do i have to use Timeframeset.

Thank you very much I really appreciate your efforts.Once I am home in the evening I will test it.
 
So fast you have developed it. you are a genius man. I maintain EOD data and properly adjust for splits and keep purifying the data and remove unwanted scrips.

Yes it is for monthly charts only.Do i have to use Timeframeset.

Thank you very much I really appreciate your efforts.Once I am home in the evening I will test it.
It is really very simple exploration to code,

No need for Timeframeset if you are running the explorer by setting time frame to Monthly

There was an error in the above code, used OR in the RSI condition, have modified it . .

Code:
R  = RSI(14);                 R36 = HHV(R,36);
M1 =   MACD(12,26);           M2 =   MACD(5,8);
S1 = Signal(12,26,9);         S2 = Signal(5,8,3);

Filter = R > Ref(R36,-1) AND (S1 > M1 OR S2 > M2);

AddColumn(R,"MONTHLY_RSI",1.2,colorDefault,IIf(R >= 69.01,colorRed,colorLightGrey));
AddColumn(S1,"SIGNAL_01",1.2,colorDefault,IIf(S1 > M1,colorBlueGrey,colorLightGrey));
AddColumn(M1,"MACD_01",1.2,colorDefault,IIf(S1 > M1,colorBlueGrey,colorLightGrey));
AddColumn(S2,"SIGNAL_02",1.2,colorDefault,IIf(S2 > M2,colorBlueGrey,colorLightGrey));
AddColumn(M2,"MACD_02",1.2,colorDefault,IIf(S2 > M2,colorBlueGrey,colorLightGrey));

.
 
Last edited:

Raj232

Well-Known Member

Similar threads