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


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Attention of Bruce L " PCF for an MACD to cross its own Bolliner Band Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mbslomka
Posted : Sunday, June 20, 2010 7:21:57 PM
Registered User
Joined: 2/2/2005
Posts: 20
I must apologise for the way I posed my original request for help.  It invited confusion.  I would like to restate it:  I would like to be able to identify a list of stock whose today's MACD 2,8,1 is equal to or geater than the MACD's lower BB 20 period 16 SD [Worden's 1.6 SD].  [After reading thru some of the discussions under the broad term of calculating BBs, I would ask only that it would parallel the results one gets graphically on a solitary plot of the MACD 2.81 and of the BB 20 Periods 16SD of that plot.

Thank you!!

mslomka
Bruce_L
Posted : Monday, June 21, 2010 10:22:48 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try the following:

XAVGC2 - XAVGC8 >= AVG(XAVGC2,20) - AVG(XAVGC8,20) - 1.6 * SQR(ABS((XAVGC2 - XAVGC8) ^ 2 + (XAVGC2.1 - XAVGC8.1) ^ 2 + (XAVGC2.2 - XAVGC8.2) ^ 2 + (XAVGC2.3 - XAVGC8.3) ^ 2 + (XAVGC2.4 - XAVGC8.4) ^ 2 + (XAVGC2.5 - XAVGC8.5) ^ 2 + (XAVGC2.6 - XAVGC8.6) ^ 2 + (XAVGC2.7 - XAVGC8.7) ^ 2 + (XAVGC2.8 - XAVGC8.8) ^ 2 + (XAVGC2.9 - XAVGC8.9) ^ 2 + (XAVGC2.10 - XAVGC8.10) ^ 2 + (XAVGC2.11 - XAVGC8.11) ^ 2 + (XAVGC2.12 - XAVGC8.12) ^ 2 + (XAVGC2.13 - XAVGC8.13) ^ 2 + (XAVGC2.14 - XAVGC8.14) ^ 2 + (XAVGC2.15 - XAVGC8.15) ^ 2 + (XAVGC2.16 - XAVGC8.16) ^ 2 + (XAVGC2.17 - XAVGC8.17) ^ 2 + (XAVGC2.18 - XAVGC8.18) ^ 2 + (XAVGC2.19 - XAVGC8.19) ^ 2 - 20 * (AVG(XAVGC2,20) - AVG(XAVGC8,20)) ^ 2) / 19)

If the MACD is Simple, eliminate all of the Xs from the formula:

AVGC2 - AVGC8 >= AVG(AVGC2,20) - AVG(AVGC8,20) - 1.6 * SQR(ABS((AVGC2 - AVGC8) ^ 2 + (AVGC2.1 - AVGC8.1) ^ 2 + (AVGC2.2 - AVGC8.2) ^ 2 + (AVGC2.3 - AVGC8.3) ^ 2 + (AVGC2.4 - AVGC8.4) ^ 2 + (AVGC2.5 - AVGC8.5) ^ 2 + (AVGC2.6 - AVGC8.6) ^ 2 + (AVGC2.7 - AVGC8.7) ^ 2 + (AVGC2.8 - AVGC8.8) ^ 2 + (AVGC2.9 - AVGC8.9) ^ 2 + (AVGC2.10 - AVGC8.10) ^ 2 + (AVGC2.11 - AVGC8.11) ^ 2 + (AVGC2.12 - AVGC8.12) ^ 2 + (AVGC2.13 - AVGC8.13) ^ 2 + (AVGC2.14 - AVGC8.14) ^ 2 + (AVGC2.15 - AVGC8.15) ^ 2 + (AVGC2.16 - AVGC8.16) ^ 2 + (AVGC2.17 - AVGC8.17) ^ 2 + (AVGC2.18 - AVGC8.18) ^ 2 + (AVGC2.19 - AVGC8.19) ^ 2 - 20 * (AVG(AVGC2,20) - AVG(AVGC8,20)) ^ 2) / 19)

Understanding MACD
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-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.