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

BB Scan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
KennedyG
Posted : Tuesday, December 3, 2013 9:19:09 PM
Registered User
Joined: 3/30/2013
Posts: 8

Hey Bruce,

I'm pretty new to TC2000 but it hasn't take me long to realize you are a genius. 

Alas, I haven't anything too complicated to challenge your amazing mind, but can you help me to creat a PCF for this. This would be for an intraday or daily chart.

1. Stock is breaking below the B Bands

2. Next bar after thatt is higher than the previous one (reversing)

3. There is an increase in volume of the reverse bar.

And then the same for the reverse

1. Stock is breaking above the b-bands

2. next bar is lower

3. this lower bar has more volume than the bar before it.

Also if I wanted to add an RSI condition to these can you tell me how I would add that?

I'm sure this is already out there in the worden world, but I couldn't find it.

Many thanks,

g

 

Bruce_L
Posted : Wednesday, December 4, 2013 11:13:07 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You did not give the settings for your Bollinger Bands, but it is possible to create a Condition Formula for this. Using Bollinger Bands 20, 2.00, the first Condition Formula could be written as:

C > C1 AND V > V1 AND C1 < AVGC20.1 - 2 * SQR(ABS(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 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND C2 >= AVGC20.2 - 2 * SQR(ABS(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 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)

And the second Condition Formula could be written as:

C < C1 AND V > V1 AND C1 > AVGC20.1 + 2 * SQR(ABS(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 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND C2 <= AVGC20.2 + 2 * SQR(ABS(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 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

Note that it is possible to do this without using such a long formula or knowing the settings of the Bollinger Bands if you are willing to use an EasyScan instead of needing to do it in a single Condition Formula. We would start with just a short formula for price and volume both increasing from the previous bar:

C > C1 AND V > V1

Writing Custom Conditions: The Basics
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Then we would add a 1-Period Simple Moving Average with an Offset of 1 to Price History so we can check for the previous day instead of the current day.

Adding and Moving Indicators

Since we want to check for a cross through the Bollinger Bands, we will add Bollinger Bands to the 1-Period Simple Moving Average with an Offset of 1 (not to Price History).

Then click on the 1-Period Simple Moving Average with an Offset of 1 and select Create Scan Condition to create a condition for Crossing Down Chan Bottom in the Moving Average 1 +1 vs Bollinger Band section of the Condition drop-down.

Create Conditions from Your Chart

You will need to add both conditions to the same EasyScan as EasyScan Conditions.

Building a Scan with Multiple Conditions

Creating the other EasyScan would be a matter of starting with a Condition Formula for price moving down and volume moving up and combining it with a condition created by clicking on the moving average for crossing up through the upper Bollinger Band.

C < C1 AND V > V1

We can use the same technique for creating conditions based on RSI. Add the RSI indicator to the chart and adjust its settings as desired. Then click on the RSI indicator and select Create Scan Condition.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
KennedyG
Posted : Sunday, December 8, 2013 6:39:51 PM
Registered User
Joined: 3/30/2013
Posts: 8

Thanks Bruce.

KennedyG
Posted : Sunday, December 8, 2013 7:30:35 PM
Registered User
Joined: 3/30/2013
Posts: 8

so now that i've done that, how can i create a column in a watchlist which shows me when these conditions are true? I know you can't add a scan to a watchlist. 

Bruce_L
Posted : Monday, December 9, 2013 3:57:20 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you save the first two Condition Formulas given in my response, you can choose them using the name used used when saving them when selecting Add Column for a WatchList.



-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.