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

Profile: dunsek
About
User Name: dunsek
Groups: Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Friday, March 20, 2009
Last Visit: Monday, June 11, 2012 2:07:24 PM
Number of Posts: 11
[0.00% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: Changing a scan or pcf from daily to weekly?
Posted: Monday, May 3, 2010 4:37:35 PM

Thanks, Bruce- you rock, as always.

Topic: Changing a scan or pcf from daily to weekly?
Posted: Monday, May 3, 2010 4:19:58 PM

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?

 

Topic: Changing a scan or pcf from daily to weekly?
Posted: Saturday, May 1, 2010 12:34:21 PM
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
Topic: Changing a scan or pcf from daily to weekly?
Posted: Saturday, May 1, 2010 12:20:49 PM
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
Topic: bollinger
Posted: Friday, November 13, 2009 9:07:18 AM
Hi Bruce-- never mind! It's working properly with arithmetic, as long as I don't check the center zero line option.Many thanksKD
Topic: bollinger
Posted: Friday, November 13, 2009 9:05:03 AM
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!
Topic: bollinger
Posted: Friday, November 13, 2009 8:56:28 AM
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?
Topic: BB 90,30
Posted: Tuesday, November 10, 2009 9:07:08 AM
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.
Topic: BB 90,30
Posted: Tuesday, November 10, 2009 8:02:30 AM
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
Topic: Bolinger Band Statement
Posted: Tuesday, November 10, 2009 7:40:52 AM
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