What formula ie required to scan for stocks that have 2 consecetive closing days outside the acceleration bands both on the upside and downside

Kelpie

Please try using the following Condition Formula as an EasyScan Condition (Period 20, Width 1.00):

Acceleration Bands

ABS(C - (AVGH20 + AVGL20 + ((H - L) ^ 2 / (H + L) + (H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19)) / 5) / 2) > 2.5 * (AVGH20 - AVGL20) AND ABS(C1 - (AVGH20.1 + AVGL20.1 + ((H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20)) / 5) / 2) > 2.5 * (AVGH20.1 - AVGL20.1)

Hi Bruce

I copied and pasted formula but it says formula error.

Upon clicking on test formula it says ( Argument missing near + )

Any help please

Jeff

This worked for me.

Did you use a percent true PCF?

Thanks

I don't get any error messages when I copy and paste the formula into TC2000. Please make sure you are copying and pasting the entire formula and not adding anything else. Even missing a single parenthesis could cause the type of error you are receiving.

I'm not sure what you mean by percent true PCF let alone know how to set as such

Please advise

Thanks

A Custom Percent True or Custom PCF % True Indicator takes a boolean (true or false) formula and converts it into an indicator which plots on the chart.

Visually Backtesting Specific Symbols

You would use the formula as the Boolean Formula in the Custom PCF % True Indicator. If the Period is set to 1, there will be a spike on the chart up to 100 when the Boolean Formula returns true and the value will be 0 when the Boolean Formula returns false. If the Period is longer than that, a Moving Average of the Average Type and Period of the Custom PCF % True Indicator will be applied to this series of 100s and 0s.

Bruce..... once in a while, when I copy one of your formulas off of these discussion pages, there is a dashed line across the bottom out of view that comes along with the formula.  If I scroll down to see if that line is there after pasting the formula into my program, error messages usually go away after erasing the line.

I have not been able to reproduce this (I've tried copying all sorts of extra bits beyond the formula and can get extra bits that cause errors, but no dashed line), but it is a good thing for other customers to look for if a formula which has been copied and pasted doesn't work. If it has happened to you, it has probably happened to others as well.

It doesn't happen all the time and only when I paste into 2007

I just used it in TC2000 and it worked just fine.

Thanks for making this formula available to us, it saved me a lot of work and learning (I'll get the learning anyway) but I wonder if there is any way to split in two, one for closes above Acc Bands, and one for BELOW the Acc Bands.

I did try splitting the formula at the AND but that isn't the secret

The formula as written checks for the distance from the centerline. So the AND in the middle is for each of the two days, not for above or below. A Condition Formula for being above the upper band for two consecutive bars would be:

C > (AVGH20 + AVGL20 + ((H - L) ^ 2 / (H + L) + (H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19)) / 5) / 2 + 2.5 * (AVGH20 - AVGL20) AND C1 > (AVGH20.1 + AVGL20.1 + ((H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20)) / 5) / 2 + 2.5 * (AVGH20.1 - AVGL20.1)

While a Condition Formula for being below the lower band for two consecutive bars would be:

C < (AVGH20 + AVGL20 + ((H - L) ^ 2 / (H + L) + (H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19)) / 5) / 2 - 2.5 * (AVGH20 - AVGL20) AND C1 < (AVGH20.1 + AVGL20.1 + ((H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20)) / 5) / 2 - 2.5 * (AVGH20.1 - AVGL20.1)

I don't see these formulae as working.

If I scan SP500 stocks after close Thursday, I get 7 stocks

FIS - price is not above Acc Bands 20 1

YHOO = price is not above Acc Bands 20 1

CSC  - price is not above Acc Bands 20 1 for two days , just one

VAR - price is above Acc Bands 20 1

SBUX - price is not above Acc Bands 20 1

ROK - price is not above Acc Bands 20 1

PWR - price is not above Acc Bands 20 1

and I get a similar mixed set of results for the Below scan.

Scrub this request, I need to retest.

Again sorry

And now I can confirm your formula do work - sorry

And thanks for developing them for me

I confess I do a lot of my learning by clicking on things until I find something that interests me, which results in the following questions:

The full objective of the Acc Bands 2 day Scan is to find stocks which have crossed above the Upper Acc Band two days ago, and then closed higher the next day (simplified). So I went looking for Close three days ago was under Upper Acc band and I discover a set of conditions for "Price History vs Accelaration Bands 20 1 "

a. Below Channel Top and

b. Crossing Up Chan Top, and so I ask myself (and now you :-)

Could I code my first objective in this narrative as "C2 Below Channel Top" and my original request as

"C1  Crossing Up Chan Top" and the last condition would be "C>C1"

Seems simple, but if its too good to be true......

Thanks

Please try the following Condition Formula:

C > C1 AND C1 > (AVGH20.1 + AVGL20.1 + ((H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20)) / 5) / 2 + 2.5 * (AVGH20.1 - AVGL20.1) AND C2 < (AVGH20.2 + AVGL20.2 + ((H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20) + (H21 - L21) ^ 2 / (H21 + L21)) / 5) / 2 + 2.5 * (AVGH20.2 - AVGL20.2)

Thanks Bruce, appreciate your help (sorry took so long to acknowledge) .

But I'm still interested in learning if there is an easier (or at least higher level) way to do this (I'm either intellectualy curious or lazy, take your pick). e.g. in another post re ADX signals, you suggested creating a 1 day offset.

In a simple case of

1. price crossed above Upper Acc Band yesterday, and

2. Closed higher today,

could I not create the 1 day offset for the first test, and then use C>C1 for the second?

Thanks

I really can't think of an easy way to create the Condition. The problem is that you can't add a 1-Period Simple Moving Average with an Offset of 1 to the Acceleration Bands. You can add the moving average to Price History, but the moving average would be of the close only. So if you then added Acceleration Bands to the moving average, the calculations would be based on the closing prices instead of on the highs and lows.

Thanks, I suspected there was a limitation there somewhere.

Bruce could provide this with C < C1 and The rest for the Lower AccBand

Please try the following Condition Formula.

C < C1 AND C1 < (AVGH20.1 + AVGL20.1 + ((H1 - L1) ^ 2 / (H1 + L1) + (H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20)) / 5) / 2 - 2.5 * (AVGH20.1 - AVGL20.1) AND C2 < (AVGH20.2 + AVGL20.2 + ((H2 - L2) ^ 2 / (H2 + L2) + (H3 - L3) ^ 2 / (H3 + L3) + (H4 - L4) ^ 2 / (H4 + L4) + (H5 - L5) ^ 2 / (H5 + L5) + (H6 - L6) ^ 2 / (H6 + L6) + (H7 - L7) ^ 2 / (H7 + L7) + (H8 - L8) ^ 2 / (H8 + L8) + (H9 - L9) ^ 2 / (H9 + L9) + (H10 - L10) ^ 2 / (H10 + L10) + (H11 - L11) ^ 2 / (H11 + L11) + (H12 - L12) ^ 2 / (H12 + L12) + (H13 - L13) ^ 2 / (H13 + L13) + (H14 - L14) ^ 2 / (H14 + L14) + (H15 - L15) ^ 2 / (H15 + L15) + (H16 - L16) ^ 2 / (H16 + L16) + (H17 - L17) ^ 2 / (H17 + L17) + (H18 - L18) ^ 2 / (H18 + L18) + (H19 - L19) ^ 2 / (H19 + L19) + (H20 - L20) ^ 2 / (H20 + L20) + (H21 - L21) ^ 2 / (H21 + L21)) / 5) / 2 - 2.5 * (AVGH20.2 - AVGL20.2)