| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
Registered User
Joined: 2/20/2005
Posts: 54
|
thanks, appreciate your help, you guys are really great
George
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
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.
|
|
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
|
|
Registered User
Joined: 7/28/2006
Posts: 2
|
Thanks for all the help everyone!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
gooseberry01,
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |