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

Profile: PaulEarley
About
User Name: PaulEarley
Groups: Gold User, Member, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Friday, August 19, 2005
Last Visit: Saturday, July 29, 2006 7:09:05 AM
Number of Posts: 5
[0.00% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Posted: Saturday, February 11, 2006 9:32:22 AM
Thanks for the input. I worked through the equations carefully and adapted them slightly to get what I need. I have enjoyed this discussion, because it made me dig into the mathmatics more.
Thanks to all
Paul Earley
Topic: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Posted: Friday, February 10, 2006 4:32:16 PM
I know I am on this thread on a totally different level (although I have appreciated trying to recall my statistics). When I use either formula, I get a value of about 27.6 for a test on a stock that had an upper BB at about 87.4 on the day under consideration.

Am I misunderstanding the use of the equation? I was trying to scan for stocks that close above their upper BB "yesterday".

Paul Earley
Topic: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Posted: Friday, February 10, 2006 9:53:05 AM
I ensured that it was calculating against ALL STOCKS. But the formula does not seem to calculate TRUE for stocks that closed above BB. The "Test" also does not accurately depict a close above the upper BB.

Could you cross check it on your system if you have the time? I appreciate all the help.
Paul
Topic: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Posted: Friday, February 10, 2006 9:06:37 AM
Jim and Bruce:
Thanks for all the great help. I am trying to refine my short selections.

When I apply Jim's formula to ALL stocks, I get zero items returned, despite the fact that when I review stocks I can see many closes > upper BB. Any thoughts as to what I am doing worng? (The formula tests out TRUE for IBM).

Sorry to be such a newbie. I program for a living but can't quite get this PCF thing.
Paul Earley
Topic: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Posted: Thursday, February 9, 2006 11:21:58 PM
Bruce:
Does this mean that to write a Boolean PCF that is true if a stock closes yesterday higher than the upper Bollinger band, it would read:
c1 > AVGC21+2*SQR(((C-AVGC21)^2 +(C1-AVGC21)^2 +(C2-AVGC21)^2 +(C3-AVGC21)^2 +(C4-AVGC21)^2 +(C5-AVGC21)^2 +(C6-AVGC21)^2 +(C7-AVGC21)^2 +(C8-AVGC21)^2 +(C9-AVGC21)^2 +(C10-AVGC21)^2 +(C11-AVGC21)^2 +(C12-AVGC21)^2 +(C13-AVGC21)^2 +(C14-AVGC21)^2 +(C15-AVGC21)^2 +(C16-AVGC21)^2 +(C17-AVGC21)^2 +(C18-AVGC21)^2 +(C19-AVGC21)^2 +(C20-AVGC21)^2)/20)

Paul Earley