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
|
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
|
Registered User Joined: 3/30/2013 Posts: 8
|
Thanks Bruce.
|
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.
|
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
|