Thank you so much for your kind help. It’s working fine:
c1 = close/lowest[252] >=1.8
c2 = Lowest[3](Volume) >= 100000
c3 = close > .50
MyRange = Range
c4 = close >= (close[1] * 0.99)
c5 = close <= (close[1] * 1.01)
Calcul = (MyRange / MyRange[1] - 1) * 100
x = c1 and c2 and c3 and c4 and c5 and Calcul
SCREENER[x]
I am trying to create a scan like IBD Style Relative Strength. The criteria is as follows – 2*(close/close[63]) + close/close[126] + close/close[189] + close/close[252]
I have written following code. Is it possible to capture the results data value in rank (from 1 to 100).
c1 = 2*(close/close[63])
c2 = close/close[126]
c3 = close/close[189]
c4 = close/close[252]
c5 = Lowest[3](Volume) >= 100000
c6 = (close >= 1)
SCREENER[c1 and c2 and c3 and c4 and c5 and c6]
It’s:
c1 = 2*(close/close[63]) + close/close[126] + close/close[189] + close/close[252]
c2 = Lowest[3](Volume) >= 100000
c3 = (close >= 1)
SCREENER[c2 and c3](c1 AS "")
c1 is the criterium, c2 and c3 are the filtering conditions.
But it’s not much clear what you want to achieve.
C1 Criteria has created an extra column as part of results where it’s giving ratings from 1 to 100 based on that criteria.
It’s working fine. Thanks.
I need to scan for the 1 or 2% of stocks that are up the most over these 3 timeframes – 1-month, 3-months, 6-months.
I have written following code. Please advise if this criteria is correct. Thanks.
c1 = (Close/Close[22] >= 2) or (Close/Close[66] >= 2) or (Close/Close[126] >= 2)
c2 = Lowest[3](Volume) >= 100000
c3 = Close >=1
x = c1 and c2 and c3
SCREENER[x]
It’s correct if you add the percentages.
Why do you use “> 2″ and ” > 1″? are they prices or percentages?
You wrote them as price constants.
(Close/Close[22] >= 2) means show all the stocks which are up 100% in last one month
(Close/Close[66] >= 2) means show all the stocks which are up 100% in last three months
(Close/Close[126] >= 2) means show all the stocks which are up 100% in last six months
c3 = Close >=1 means show all the stocks more than One dollar
is this correct?
or
How to add percentages?
I need to create a scan for percent gainer in last one month. I have written following code. Kindly check if this is correct. Thanks.
c1 = Close * Volume/100 >= 100000
//ADR % more than 2.4% in last 20 Days
c2 = 100*((High[0]/Low[0] + High[1]/Low[1]+ High[2]/Low[2]+ High[3]/Low[3]+ High[4]/Low[4]+ High[5]/Low[5]+ High[6]/Low[6]+ High[7]/Low[7]+ High[8]/Low[8]+ High[9]/Low[9]+ High[10]/Low[10]+ High[11]/Low[11]+ High[12]/Low[12]+ High[13]/Low[13]+ High[14]/Low[14]+ High[15]/Low[15]+ High[16]/Low[16]+ High[17]/Low[17]+ High[18]/Low[18]+ High[19]/Low[19])/20-1) >= 2.4
c3 = Close/ Lowest[22]
x = c1 and c2 and c3
SCREENER[x]
It seems correct. Line 3 could be shortened this way:
c2 = 100 * (summation[20](High / Low) / 20-1) >= 2.4
Summation will sum up the condition (High / Low) for all bars from the current one (which is [0]) to the twentieth one (which is [19])
I think you should divide by 20, instead of 20-1, because 0 TO 19 is 20 bars.
It work like a magic.
But I am facing one more challenge. The line 3 in this scan is for one month (c3 = Close/ Lowest[22]) criteria. I need to create same scan for 3 months and 6 months as well. For that I have updated the line 3 for 3 months as (c3 = Close/ Lowest[65]) and for 6 months as (c3 = Close/ Lowest[130]). All the three scans (1 month, 3 months, 6 months) give the same number of stocks. I am not able to understand that why I am getting the same stocks in result for 1 month, 3 months and 6 months even though I am changing the criteria??? Could you please help in this?
c1 = Close * Volume/100 >= 100000
c2 = 100 * (summation[20](High / Low) / 20-1) >= 2.4
c3 = Close/ Lowest[22]
x = c1 and c2 and c3
SCREENER[x]
Because C3 will always be assigned a logically true value (actually I did not notice it earlier this morning).
Any result other than 0, be it negative or positive, is considered TRUE, so despite the periods you may set, the logical value will never change.
You should assign C3 the result of a comparison, like you’ve done for C2 with 2.4.
How can I do that?
is this following formula ok?
c2 = Close / Lowest[22] >=1.1
Does this mean it is showing all stocks which are up 110% in last one month?
Yes, perfect!
Then changing periods will affect results.
Great. That’s working perfect now.
You have shared with me following formula in past to check the range:
MyRange = Range
c4 = close >= (close[1] * 0.99)
c5 = close <= (close[1] * 1.01)
Calcul = (MyRange / MyRange[1] - 1) * 100
How can I update the formula to reflect following condition – Today’s Range % vs ADR > 0.55
