StockFetcher Forums · Filter Exchange · Attn: FILTER GURUS! WT*!!!<< 1 2 >>Post Follow-up
karennma
7,625 posts
msg #151197
Ignore karennma
3/13/2020 8:56:00 AM

What is wrong with this filter?
Looking for stocks that dropped the LEAST but the math is off ....
(isn't it?)
Fetcher[
add column high 30 day high
Price dropped less than 10% over the last 30 days
not etf
close > 490
volume > 500000

]



Fetcher[
Price dropped less than 10 percent over the last 30 days
close > 500
volume > 500000

add column high 30 day high
]





Cheese
646 posts
msg #151198
Ignore Cheese
3/13/2020 10:19:28 AM

@karennma

I'm not a guru in anything, so I'm guessing that
"Price dropped less than 10 percent over the last 30 days"
compares to the close 30 days ago
not to your "high 30 day high"

Fetcher[
Price dropped less than 10 percent over the last 30 days
close > 500
volume > 500000
add column high 30 day high
add column close 30 days ago
add column roc(30,1)
]



karennma
7,625 posts
msg #151200
Ignore karennma
modified
3/13/2020 10:49:05 AM

Thanks, Cheese.



JoeyVinyl
90 posts
msg #151206
Ignore JoeyVinyl
3/13/2020 3:20:57 PM

I don't think there's anything wrong with it. I used more words in mine than either you or Cheese did but got the same results as both of you.

Fetcher[market is not ETF
set {30dp, close 30 days ago}
set {drop, 30dp - close}
set {pct1, drop / 30dp}
set {pct, pct1 * 100}
show stocks where close is > 490
and volume is > 500000
and pct is < 10
add column separator
add column high 30 day high
add column drop
add column pct
sort column 8 ascending
]



JoeyVinyl
90 posts
msg #151207
Ignore JoeyVinyl
3/13/2020 3:23:19 PM

Forgot to add that like Cheese, I'm guessing your 10% drop is from the close 30 days ago and not the 30 day high. Doing it from the high gave nothing that was 10% or less of a drop.

karennma
7,625 posts
msg #151208
Ignore karennma
3/13/2020 4:27:13 PM

@ JoeyVinyl,
Re: "Doing it from the high gave nothing that was 10% or less of a drop."
=====================================

Ha! Glad you clarified that.
I hadn't read your 2nd message & was wondering about those last 2 columns.
Thanks!



karennma
7,625 posts
msg #151209
Ignore karennma
3/13/2020 4:31:21 PM

JoeyVinyl,
Wow! I'm dense.
I still don't understand those last 2 columns.
Why are there - (minus) signs?


karennma
7,625 posts
msg #151210
Ignore karennma
modified
3/13/2020 4:34:37 PM

Joey Vinyl,
I'm guessing your 10% drop is from the close 30 days ago and not the 30 day high.
=============================================================
Yes, you're right. So that 6-week column should NOT be 6-week high, ... should it be close 30 days ago?
Or a 30 day low column?

I dunno .... ?
I still don't understand Y the minuses are there.

BTW, I changed > 490 to > 190 --- got more pics for verification.

karennma
7,625 posts
msg #151211
Ignore karennma
modified
3/13/2020 4:39:27 PM

Fetcher[
market is not ETF
set {30dp, close 30 days ago}
set {drop, 30dp - close}
set {pct1, drop / 30dp}
set {pct, pct1 * 100}
show stocks where close is > 190
and volume is > 500000
and pct is < 10
add column separator
add column high 30 day high
add column drop
add column pct
sort column 8 ascending
change to table view
]



karennma
7,625 posts
msg #151212
Ignore karennma
modified
3/13/2020 4:42:36 PM

For example, Regeneron - the drop is $35 (not $129.37). The % change is 6.8% (not -38.48)
So, I don't understand what -129.37 and -38.48 represent.

(I don't know why "change to table view" doesn't work either. LOL!)

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 2018 - 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