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

Bollinger Bands Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ETF2008
Posted : Wednesday, June 18, 2014 11:14:42 AM
Gold Customer 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
Bruce_L
Posted : Wednesday, June 18, 2014 11:44:47 AM


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
trout2
Posted : Wednesday, June 18, 2014 1:03:56 PM
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.

Bruce_L
Posted : Wednesday, June 18, 2014 1:11:47 PM


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
ETF2008
Posted : Friday, June 20, 2014 10:27:22 PM
Gold Customer 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

Bruce_L
Posted : Monday, June 23, 2014 1:51:36 PM


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
ETF2008
Posted : Monday, June 23, 2014 4:39:35 PM
Gold Customer Gold Customer

Joined: 6/17/2008
Posts: 31

Thank you Bruce. I got it.

ETF2008
Posted : Monday, July 13, 2015 7:14:48 PM
Gold Customer 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

Bruce_L
Posted : Tuesday, July 14, 2015 10:33:25 AM


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
ETF2008
Posted : Tuesday, July 21, 2015 4:59:28 AM
Gold Customer 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

Bruce_L
Posted : Tuesday, July 21, 2015 10:06:44 AM


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
ETF2008
Posted : Friday, July 24, 2015 7:25:55 AM
Gold Customer 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

Bruce_L
Posted : Friday, July 24, 2015 8:35:24 AM


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
ETF2008
Posted : Sunday, July 26, 2015 7:53:08 AM
Gold Customer Gold Customer

Joined: 6/17/2008
Posts: 31

Thank you so much , Bruce.

SAM

ETF2008
Posted : Tuesday, December 6, 2016 5:12:43 PM
Gold Customer 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

 

Bruce_L
Posted : Thursday, December 8, 2016 9:39:50 AM


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
ETF2008
Posted : Thursday, December 8, 2016 6:16:52 PM
Gold Customer Gold Customer

Joined: 6/17/2008
Posts: 31

thanks . I got it

Bruce_L
Posted : Friday, December 9, 2016 9:04:08 AM


Worden Trainer

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

You're welcome.



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