| tylercabral 23 posts
 msg #155866
 - Ignore tylercabral
 | 2/19/2021 10:44:29 AM 
 Hello,
 I am looking for help creating a filter that shows the count of days a stock has lost 15% over the last 10 days.  I have a simple -15% filter:
 
 show stocks where close lost more than 15 percent over the last one day
 
 and another count filter that shows days over 30mil in vol in the last 10 days:
 
 /*open to close gain*/
 set{volume,close/open}
 set{10vol,count(volume above 30,000,000,10)}
 10vol above 0
 add column 10vol
 
 I believe the answer is somewhere in here, I just cant seem to combine the ingredients in the correct manner.  Any help is appreciated.
 
 
 | 
| redversa721 157 posts
 msg #155871
 - Ignore redversa721
 modified
 | 2/19/2021 2:29:38 PM 
 What about this
 
 
 
 
 | 
| redversa721 157 posts
 msg #155872
 - Ignore redversa721
 modified
 | 2/19/2021 3:04:00 PM 
 I did not see the part where you wanted to count the number of days, you can edit out the average col and market . I just use that to reduce number of results.
 You can also similarly add the count of volume and incorporate that as well
 Good Luck, see this if it works
 
 
 
 
 
 
 
 | 
| tylercabral 23 posts
 msg #155876
 - Ignore tylercabral
 | 2/20/2021 8:33:53 AM 
 I cannot thank you enough!  That is extremely helpful :D Thank you friend.
 
 
 |