Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » pcf for bollinger band spread in the past w/ present contraction?

pcf for bollinger band spread in the past w/ present contraction?

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

caseyliska

Posted : Monday, September 11, 2006 9:56:27 PM

Registered User
Joined: 12/30/2005
Posts: 6

I want a pcf to find stocks with bollinger band(20, 2std) spreads over .35 in the past 20 days, and the lower bollinger band( 20, 2std) above the 50day moving average.

Thanks to Bruce L, I understand the formula for BB, But can I build a simple equation for past BB conditions?

((BB.20(UPPER) - BB.20(LOWER))/BB.20(UPPER))>.35 OR ((BB.19(UPPER) - BB.19(LOWER))/BB.19(UPPER))>.35 OR ((BB.18(UPPER) - BB.18(LOWER))/BB.18(UPPER))>.35 OR ... ((BB.1(UPPER) - BB.1(LOWER))/BB.1(UPPER))>.35 AND BB(UPPER)> AVGC50

Am I on the right track, or is there a simpler way. No need to write out the bollinger band equation.

casey

Craig_S

Posted : Tuesday, September 12, 2006 5:31:06 AM

Worden Trainer

Joined: 10/1/2004
Posts: 18,819

You have the right idea (once you replace the BB with the actual bollinger formulas). Your $0.35 requirement is really as much a scan for the price per share of the stock than anything dealing with the bands.

You may also find this interesting: Finding Expanding or Contracting Bollinger Bands

- Craig
Here to Help!

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.