snappyfrog
749 posts
msg #141194
- Ignore snappyfrog |
1/20/2018 1:18:51 PM
I am trying to make a scan where I find the MACD 52 week low 1 day ago and the MACD yesterday is higher than the 52 week low.
This is what I have so far. I find the stocks that have hit the 52 week low, but need help with moving it back 1 day and getting the value of yesterday higher.
Thanks in advance for any help.
|
mahkoh
1,065 posts
msg #141225
- Ignore mahkoh |
1/21/2018 1:16:07 PM
If it made a new 52 week low today, how can yesterday's value NOT be greater?
|
snappyfrog
749 posts
msg #141233
- Ignore snappyfrog |
1/21/2018 8:36:40 PM
Maybe I said that wrong. I want the 52 week low to be 2 days ago and yesterday to be higher. Otherwise, yesterday could be the same value - same as the 52 week low.
|
mahkoh
1,065 posts
msg #141252
- Ignore mahkoh
modified |
1/22/2018 2:15:46 PM
|
snappyfrog
749 posts
msg #141292
- Ignore snappyfrog |
1/23/2018 7:16:55 PM
Thanks Mahkoh. I see my error now. I was saying the MACD above the MACD 2 days ago without adding the "1 day ago" before the "above" statement. Makes perfect sense now. Thank you.
|
snappyfrog
749 posts
msg #141295
- Ignore snappyfrog |
1/23/2018 7:39:46 PM
Now a new problem: How to find the 52 week avg value of the Histogram and find a 52 week low that is twice as low as the 52 week avg. Is that even possible to do in SF?
|
snappyfrog
749 posts
msg #141296
- Ignore snappyfrog |
1/23/2018 7:46:13 PM
Well I can draw the MACD Histogram 52 week high on the chart, so I assume I will need a "set" statement to get the value of both the high and the low and then a statement to say the value of the low is 2x less than the value of the high. Just thinking out loud.
|
snappyfrog
749 posts
msg #141297
- Ignore snappyfrog |
1/23/2018 7:48:15 PM
Actually I would have to figure the avg between the high and low for 52 weeks and then values for the low 2x lower than the avg. Sorry if I am confusing anyone.
|
snappyfrog
749 posts
msg #141337
- Ignore snappyfrog |
1/24/2018 5:56:34 PM
I've decided on a different strategy and will post in a few days.
|
snappyfrog
749 posts
msg #142201
- Ignore snappyfrog |
2/13/2018 8:19:18 PM
This is what I have come up with so far.
|