Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

%b Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
laurensbensdorp
Posted : Monday, September 3, 2007 2:53:03 PM
Registered User
Joined: 1/3/2005
Posts: 11
Hi, I am trying to make a PCF with bollinger %B
with a bollinger average of 5 and a stdv of 1.
How can I get the pcf with the rule that the %B closes below 0.2 for three days or more?
Bruce_L
Posted : Tuesday, September 4, 2007 11:19:32 AM


Worden Trainer

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

(C - AVGC5) / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 4) / 2 + .5 < .2 AND (C1 - AVGC5.1) / SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 - 5 * AVGC5.1 ^ 2) / 4) / 2 + .5 < .2 AND (C2 - AVGC5.2) / SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 - 5 * AVGC5.2 ^ 2) / 4) / 2 + .5 < .2

You may wish to review the following:

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
laurensbensdorp
Posted : Thursday, September 6, 2007 6:59:04 AM
Registered User
Joined: 1/3/2005
Posts: 11
Thank you very much, that works excellent.
Could you also provide me with the PCF for:
The smoothed RSI2 from today < smoothed RSI2 from yesterday?
Bruce_L
Posted : Thursday, September 6, 2007 7:35:25 AM


Worden Trainer

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

((C > C1) * (C1 - C) + .5 * ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13))))))))))))))) / (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14))))))))))))))) < ((C1 > C2) * (C2 - C1) + .5 * ((C2 > C3) * (C3 - C2) + .5 * ((C3 > C4) * (C4 - C3) + .5 * ((C4 > C5) * (C5 - C4) + .5 * ((C5 > C6) * (C6 - C5) + .5 * ((C6 > C7) * (C7 - C6) + .5 * ((C7 > C8) * (C8 - C7) + .5 * ((C8 > C9) * (C9 - C8) + .5 * ((C9 > C10) * (C10 - C9) + .5 * ((C10 > C11) * (C11 - C10) + .5 * ((C11 > C12) * (C12 - C11) + .5 * ((C12 > C13) * (C13 - C12) + .5 * ((C13 > C14) * (C14 - C13) + .5 * ((C14 > C15) * (C15 - C14))))))))))))))) / (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
laurensbensdorp
Posted : Thursday, September 6, 2007 9:23:48 AM
Registered User
Joined: 1/3/2005
Posts: 11
Thanks a lot Bruce!
Bruce_L
Posted : Thursday, September 6, 2007 9:50:05 AM


Worden Trainer

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jfisamm
Posted : Friday, September 7, 2007 2:53:43 AM
Registered User
Joined: 12/18/2004
Posts: 44
Hi Bruce
How about PCF for %B using std settings of 20,2,0 with readings of 1.0, 0.5, 0.0 showing on the right side of the window.
%B=1.0 where price exactly on Upper Band
%B=0.5 " " Middle Band
%B=0.0 " " Lower Band
I intend to sort them by exact value.

Using the PCF provided from this site, i am able to plot BWI ( band width index)which matches exactly as those generated by others (Stockcharts)
But the readings on the right side of the indicator are completely different.
TC gives reading of 0.051 to 0.147
Stockcharts " 1.5 to 4.0 , both using same setting (20,2,0) on CSCO today.
Can TC readings be changed to match those in stockcharts for easier interpretation?
Thank you so much
jfisamm
Bruce_L
Posted : Friday, September 7, 2007 11:39:50 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
jfisamm,
The formula would be:

(C - AVGC20) / 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 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 19) / 4 + .5

You can use this as a Personal Criteria Formula or use Indicator Sorting on a Custom Indicator to get sorts using exact values:

Create your own stock rankings using WatchLists and Sort conditions
Plotting Custom Indicators with Examples
Sorting price and indicators by their Actual Value

I do not know a practical automated method to force the desired scaling or lines in TeleChart. It is possible to specify the scaling and set Value Pointers in Blocks.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bustermu
Posted : Friday, September 7, 2007 12:10:51 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
jfisamm,

The PCF given by Bruce is correct for TeleChart. For all other charting services (as far as I know) including StockCharts, the "/19" must be replaced by "/20".

Thanks,
Jim Murphy
Bruce_L
Posted : Friday, September 7, 2007 12:52:08 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
jfisamm,
This (/19 vs /20) is discussed in more detail in the Modelling Bollinger Bands (& Standard Deviation) in a TC PCF post referenced in my first reply in this topic.

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