StockFetcher Forums · Filter Exchange · Help with this filter - Count of days where change is -15%<< >>Post Follow-up
tylercabral
21 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
153 posts
msg #155871
Ignore redversa721
modified
2/19/2021 2:29:38 PM

What about this
Fetcher[set{close1,close}
set{close10, close 10 days ago}
set{cprt,close1-close10}
set{cprtp,cprt/close1}
set{cprtp1,cprtp*100}


market market is not (ETF or OTCBB)
show stocks where close is 15% less than close 10 days ago


add column close1
add column close10
add column cprtp1
]



redversa721
153 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



Fetcher[Average Volume(30) >500000
market is NASDAQ

show stocks where count(Day Change is less than -15%,10) is above 1
and add column count(Day Change is less than -15%,10)
]



tylercabral
21 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.

StockFetcher Forums · Filter Exchange · Help with this filter - Count of days where change is -15%<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.