StockFetcher Forums · Filter Exchange · MACD 52 Week Low<< >>Post Follow-up
snappyfrog
178 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.

Fetcher[
volume > 200000
price between 1 and 10
MACD Histogram(12,26,9) equals 52 week low
and stocks where shares outstanding is below 20
add column MACD Histogram(12,26,9)
add column MACD Histogram(12,26,9) 1 day ago
]



mahkoh
1,052 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
178 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,052 posts
msg #141252
Ignore mahkoh
modified
1/22/2018 2:15:46 PM

Fetcher[
volume > 200000
price between 1 and 10
MACD Histogram(12,26,9) reached a new 52 week low 2 days ago
MACD Histogram(12,26,9) 1 day ago above MACD Histogram(12,26,9) 2 days ago
and stocks where shares outstanding is below 20
add column MACD Histogram(12,26,9) 2 days ago
add column MACD Histogram(12,26,9) 1 day ago
]



snappyfrog
178 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
178 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
178 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
178 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
178 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
178 posts
msg #142201
Ignore snappyfrog
2/13/2018 8:19:18 PM

This is what I have come up with so far.

Fetcher[
market is not etf
market is not otcbb
volume > 200000
price between 1 and 10
MACD Histogram(12,26,9) equals 52 week low
MACD fast line(12,26) is approaching MACD slow line(12,26) from below
and stocks where shares outstanding is below 20
add column MACD Histogram(12,26,9)
add column MACD Histogram(12,26,9) 1 day ago
]



StockFetcher Forums · Filter Exchange · MACD 52 Week Low<< >>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