| bluto |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Monday, November 28, 2005 |
| Saturday, March 10, 2007 11:02:49 PM |
15
[0.01% of all post / 0.00 posts per day] |
|
Awesome, Bruce You and Craig are "Da Men". 
|
QUOTE (Bruce_L) pkolble, The formula posted by bluto will work fairly well for a 20-Period Bollinger Band of Width 20, but will not match the charts exactly because the Bollinger Bands in TeleChart have a denominator of 19 in some places where his formula uses a denominator of 20. The following should produce a slightly closer match to TeleChart's charts (it should probably be noted that this number is frequently multiplied by 100 in actual practice): Bollinger Band (20,20) %b: (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 may wish to review the following: Modelling Bollinger Bands (& Standard Deviation) in a TC PCFHow to create a Personal Criteria Forumula (PCF)Handy PCF example formulas to help you learn the syntax of PCFs!
Fantastic, Bruce! I found that %b on one of the Worden forum pages awhile back, but looks like yours is new & improved. 
|
QUOTE (pkolble) did a search on %b but didn't get any results. John Bollinger in his book "Bollinger on Bollinger Bands" uses a %b indicator and gives the formula as:
(last - lower bollinger band) / (upper bollinger band - lower bollinger band)
How do I write that in TC2000?
Try this:
(C - (AVGC20 - 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20)))) / (((AVGC20 + 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20))) - (AVGC20 - 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20)))))
|
QUOTE (Craig_S) That was ma hope as well. It fell on the priority list and is scheduled to be corrected in tonight's end-of-day download.
To be clear, the problem is with the built-in condition. Your PCF is showing the correct values.
Whew....in the meantime, can you tell me how I could devise a shell formula for a "MoneyStream Surge - x Days" PCF and which components I'd need to change depending on how many days? I'd like to build a series of these for different time periods. Thx.
|
QUOTE (Craig_S) The issue was finally tracked down and the system criterion will match any created PCF by tomorrow's closing download. Thank you for your patience, it was not an easy problem to diagnose.
Craig - Finally had a chance to check and the issue has in fact not been resolved. The criteria formula of
100 * (MS - MS1.5) / (MAX(MS1,99) - MIN(MS1,99)) continues to display for the system PCF of "MoneyStream Surge - 1 Week" when you click the "view formula" icon. I confirmed this by creating my own PCF again using the above formula and comparing the results to the values produced by the system PCF. Either the above formula is wrong, or the computation inside the system PCF is incorrect and different than what the above formula indicates. I was assuming as you mentioned that all of this would be remedied and in place by the Tuesday end of day update.
 
|
QUOTE (Craig_S) The issue was finally tracked down and the system criterion will match any created PCF by tomorrow's closing download. Thank you for your patience, it was not an easy problem to diagnose.
Terrific, Craig! Thanks for your persistence on this.
|
Hey....have you guys forgotten about this? I really need an answer so I can finalize my PCF. I'd imagine this should be a simple thing to verify. 
|
QUOTE (Craig_S) We saw this, bluto (deleted your reposting).
I duplicated what you did and am looking into it. Stay tuned.
Ooops...sorry. I wasn't sure if I had posted in the right forum. Thanks for confirming, Craig. It was driving me nuts! 
|
I posted this earlier over in the PCF/Indicator forum but I don't think anyone is alive over there.
I'm trying to create my own new PCF that uses the formula logic of the Moneystream Surge - 1 Wk. system PCF. You can display the formula criteria of this system PCF as:
100 * (MS - MS1.5) / (MAX(MS1,99) - MIN(MS1,99))
The PCF I'm creating produces the difference between a 1 week MS surge and a 2-day MS surge. What I'm finding is that the above system formula produces erroneous results. In fact, I created an exact duplicate PCF using the formula above, and when I display the results of both the system PCF and the clone PCF in side-by-side columns, the values are different! I need to confirm if the above formula is in fact the one being used in the system PCF, or if the criteria info. display for this PCF is bogus. I've recalculated everything and can't see any reason why the results are not the same.
I called Telechart support and they directed me here. Any help would be appreciated. Thanks.
|
I'm trying to create my own new PCF that uses the formula logic of the Moneystream Surge - 1 Wk. system PCF. You can display the formula criteria of this system PCF as:
100 * (MS - MS1.5) / (MAX(MS1,99) - MIN(MS1,99))
The PCF I'm creating produces the difference between a 1 week MS surge and a 2-day MS surge. What I'm finding is that the above system formula produces erroneous results. In fact, I created an exact duplicate PCF using the formula above, and when I display the results of both the system PCF and the clone PCF in side-by-side columns, the values are different! I need to confirm if the above formula is in fact the one being used in the system PCF, or if the criteria info. display for this PCF is bogus. I've recalculated everything and can't see any reason why the results are not the same.
I called Telechart support and they directed me here. Any help would be appreciated. Thanks.
|
|