Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Price crossing upper Bollinger Band Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
markinvests3
Posted : Tuesday, June 28, 2011 5:07:56 PM
Registered User
Joined: 6/30/2010
Posts: 33
I am looking for a way to screen for stocks with price action moving over the upper bb on a daily chart and how to adjust for different timeframes.  Stockfinder made this really easy.  TC2000v11 is the version i am using.

Thank you 
Mark
StockGuy
Posted : Tuesday, June 28, 2011 5:47:28 PM

Administration

Joined: 9/30/2004
Posts: 9,187
You can't create scan conditions directly from the chart yet in TC2000. But you can create a sort condition by clicking on Price History, then Add Column and set the column Based On to Price "crossing up channel top" of the Bollinger Bands.  This will add a column that will light up when the condition is True and you can use it to sort the list.

To create a scan criteria, you'll need to use a PCF.  What is the period and std dev of your Bollinger Bands.  You can use the PCF to create conditions for the different time frames.
markinvests3
Posted : Tuesday, June 28, 2011 6:36:09 PM
Registered User
Joined: 6/30/2010
Posts: 33
Thank you for your reply.  I prefer screens as columns take up valuable space, stockfinder did a really nice and easy job of creating screens and automatically updating based on a chosen timeframe.  

I am use 20 and 2 for bollinger bands.  I have never figured out the PCF logic, have not really tried very hard.  It is to complicated for my brain.  I am interested in 1 day and 60/15/5 min timeframes.

Thank you for your help.
StockGuy
Posted : Wednesday, June 29, 2011 9:45:23 AM

Administration

Joined: 9/30/2004
Posts: 9,187
Create the PCF using the following formula:

C > (AVGC20 + 2 * 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)) and C1 <  (AVGC20.1 + 2 * SQR(ABS(C20 ^ 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.1 ^ 2) / 19))

If you want different time frames, just create multiple PCFs and set the time frame on the PCFs accordingly.
markinvests3
Posted : Thursday, June 30, 2011 10:47:48 PM
Registered User
Joined: 6/30/2010
Posts: 33
Thank you.  I will try this formula.  How in the world would I have ever figured out how to program such complexity?  

Also, Is there a way to program an hourly consolidation formula?  basically, i want to find price action within tight consolidation within the hourly chart.  2, 3, 4, or 5 days with price action within a certain percentage of the mean maybe.?  Less than 1%, 2% or 4%.
Bruce_L
Posted : Thursday, July 7, 2011 12:40:06 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
There are seven hourly bars per day, so you could do something like the following using an Hourly Time Frame in the TC2000.com version 11 beta for 2 days less than 1%:

MAXH14 / MINL14 < 1.01

3 days less than 2%:

MAXH21 / MINL21 < 1.02

4 days less than 4%:

MAXH28 / MINL28 < 1.04

The pattern can be adjusted as desired.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.