| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 1,178
|
In TC2000 version 11, I am using Acceleration Bands in a weekly timeframe. The weekly chart is plotted in a 20-week simple moving average. I am visually scanning for best-performing stocks and ETFs that consecutively close above the upper Acceleration Band twice in a row. Is there a way that I can replace my visual scans with a PCF?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following (you will need to set the Time Frame of the Personal Criteria Formula to Weekly):
20 * C > H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) AND 20 * C1 > H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) + H20 * (1 + 4 * (H20 - L20) / (H20 + L20))
Acceleration Bands
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: 1,178
|
Wow, thanks for this PCF. It is giving positive results for some PCFs, but not for others. Still very helpful, even if not perfect. However, I want to test it at the end of the market day, which may give me even better results.
Could you please write yet another PCF. Again, it would use Acceleration Bands in a weekly timeframe, plotted on a simple moving average (the same as above). However, this time I am looking for just one week that closes below the upper Acceleration Band.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Make sure you have the Time Frame of both this Personal Criteria Formula and the previous PCF set to Weekly:
20 * C < L * (1 - 4 * (H - L) / (H + L)) + L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Thanks, Bruce. I did as you suggested, keeping the chart on Weekly. But when I just now tested this latest PCF on the complete list of "US Exchange Traded Funds", I got 81 hits of the 1071 items. Most of the ETFs had Weekly Candles under the lower band (rather than, as I requested, the most recent Weekly candle closing below upper band as an Acceleration Band sell signal). The others were pretty much near the Acceleration Band's center line. Perhaps I didn't make my intention clear. Or, is there another reason?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In the TC2000.com version 11 beta, you can adjust the Personal Criteria Formula to be Weekly or not. The PCF needs to be Weekly if the Chart is Weekly.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Yes, I do know that, and am doing that. Keeping it Weekly. However, according to what I have read about Acceleration Bands, a sell signal is given when just one Weekly candle closes below the UPPER BAND.
The large majority of signals coming from the 2nd PCF you wrote for me are closing below the LOWER BAND and others near the center line. Not one is even near the UPPER BAND. This is the crux of the issue. If there is something you can do about this, I would greatly appreciate your efforts.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
They should all fall below the Lower Band because that's what I wrote (despite what you asked). A formula for being below the Upper Band would be:
20 * C < H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19))
It is just the first part (everything before the AND) of the originally supplied formula with the > sign changed to a < sign.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Here's what I put together according to my understanding of your instructions. I reversed the > sign following 20*C to <. I started with the first half of PCF#1 (before the AND). Then, I added PCF#3. However, the result of this PCF was the same as the result of PCF#2 in which the Weekly candle closed below the lower band.
20 * C < L * (1 - 4 * (H - L) / (H + L)) + L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19)) 20 * C > H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19))
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I provided the formula for price being below the Upper Band in my Wednesday, February 16, 2011 3:28:25 PM ET post. The change in sign notation was just to explain what I had done. In many cases when Price is below the Upper Band, it will also be below the Lower Band or near the Centerline. The PCF just checks for Price being below the Upper Band and nothing else.
If you want it to be "near" the Upper Band, you will have to provide an unambiguous objective definition of near.
If you also need Price to be above the Upper Band during the previous Bar, then you can just use the original formula provided in my Wednesday, February 16, 2011 11:51:05 AM ET post with the first > sign changed to a < sign and the second > sign left alone:
20 * C < H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) AND 20 * C1 > H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) + H20 * (1 + 4 * (H20 - L20) / (H20 + L20))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Hi Bruce...For some reason the PCFs are working well now on this new day. I can't explain it, but am happy with the results. Thanks for all your patience. Traderlady
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |