| dunsek |
|
Gold User, Member, Platinum User, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Friday, March 20, 2009 |
| Monday, June 11, 2012 2:07:24 PM |
11
[0.00% of all post / 0.00 posts per day] |
|
|
Thanks, Bruce- you rock, as always.
|
|
Sorry, Bruce- I was really wondering if there would be a difference between your formula, and taking my daily bb squeeze formula and converting it to weekly, not whether yours was correct. I take yours being correct on faith.
In other words, I'm still wondering how I would convert the daily formula I posted, to weekly. It's more than just converting the C's to C*5, correct?
|
|
Hi Bruce- sorry, just noticed your reply to gwsmith above. Is that the correct formula to use then, for a weekly bb squeeze? Thx KD
|
|
Hi Bruce- trying hard to convert a bollinger band squeeze formula from daily to weekly. I'm getting results, but they don't seem to be correct.
The formula on the daily chart works, and is this:
((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
|
|
Hi Bruce-- never mind! It's working properly with arithmetic, as long as I don't check the center zero line option.Many thanksKD
|
|
Hi Bruce- checking the center zero line and using arithmetic throws it off even more. Now instead of being just below the system generated bollinger band, that indicator is just under the upper band!
|
|
Hi Bruce- need your help once more please on the lower 3rd std deviation bollinger band. I'm using this formula:AVGC20 - 3 * 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)to create a lower bollinger band that I can then compare price to on the chart and sort by the % difference the stocks in my watch list are away from that lower band. I had it working and managed to exit without saving the template, and am having a heck of a time recreating it. The formula above drapes a new indicator below, and in some spots significantly below the 20,30 lower bollinger band. Do you see anything immediately wrong with that formula to explain why it doesn't track the system generated bb?
|
|
Thanks, Bruce. I ended up creating almost a duplicate of the lower bb as a custom indicator using a bb formula you had posted earlier, and doing a sort by, comparing it to price, and get the same result as your suggestion above.Thanks again, much appreciated.
|
|
Hi Bruce- I posted a similar question on a different thread, but maybe it's more relevant here. Forgive the double post ;)I'm trying to create a sort based on the percentage that the close/last price is away from the lower bollinger band (20,30). I don't want a true/false as in a pcf, but rather the ability to sort the watch list based on which stocks are closest to that lower 3 std deviation band. Is that doable?Thx
|
|
Bruce- I'd like to be able to sort my watchlist by % that the close/last price is away from the lower bollinger band (20,30). Any suggestions?Cheers
|
|