StockFetcher Forums · Filter Exchange · Attn: FILTER GURUS! WT*!!!<< 1 2 >>Post Follow-up
JoeyVinyl
125 posts
msg #151214
Ignore JoeyVinyl
3/13/2020 6:15:19 PM

This is why I'm not a filter guru either. The one thing I didn't include was to screen out stocks that are not lower than the close 30 day ago, so the minus sign on EQUX is because the last close is higher than it was 30 days ago. Stick with Cheese's filter. It's much closer to what you were looking for.

xarlor
587 posts
msg #151216
Ignore xarlor
3/13/2020 7:09:33 PM

Fetcher[
/* Looking for stocks that dropped the LEAST, but no more than 10% from the close 30 days ago */
not etf
close > 490
volume > 500000

set{c30,close 30 days ago}
set{10p,c30 * .90}
close > 10p

set{Pchange1,close / c30}
set{Pchange2,Pchange1 - 1}
set{Pchange,Pchange2 * 100}

add column c30 {Close 30 days ago}
add column 10p {10% below close 30 days ago}
add column Pchange {Percent Change}

sort by column 7 descending
]



karennma
8,057 posts
msg #151217
Ignore karennma
3/13/2020 8:18:08 PM

@ Xarlor,
Okay! Got it!
Thanks!

karennma
8,057 posts
msg #151218
Ignore karennma
modified
3/13/2020 8:31:58 PM

@ Joey Vinyl
*and*
@ Xarlor,
Your %s are identical !
Your %s are the same. (I figured out which ones should have the -(minus) signs.)
That's all I care about .. %s.
I wanted to run both your filters so everyone can see the results (using >190) but I don't know how to do screenshots.*
THANK YOU!

I'm sure after working on this, you saw some gems in there!
$$$$$$$$


Edit:
*Dang it! I just tried to do the screenshots. Too many steps!
My apologies.



karennma
8,057 posts
msg #151219
Ignore karennma
3/13/2020 8:38:43 PM

JoeyVinyl
54 posts
msg #151214
- Ignore JoeyVinyl 3/13/2020 6:15:19 PM
This is why I'm not a filter guru either.
================================

Yes, you are!
I was doing the math backasswards. I'm so good at being bad in math, I could convince Albert Einstein that 2+2=6

nibor100
1,046 posts
msg #151225
Ignore nibor100
3/14/2020 4:25:05 PM

@karennma,

The only way I know of to change to Table View in your filter results is to click on the box named "Table" that is below the filter edit window and above the results part of the screen.

Here is a smaller version of the filter showing all stocks >$190 with volume >500K who have had 30 day price drops; and sorted from smallest price drop to largest. (will the biggest drops rebound the most....who knows?)

Fetcher[
market is not ETF close is > 190 volume is > 500000
roc(30,1) is less than 0
add column roc(30,1) {30 day %price drop} sort on column 5 descending
]



karennma
8,057 posts
msg #151238
Ignore karennma
3/15/2020 7:47:10 PM

nibor100
446 posts
msg #151225
- Ignore nibor100 3/14/2020 4:25:05 PM

@karennma,
(will the biggest drops rebound the most....who knows?)
===========================================

Hahaha! I was thinking the stocks with the smallest drop would be the safest long term holds.
Thanks for the filter.



StockFetcher Forums · Filter Exchange · Attn: FILTER GURUS! WT*!!!<< 1 2 >>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.