Gold Customer
Joined: 6/17/2008 Posts: 31
|
Hello Worden trainer,
How can I create a condition that price were within the Ballinger Bands for 19 days or more ? (that mean the price has not close above / below the Bands for 19 days or more)
Thank you so much
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could create a condition for this relatively easily in TC2000 version 12.4. Add a Custom PCF % True Indicator to the chart.
You can add a Custom PCF % True Indicator by selecting Add Plot to Chart (the green + in the upper left of the chart) and select Custom PCF % True Indicator from the list. You can start typing Custom PCF % True Indicator in the search box after selecting Add Plot to Chart to quickly bring it to the top of the list to make it easier to find and select.
Adding and Moving Indicators (7:19)
You would use the following settings in the Custom PCF % True Indicator if the you want to base it on price having closed within Bollinger Band 20, 2.00 for the most recent 19 bars.
- Period: 19
- Average Type: Simple
- Formula: ABS(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) / 20)
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Then you would click on the Custom PCF % True Indicator and select Create Scan Condition to create a condition for the value of the Custom PCF % True Indicator being greater than 99.99 to actually create the condition.
Create Conditions from Your Chart (5:25)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/9/2008 Posts: 30
|
Hello Bruce, What PCF would show a stock that has a 20 day exponential av. and it crosses above its 50 day EMA ( after the20 day wasbelow the 50 day for at least 20 previous trading days ) ?. Thank You.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Assuming both moving averages are of price:
XAVGC20 > XAVGC50 AND XAVGC20.1 < XAVGC50.1 AND XAVGC20.2 < XAVGC50.2 AND XAVGC20.3 < XAVGC50.3 AND XAVGC20.4 < XAVGC50.4 AND XAVGC20.5 < XAVGC50.5 AND XAVGC20.6 < XAVGC50.6 AND XAVGC20.7 < XAVGC50.7 AND XAVGC20.8 < XAVGC50.8 AND XAVGC20.9 < XAVGC50.9 AND XAVGC20.10 < XAVGC50.10 AND XAVGC20.11 < XAVGC50.11 AND XAVGC20.12 < XAVGC50.12 AND XAVGC20.13 < XAVGC50.13 AND XAVGC20.14 < XAVGC50.14 AND XAVGC20.15 < XAVGC50.15 AND XAVGC20.16 < XAVGC50.16 AND XAVGC20.17 < XAVGC50.17 AND XAVGC20.18 < XAVGC50.18 AND XAVGC20.19 < XAVGC50.19 AND XAVGC20.20 < XAVGC50.20
If the 50-period moving average is of the 20 as might be a more literal interpretation of the actual language of your request:
XAVGC20 > XAVG(XAVGC20,50) AND XAVGC20.1 < XAVG(XAVGC20.1,50) AND XAVGC20.2 < XAVG(XAVGC20.2,50) AND XAVGC20.3 < XAVG(XAVGC20.3,50) AND XAVGC20.4 < XAVG(XAVGC20.4,50) AND XAVGC20.5 < XAVG(XAVGC20.5,50) AND XAVGC20.6 < XAVG(XAVGC20.6,50) AND XAVGC20.7 < XAVG(XAVGC20.7,50) AND XAVGC20.8 < XAVG(XAVGC20.8,50) AND XAVGC20.9 < XAVG(XAVGC20.9,50) AND XAVGC20.10 < XAVG(XAVGC20.10,50) AND XAVGC20.11 < XAVG(XAVGC20.11,50) AND XAVGC20.12 < XAVG(XAVGC20.12,50) AND XAVGC20.13 < XAVG(XAVGC20.13,50) AND XAVGC20.14 < XAVG(XAVGC20.14,50) AND XAVGC20.15 < XAVG(XAVGC20.15,50) AND XAVGC20.16 < XAVG(XAVGC20.16,50) AND XAVGC20.17 < XAVG(XAVGC20.17,50) AND XAVGC20.18 < XAVG(XAVGC20.18,50) AND XAVGC20.19 < XAVG(XAVGC20.19,50) AND XAVGC20.20 < XAVG(XAVGC20.20,50)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Hello Bruce,
I understand the first part-how to put a custom PCF % true indicator on the chart. but I am lost on the second part-how to put the formula into the % true indicator.as well as the third part setting the true indicator to 99.99 please give me more detail instructions.
Thanks again
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Since you already have the Custom PCF % True Indicator on the chart, we will start with editing it.
- Click on the Custom PCF % True Indicator (the name where it says Formula(C > C1)) and select Edit.
- You want the following settings.
-- Plot Style: Up to you.
-- Plot Color: Up to you.
-- Period: 19
-- Average Type: Simple
-- Boolean Formula: ABS(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) / 20)
-- Line Style: Up to you.
-- Line Width: Up to you.
-- Plot Opacity: Up to you.
-- Data Source: Price History
-- Label: Up to you.
Most of the settings are entirely up to you. The only setting which isn't which wasn't mentioned in the original response is the Data Source which should be set to Price History (but that is its default).
You probably won't be able to right-click on the Boolean Formula window and select Paste, but you can use ctrl-v to paste the formula as copied from the forums into the Boolean Formula window.
The last video referenced in my original response will cover the next part in greater detail.
Create Conditions from Your Chart (5:25)
Now to actually create the condition, click on the Custom PCF % True Indicator (the words where it should now say something like Formula(ABS(C - AVGC20) <= 2 * SQR(ABS(C ^ 2 + C...)avg19) and select Create Scan Condition.
This will bring up the Create Scan Condition window.
To the right of where it says Condition:, it will probably already say Greater Than (which is what we want). This is the Condition drop-down menu. If you wanted a different condition, you would click where it says Greater Than and select something else.
Right below where it says Condition:, it should say Greater Than. This is where we will set the Greater Than condition to check for the Custom PCF % True Indicator being greater than 99.99 by changing this value from 0.00 to 99.99.
There will be multiple options as to what you want to do with the condition. If you want to use it as a WatchList Column or add it as a condition to an existing EasyScan which is already visible in your charts, select Add to an Existing WatchList or Scan.
If you want to create a new EasyScan based on this condition, select Scan in New Window.
If you want to save the condition to use later, select Save Condition to Library.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Thank you Bruce. I got it.
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Hi Bruce,
How do I construct a scan list like this : flag/symbol/price/% change/rounding bottoms/J-hook/morning stars etc.( I have all the PCFs)in a vertical coloum, so went I want to check my rounding bottoms or morning stars , the coloum will display a "check" mark on the stocks that qualifies ?( In other words, I want to put all my conditions in a vertical coloum under US stocks, greater than $5 and greater than 250000 shares traded, so I can watch it in a glance.
Thank you so much for your assistance
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I don't quite understand what you are asking.
Do you want to have a different column for each of your PCFs?
Do you want to have a single column which somehow incorporates all of these conditions? If so, can you describe specifically how you would want the single WatchList Column to work for all of these things?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Hi Bruce,
I want a different column for each of the PCFs. a column for flag, a column for rounding bottoms, a
column for morning star PCF etc. So when I do a scan, a will have a CHECK marks on all the columns
that fit that criteria/condition.( Just save me time so I don't have to scan each PCFs & copy it to my Main
watch list, I can see all conditions that fit the criteris in ONE glance.)
Thanks again
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you already have the Condition Formulas already created, you should be able to just select Add Column (the + in an orange circle at the top of the WatchList) and choose the desired Condition Formula to create the WatchList Column with a check.
How to add a column to a watchlist
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Thanks Bruce.
If I want the condition formulas to be further more filter with PRICE greater than 5, 90 day VOLUME
greater than 250000 shares before I create the watch list column, how do I do that ?
Thanks for your assistance again
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You would need to modify each of the Condition Formulas being used by either adding the following to the beginning of the formula.
C > 5 AND AVGV90 > 250000 AND
Or the following to the end of the formula.
AND C > 5 AND AVGV90 > 250000
You will need to remove and re-add the WatchList Columns after making any changes to the Condition Formulas if you want those changes to be reflected in the WatchList Columns.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Thank you so much , Bruce.
SAM
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
Hi Bruce,
-
How do I move one layout into my second monitor without effecting my existing main TC 2000 layout/website ?
I can move charts,but once I turn off the second monitor, the charts are gone,disappear back to the main TC 2000 webpage
Thanks for your assistance
SAM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm not sure I understand. You can float windows and move them into another monitor.
How to float windows
Floating Windows & Multiple Monitors (4:02)
But usually if you then turn off that monitor, the program is going to still try to display the windows. That would generally mean they get moved back to the first monitor when the second monitor is turned off.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/17/2008 Posts: 31
|
thanks . I got it
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |