| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 91
|
Hi Bruce,
Trying to get started all over again. Have been away quite some time.
Wanting to locate stocks that closed above the UPPER BOL BND YESTERDAY
and TODAY closed below that UPPER BOL BND.
I have a formula but it doe not work on TC2011.
[2] > Bol_Upper (12,1) [2] and c[2] > Ema(3) [2]c[1] > Bol_Upper(12,1)[1] and c[1] > Ema(3)[1]c < Bol_Upper(12,1) and C < Ema(3)
Thanks again,
Gerry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I have no idea of what language your formula might have been composed, but it does not look similar to TeleChart's Personal Criteria Formula Language and I can only guess as to what it might mean. My best guess at a PCF for the TC2000.com version 11 beta follows:
C2 > AVGC12.2 + SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 - 12 * AVGC12.2 ^ 2) / 12) AND C2 > XAVGC3.2 AND C1 > AVGC12.1 + SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 - 12 * AVGC12.1 ^ 2) / 12) AND C1 > XAVGC3.1 AND C < AVGC12 + SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 - 12 * AVGC12 ^ 2) / 12) AND C < XAVGC3
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: 10/7/2004
Posts: 91
|
Hi Bruce,Boy that's alot of inputs !THANKS AGAIN !Now, if I want to change the 12 to say a smaller number like say a 7would I just go in there and change all the 7's or would that change things too much ?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You would need to do more than just change all of the 12s to 7s. The number of terms used in the Bollinger Band calculations would change as well (the first referenced topic in my original response explains the Bollinger Band calculations in some detail).
C2 > AVGC7.2 + SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 - 7 * AVGC7.2 ^ 2) / 7) AND C2 > XAVGC3.2 AND C1 > AVGC7.1 + SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 - 7 * AVGC7.1 ^ 2) / 7) AND C1 > XAVGC3.1 AND C < AVGC7 + SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 - 7 * AVGC7 ^ 2) / 7) AND C < XAVGC3
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 91
|
Hi Bruce,
Now , if I want to see the opposite scan using the same input of say 7, but this time looking for stocks that at the CLOSE YESTERDAY the CLOSING PRICE of these stocks were BELOW the UPPER BOL BND and then at the close TODAY, these stocks CLOSING PRICES, CLOSED ABOVE the UPPER BOL BND, what would that formula look like ?
Thanks again
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Assuming no other requirements than those stated in your Tuesday, March 01, 2011 11:02:35 AM ET post:
C1 < AVGC7.1 + SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 - 7 * AVGC7.1 ^ 2) / 7) AND C > AVGC7 + SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 - 7 * AVGC7 ^ 2) / 7)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |