karennma
8,057 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?)
|
Cheese
1,374 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"
|
karennma
8,057 posts
msg #151200
- Ignore karennma
modified |
3/13/2020 10:49:05 AM
Thanks, Cheese.
|
JoeyVinyl
125 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.
|
JoeyVinyl
125 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
8,057 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
8,057 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
8,057 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
8,057 posts
msg #151211
- Ignore karennma
modified |
3/13/2020 4:39:27 PM
|
karennma
8,057 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!)
|