# of days close below MA20 in a watch list.

#1
I have written afl on 1. Price below 20 ma (1 or 0) 2. Number of stocks price below 20ma continuously for three days or more(say 20 days).

I just want to know these two numbers for selected stocks and I filter by a watchlist1 say 50 stocks in total.

But I just want a report and plot the result in graph on how many out of the stock in the watch list for 1 and 2.

E.g.

Date | #P<20 | #days for 3 days p<20

10/4/2014, 30, 25
11/4/2014, 29, 24
Etc

Which function to do the above purpose? Please help. Million thanks.
 
Last edited:

Similar threads