bsterzenbach
2 posts
msg #154431
- Ignore bsterzenbach |
10/25/2020 1:06:54 PM
Hi
What's the cleanest way to show stocks that are trading at or near pandemic prices (generally low of month of March)? Ideally I'd like to see stocks that are no more than 10% above lows during March and any amount below. Filter should return a bunch of regional bank and energy stocks :)
Thank you in advance for any pointers.
Bill
|
Mactheriverrat
3,156 posts
msg #154432
- Ignore Mactheriverrat |
10/25/2020 2:02:12 PM
Might look at -
Show stocks where low reached a low 8 month low within the last 2 weeks
|
snappyfrog
728 posts
msg #154435
- Ignore snappyfrog |
10/25/2020 5:40:31 PM
How about
|
graftonian
1,089 posts
msg #154437
- Ignore graftonian |
10/25/2020 6:42:46 PM
|
fotchstecker
304 posts
msg #154481
- Ignore fotchstecker |
10/28/2020 4:17:20 PM
graftonian or others, how would you calculate the "percent change since X date" and output ot a column for any of these filters?
|
snappyfrog
728 posts
msg #154485
- Ignore snappyfrog |
10/28/2020 10:28:05 PM
|
nibor100
1,042 posts
msg #154487
- Ignore nibor100 |
10/29/2020 3:18:06 AM
@fotchstecker,
If its 250 days or less you could use add column roc(number of days)
or
offset = (number of days)
if its more than 250 days and less than 1,000 days I just use the date drop down box on the results page and fill in the number of days in the bottom box that has a zero in it.
Ed S.
|
fotchstecker
304 posts
msg #154498
- Ignore fotchstecker |
10/29/2020 6:09:18 PM
nibor and snappyfrog, thank you.
|
bsterzenbach
2 posts
msg #154509
- Ignore bsterzenbach |
10/30/2020 4:56:11 PM
Thanks everyone! This was helpful for my current task AND I learned a couple of new tricks.
|