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 |

modification of PCF (David Elliott's MOBO bands) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
georgekern
Posted : Monday, May 5, 2008 12:22:25 PM
Registered User
Joined: 2/20/2005
Posts: 54
Hi,

I have a PCF which shows stocks that closed above a 10,8 upper Bollinger Band today: C > AVGC10 + .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) 

How would I modify this to show stocks that closed below the 10,8 upper Bollinger Bands yesterday?

Then I have a PCF which shows stocks that closed below a 10,8 lower Bollinger Band today: C < AVGC10 - .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) 

How would I modify this to show stocks that closed above the 10,8 lower Bollinger Band yesterday?

thanks,

George Kern
Bruce_L
Posted : Monday, May 5, 2008 12:31:38 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (georgekern)
closed below the 10,8 upper Bollinger Bands yesterday

If you just want to find these stocks then please try the following:

C < AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)

If you want a crossover formula that combines the two instead, please try the following:

C > AVGC10 + .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 <= AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)

QUOTE (georgekern)
closed above the 10,8 lower Bollinger Band yesterday

If you just want to find these stocks then please try the following:

C > AVGC10.1 - .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)

If you want a crossover formula that combines the two instead, please try the following:

C < AVGC10 - .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 >= AVGC10.1 - .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)

You may wish to review the following:

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
georgekern
Posted : Monday, May 5, 2008 1:15:45 PM
Registered User
Joined: 2/20/2005
Posts: 54
thanks, appreciate your help, you guys are really great

George
Bruce_L
Posted : Monday, May 5, 2008 1:22:17 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
gooseberry01
Posted : Wednesday, June 4, 2008 8:18:41 PM
Registered User
Joined: 7/28/2006
Posts: 2
I wanted to use the same formula as georgekern to find stocks that closed above the upper band BB 10, 8 today and below the upper band 10,8 yesterday. I applied the formula given for a crossover but I found that it didn't pick up some stocks. Should the formula for yesterday be:
C1 < AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)   instead of starting with just C? Thanks for the help.
Bruce_L
Posted : Thursday, June 5, 2008 6:47:37 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
gooseberry01,
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:

If you are new to TeleChart READ THIS FIRST!

You are absolutely correct and it has been corrected in the formulas provided in my Monday, May 05, 2008 12:31:38 PM ET post. Thank you for pointing it out.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
gooseberry01
Posted : Thursday, June 5, 2008 10:34:09 AM
Registered User
Joined: 7/28/2006
Posts: 2
Thanks for all the help everyone!
Bruce_L
Posted : Thursday, June 5, 2008 10:37:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
gooseberry01,
You're welcome. Our pleasure.

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