StockFetcher Forums · General Discussion · How to filter stocks that are about to do a bullish MACD crossover<< >>Post Follow-up
gkanparthy
6 posts
msg #151824
Ignore gkanparthy
4/14/2020 12:01:52 AM

How to filter stocks that are about to do a bullish MACD crossover, but havent yet?

xarlor
585 posts
msg #151827
Ignore xarlor
4/14/2020 11:26:33 AM

Hi gkanparthy! Please provide your definition of a "Bullish MACD crossover."

gkanparthy
6 posts
msg #151829
Ignore gkanparthy
4/14/2020 9:23:56 PM

MACD(12,26,9) Fast Line crossed above MACD(12,26,9) Slow Line

I want to get the picks which are about to make the above macd crossover the next day.

Thanks for your time.

olathegolf
119 posts
msg #151831
Ignore olathegolf
4/14/2020 11:54:55 PM

How about something like this:
Fetcher[
/* MACD Close to a Bullish Cross */
Close above 2
Average volume(30) above 250000

Slope of MACD(12,26,9) Fast Line above 0
MACD Histogram(12,26,9) below 0

Add column MACD Histogram(12,26,9)
Add column slope of MACD(12,26,9) Fast Line
Sort column 5 descending
]



olathegolf
119 posts
msg #151832
Ignore olathegolf
4/15/2020 1:19:35 AM

Added Approx. weekly, monthly and quarterly lows:
Fetcher[
/* MACD Close to a Bullish Cross*/
Close above 2
Average volume(30) above 250000
Chart-time is 6 months

2 day Slope of MACD(12,26,9) Fast Line above 0
MACD Histogram(12,26,9) below 0

Add column MACD Histogram(12,26,9)
Add column 2 day slope of MACD(12,26,9) Fast Line
Sort column 5 descending /*Could Also Sort column 10 Ascending Based on Lowest Weighting*/

/*Proximity to 5d, 21d, 63d Low Close*/
/*Move Could Have More Conviction if Bouncing off Support*/
set{5dl,close 5 day low}
set{21dl,close 21 day low}
set{63dl,close 63 day low}
set{5dlprox1,close - 5dl}
set{5dlprox2,5dlprox1/5dl}
set{5dlprox,abs(5dlprox2)}
set{21dlprox1,close - 21dl}
set{21dlprox2,21dlprox1/21dl}
set{21dlprox,abs(21dlprox2)}
set{63dlprox1,close - 63dl}
set{63dlprox2,63dlprox1/63dl}
set{63dlprox,abs(63dlprox2)}
set{weight1,3*63dlprox}
set{weight2,2*21dlprox}
set{weight3,5dlprox}
set{weight4,weight1+weight2}
set{weight,weight3+weight4} /*WAG at Weighting Close Proximity to 5d, 21d and 63d lows*/

draw price line at 5dl
draw price line at 21dl
draw price line at 63dl
add column 5dlprox
add column 21dlprox
add column 63dlprox
add column weight
]



olathegolf
119 posts
msg #151833
Ignore olathegolf
4/15/2020 1:32:17 AM

This is a simple 5 day test.
Crossover has not happened, but it assumes entry at the open the day following the signal.
You can walk backwards in time and see what the max profit would be the following 5 days.

Fetcher[
/* MACD Close to a Bullish Cross - 5d Test*/
Close 5 days ago above 2
Average volume(30) 5 days ago above 250000
Chart-time is 6 months

2 day Slope of MACD(12,26,9) Fast Line 5 days ago above 0
MACD Histogram(12,26,9) 5 days ago below 0

Add column MACD Histogram(12,26,9) 5 days ago
Add column 2 day slope of MACD(12,26,9) Fast Line 5 days ago
Sort column 5 descending /*Could Also Sort column 10 Ascending Based on Lowest Weighting...or Suggest a Better Correlation*/

/*5 Day Max Profit Check - Assume Entry Next Day at Open (Prior to Crossover Confirmation)*/
set{Profit1,high 4 day high/open 4 days ago}
set{Profit2,Profit1-1}
set{Profit,Profit2*100}
Add column Profit {Potential Profit%}

/*Proximity to 5d, 21d, 63d Close Lows*/
set{5dl,close 5 day low 5 days ago}
set{21dl,close 21 day low 5 days ago}
set{63dl,close 63 day low 5 days ago}
set{c5,close 5 days ago}
set{5dlprox1,c5 - 5dl}
set{5dlprox2,5dlprox1/5dl}
set{5dlprox,abs(5dlprox2)}
set{21dlprox1,c5 - 21dl}
set{21dlprox2,21dlprox1/21dl}
set{21dlprox,abs(21dlprox2)}
set{63dlprox1,c5 - 63dl}
set{63dlprox2,63dlprox1/63dl}
set{63dlprox,abs(63dlprox2)}
set{weight1,3*63dlprox}
set{weight2,2*21dlprox}
set{weight3,5dlprox}
set{weight4,weight1+weight2}
set{weight,weight3+weight4} /*WAG at Weighting Close Proximity to 5d, 21d and 63d lows*/

draw price line at 5dl
draw price line at 21dl
draw price line at 63dl
add column 5dlprox
add column 21dlprox
add column 63dlprox
add column weight
]



gkanparthy
6 posts
msg #151844
Ignore gkanparthy
4/16/2020 9:48:59 PM

wow thanks.. let me go through them. Is the last one the latest one with your approximaions added?

olathegolf
119 posts
msg #151845
Ignore olathegolf
4/16/2020 10:23:57 PM

The purpose of the last filter was to see how these stocks generally performed 5 days after the signal was triggered. For the calculation, it assumes:

1. You jump in early before crossover and buy at the open the day following the signal. I'm not necessarily advocating that.
2. P/L is calculated based on the 5 day high following the signal.

I simply wanted to see if stocks popped in the days following the signal. It's really not much more than that. The first two filters address your initial question.

Most stocks follow the general market direction. You can easily see that here. Run the 3rd filter and back up to a point that correlates to the trigger date in early April - a time when the market began an upward trend. You'll see that many of the stocks selected also popped with potential double digit gains over the 5 day period.

StockFetcher Forums · General Discussion · How to filter stocks that are about to do a bullish MACD crossover<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.