New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

MACD Crossing Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
couto7
Posted : Tuesday, February 12, 2019 12:18:08 PM
Gold Customer Gold Customer

Joined: 10/14/2004
Posts: 202

Please write PCF using MACD 12,26,9 crossing above signal lin in the last 1 day.  For example, on 2/18/19 the following stocks met the criteria CFG, ROL, MKC, and QCOM for bullish crossover, but did not show up in the PCF scans below.

AVGC12 > XAVGC26 AND XAVGC12.1 <= XAVGC26.1 AND V > 1000

C > AVGC30 AND XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 <= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)

Bruce_L
Posted : Tuesday, February 12, 2019 12:52:10 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

Your first formula checks for an exponential MACD 12,26 crossing up through zero (or at least it would if the first AVGC12 was XAVGC12). It also requiles volume to be at least 100,000 shares when used in TC2000.

Your second formula does in fact correctly check for the exponential MACD 12,26 crossing up through a 9 period exponential moving average signal line (the same thing as an exponential MACD Histogram 12,26,9 crossing up through zero), but it also requires price to be above its own 30 period simple moving average.

If we remove the checking for price being above its moving average, we are left with the following.

XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 <= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)

Note that while CFG, MKC, and QCOM all did meet this requirement on Feburary 8, 2019 in a daily time frame, ROL did not.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
couto7
Posted : Tuesday, February 12, 2019 2:55:42 PM
Gold Customer Gold Customer

Joined: 10/14/2004
Posts: 202

Bruce, Sorry, in the process of  copyand paste, I missed the X in (XAVG12) which exist in the PCF.  

Very helpful, thanks.

Bruce_L
Posted : Tuesday, February 12, 2019 3:50:34 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.