I currently have scans for  4 bars up:

C > O AND C1 > O1 AND C2 > O2 AND C3 > O3

Is there a way  to create a formula that will output how many bars up there are for a given time frame?

Many thanks for any help.

I may want to limit this to looking for maybe 5-10 bars up or fewer to simplify this.

The following uses the techniques in the Days Since Last Peak (or other day-counting needs) topic and maxse out at 30 bars. It isn't all that long, but we could still shorten it to 5 or 10 bars if you want.

ABS(C > O) * (ABS(C1 <= O1) + ABS(C1 > O1) * (ABS(C2 <= O2) * 2 + ABS(C2 > O2) * (ABS(C3 <= O3) * 3 + ABS(C3 > O3) * (ABS(C4 <= O4) * 4 + ABS(C4 > O4) * (ABS(C5 <= O5) * 5 + ABS(C5 > O5) * (ABS(C6 <= O6) * 6 + ABS(C6 > O6) * (ABS(C7 <= O7) * 7 + ABS(C7 > O7) * (ABS(C8 <= O8) * 8 + ABS(C8 > O8) * (ABS(C9 <= O9) * 9 + ABS(C9 > O9) * (ABS(C10 <= O10) * 10 + ABS(C10 > O10) * (ABS(C11 <= O11) * 11 + ABS(C11 > O11) * (ABS(C12 <= O12) * 12 + ABS(C12 > O12) * (ABS(C13 <= O13) * 13 + ABS(C13 > O13) * (ABS(C14 <= O14) * 14 + ABS(C14 > O14) * (ABS(C15 <= O15) * 15 + ABS(C15 > O15) * (ABS(C16 <= O16) * 16 + ABS(C16 > O16) * (ABS(C17 <= O17) * 17 + ABS(C17 > O17) * (ABS(C18 <= O18) * 18 + ABS(C18 > O18) * (ABS(C19 <= O19) * 19 + ABS(C19 > O19) * (ABS(C20 <= O20) * 20 + ABS(C20 > O20) * (ABS(C21 <= O21) * 21 + ABS(C21 > O21) * (ABS(C22 <= O22) * 22 + ABS(C22 > O22) * (ABS(C23 <= O23) * 23 + ABS(C23 > O23) * (ABS(C24 <= O24) * 24 + ABS(C24 > O24) * (ABS(C25 <= O25) * 25 + ABS(C25 > O25) * (ABS(C26 <= O26) * 26 + ABS(C26 > O26) * (ABS(C27 <= O27) * 27 + ABS(C27 > O27) * (ABS(C28 <= O28) * 28 + ABS(C28 > O28) * (ABS(C29 <= O29) * 29 + ABS(C29 > O29) * 30)))))))))))))))))))))))))))))

Bruce,

   Very impressive.

Just what I was looking for.

Thank you very much.

Don

Bruce,

   If i wanted to create a formula that outputs bars above 8ema or (any other criteria) similar to the bars up you created above this posting, could I replace in your formula like this:

ABS(C > O) * (ABS(C1 <= O1)      becomes

ABS(C > XAVGC8) * (ABS(C1 <= XAVGC8.1)

and maybe do this for about 12 bars max.

Essentially replacing all of the O's with the appropriately numbered  XAVGC8.

Maybe using Word find and replace to do so.

Many thanks for any help.

Don

I just realized I probably want at least 30 bars for the formula.

That is exactly what you would need to do. Just make sure you lop off the terms you aren't using and make sure you have the correct number of closing parentheses at the the end of the formula.

If you want all 30 bars, then it is just a matter of using a text editor to replace O with XAVGC. instead.

ABS(C > XAVGC8) * (ABS(C1 <= XAVGC8.1) + ABS(C1 > XAVGC8.1) * (ABS(C2 <= XAVGC8.2) * 2 + ABS(C2 > XAVGC8.2) * (ABS(C3 <= XAVGC8.3) * 3 + ABS(C3 > XAVGC8.3) * (ABS(C4 <= XAVGC8.4) * 4 + ABS(C4 > XAVGC8.4) * (ABS(C5 <= XAVGC8.5) * 5 + ABS(C5 > XAVGC8.5) * (ABS(C6 <= XAVGC8.6) * 6 + ABS(C6 > XAVGC8.6) * (ABS(C7 <= XAVGC8.7) * 7 + ABS(C7 > XAVGC8.7) * (ABS(C8 <= XAVGC8.8) * 8 + ABS(C8 > XAVGC8.8) * (ABS(C9 <= XAVGC8.9) * 9 + ABS(C9 > XAVGC8.9) * (ABS(C10 <= XAVGC8.10) * 10 + ABS(C10 > XAVGC8.10) * (ABS(C11 <= XAVGC8.11) * 11 + ABS(C11 > XAVGC8.11) * (ABS(C12 <= XAVGC8.12) * 12 + ABS(C12 > XAVGC8.12) * (ABS(C13 <= XAVGC8.13) * 13 + ABS(C13 > XAVGC8.13) * (ABS(C14 <= XAVGC8.14) * 14 + ABS(C14 > XAVGC8.14) * (ABS(C15 <= XAVGC8.15) * 15 + ABS(C15 > XAVGC8.15) * (ABS(C16 <= XAVGC8.16) * 16 + ABS(C16 > XAVGC8.16) * (ABS(C17 <= XAVGC8.17) * 17 + ABS(C17 > XAVGC8.17) * (ABS(C18 <= XAVGC8.18) * 18 + ABS(C18 > XAVGC8.18) * (ABS(C19 <= XAVGC8.19) * 19 + ABS(C19 > XAVGC8.19) * (ABS(C20 <= XAVGC8.20) * 20 + ABS(C20 > XAVGC8.20) * (ABS(C21 <= XAVGC8.21) * 21 + ABS(C21 > XAVGC8.21) * (ABS(C22 <= XAVGC8.22) * 22 + ABS(C22 > XAVGC8.22) * (ABS(C23 <= XAVGC8.23) * 23 + ABS(C23 > XAVGC8.23) * (ABS(C24 <= XAVGC8.24) * 24 + ABS(C24 > XAVGC8.24) * (ABS(C25 <= XAVGC8.25) * 25 + ABS(C25 > XAVGC8.25) * (ABS(C26 <= XAVGC8.26) * 26 + ABS(C26 > XAVGC8.26) * (ABS(C27 <= XAVGC8.27) * 27 + ABS(C27 > XAVGC8.27) * (ABS(C28 <= XAVGC8.28) * 28 + ABS(C28 > XAVGC8.28) * (ABS(C29 <= XAVGC8.29) * 29 + ABS(C29 > XAVGC8.29) * 30)))))))))))))))))))))))))))))

Bruce,

  Works great!

Thank you very much.

Don

Bruce,

     Is it possible to create similar formulas to those above that output the # of bars

TSV13 >0

BOP1 >30

These would be separate, independent situations.

Many thanks for your help.

The following formula for TSV13 > 0 uses the same 30 day lookback as the previous formulas.

ABS(TSV13 > 0) * (ABS(TSV13.1 <= 0) + ABS(TSV13.1 > 0) * (ABS(TSV13.2 <= 0) * 2 + ABS(TSV13.2 > 0) * (ABS(TSV13.3 <= 0) * 3 + ABS(TSV13.3 > 0) * (ABS(TSV13.4 <= 0) * 4 + ABS(TSV13.4 > 0) * (ABS(TSV13.5 <= 0) * 5 + ABS(TSV13.5 > 0) * (ABS(TSV13.6 <= 0) * 6 + ABS(TSV13.6 > 0) * (ABS(TSV13.7 <= 0) * 7 + ABS(TSV13.7 > 0) * (ABS(TSV13.8 <= 0) * 8 + ABS(TSV13.8 > 0) * (ABS(TSV13.9 <= 0) * 9 + ABS(TSV13.9 > 0) * (ABS(TSV13.10 <= 0) * 10 + ABS(TSV13.10 > 0) * (ABS(TSV13.11 <= 0) * 11 + ABS(TSV13.11 > 0) * (ABS(TSV13.12 <= 0) * 12 + ABS(TSV13.12 > 0) * (ABS(TSV13.13 <= 0) * 13 + ABS(TSV13.13 > 0) * (ABS(TSV13.14 <= 0) * 14 + ABS(TSV13.14 > 0) * (ABS(TSV13.15 <= 0) * 15 + ABS(TSV13.15 > 0) * (ABS(TSV13.16 <= 0) * 16 + ABS(TSV13.16 > 0) * (ABS(TSV13.17 <= 0) * 17 + ABS(TSV13.17 > 0) * (ABS(TSV13.18 <= 0) * 18 + ABS(TSV13.18 > 0) * (ABS(TSV13.19 <= 0) * 19 + ABS(TSV13.19 > 0) * (ABS(TSV13.20 <= 0) * 20 + ABS(TSV13.20 > 0) * (ABS(TSV13.21 <= 0) * 21 + ABS(TSV13.21 > 0) * (ABS(TSV13.22 <= 0) * 22 + ABS(TSV13.22 > 0) * (ABS(TSV13.23 <= 0) * 23 + ABS(TSV13.23 > 0) * (ABS(TSV13.24 <= 0) * 24 + ABS(TSV13.24 > 0) * (ABS(TSV13.25 <= 0) * 25 + ABS(TSV13.25 > 0) * (ABS(TSV13.26 <= 0) * 26 + ABS(TSV13.26 > 0) * (ABS(TSV13.27 <= 0) * 27 + ABS(TSV13.27 > 0) * (ABS(TSV13.28 <= 0) * 28 + ABS(TSV13.28 > 0) * (ABS(TSV13.29 <= 0) * 29 + ABS(TSV13.29 > 0) * 30)))))))))))))))))))))))))))))

The following formula for BOP > 30 uses the same 30 day lookback as the previous formulas.

ABS(BOP > 30) * (ABS(BOP1.1 <= 30) + ABS(BOP1.1 > 30) * (ABS(BOP1.2 <= 30) * 2 + ABS(BOP1.2 > 30) * (ABS(BOP1.3 <= 30) * 3 + ABS(BOP1.3 > 30) * (ABS(BOP1.4 <= 30) * 4 + ABS(BOP1.4 > 30) * (ABS(BOP1.5 <= 30) * 5 + ABS(BOP1.5 > 30) * (ABS(BOP1.6 <= 30) * 6 + ABS(BOP1.6 > 30) * (ABS(BOP1.7 <= 30) * 7 + ABS(BOP1.7 > 30) * (ABS(BOP1.8 <= 30) * 8 + ABS(BOP1.8 > 30) * (ABS(BOP1.9 <= 30) * 9 + ABS(BOP1.9 > 30) * (ABS(BOP1.10 <= 30) * 10 + ABS(BOP1.10 > 30) * (ABS(BOP1.11 <= 30) * 11 + ABS(BOP1.11 > 30) * (ABS(BOP1.12 <= 30) * 12 + ABS(BOP1.12 > 30) * (ABS(BOP1.13 <= 30) * 13 + ABS(BOP1.13 > 30) * (ABS(BOP1.14 <= 30) * 14 + ABS(BOP1.14 > 30) * (ABS(BOP1.15 <= 30) * 15 + ABS(BOP1.15 > 30) * (ABS(BOP1.16 <= 30) * 16 + ABS(BOP1.16 > 30) * (ABS(BOP1.17 <= 30) * 17 + ABS(BOP1.17 > 30) * (ABS(BOP1.18 <= 30) * 18 + ABS(BOP1.18 > 30) * (ABS(BOP1.19 <= 30) * 19 + ABS(BOP1.19 > 30) * (ABS(BOP1.20 <= 30) * 20 + ABS(BOP1.20 > 30) * (ABS(BOP1.21 <= 30) * 21 + ABS(BOP1.21 > 30) * (ABS(BOP1.22 <= 30) * 22 + ABS(BOP1.22 > 30) * (ABS(BOP1.23 <= 30) * 23 + ABS(BOP1.23 > 30) * (ABS(BOP1.24 <= 30) * 24 + ABS(BOP1.24 > 30) * (ABS(BOP1.25 <= 30) * 25 + ABS(BOP1.25 > 30) * (ABS(BOP1.26 <= 30) * 26 + ABS(BOP1.26 > 30) * (ABS(BOP1.27 <= 30) * 27 + ABS(BOP1.27 > 30) * (ABS(BOP1.28 <= 30) * 28 + ABS(BOP1.28 > 30) * (ABS(BOP1.29 <= 30) * 29 + ABS(BOP1.29 > 30) * 30)))))))))))))))))))))))))))))

Bruce,

   Wow, that's fantastic.

Thank you very much!

Is it correct to say that this formula can be used for almost anything that's available in tc2000 whether it's a value or a parameter ?

In other words, are there limitations in its application?

Also, does this part of the formula have to be    ABS(BOP1.1 <= 30)   ie. <= not just < ?

I am wondering if all of the above formulas give results of > than a value(parameter)  or >= to a value(parameter) ?

  Many thanks for all of your fine help!

Don

The basic technique can theoretically be used on any condition which can be expressed as a formula. It cannot be used on conditions which cannot be expressed as a formula.

As a practical matter some Condition Formulas would be to long to actually work.

The > and <= are used because they are the opposite of each other. There are matched pairs of formulas next to each other where one is checking for something being false and the other is checking for the same thing being true.

Bruce,

   Thank you for explaining that.

I forgot that they were matched false/true constructs.

I sometimes get lost in the software.

Can I have a count (30 bars) of L<L1.

Thanks

Please try the following Indicator Formula for the number of bars in a row where L < L1 (with i 30 bar maximum).

ABS(L < L1) * (ABS(L1 >= L2) + ABS(L1 < L2) * (ABS(L2 >= L3) * 2 + ABS(L2 < L3) * (ABS(L3 >= L4) * 3 + ABS(L3 < L4) * (ABS(L4 >= L5) * 4 + ABS(L4 < L5) * (ABS(L5 >= L6) * 5 + ABS(L5 < L6) * (ABS(L6 >= L7) * 6 + ABS(L6 < L7) * (ABS(L7 >= L8) * 7 + ABS(L7 < L8) * (ABS(L8 >= L9) * 8 + ABS(L8 < L9) * (ABS(L9 >= L10) * 9 + ABS(L9 < L10) * (ABS(L10 >= L11) * 10 + ABS(L10 < L11) * (ABS(L11 >= L12) * 11 + ABS(L11 < L12) * (ABS(L12 >= L13) * 12 + ABS(L12 < L13) * (ABS(L13 >= L14) * 13 + ABS(L13 < L14) * (ABS(L14 >= L15) * 14 + ABS(L14 < L15) * (ABS(L15 >= L16) * 15 + ABS(L15 < L16) * (ABS(L16 >= L17) * 16 + ABS(L16 < L17) * (ABS(L17 >= L18) * 17 + ABS(L17 < L18) * (ABS(L18 >= L19) * 18 + ABS(L18 < L19) * (ABS(L19 >= L20) * 19 + ABS(L19 < L20) * (ABS(L20 >= L21) * 20 + ABS(L20 < L21) * (ABS(L21 >= L22) * 21 + ABS(L21 < L22) * (ABS(L22 >= L23) * 22 + ABS(L22 < L23) * (ABS(L23 >= L24) * 23 + ABS(L23 < L24) * (ABS(L24 >= L25) * 24 + ABS(L24 < L25) * (ABS(L25 >= L26) * 25 + ABS(L25 < L26) * (ABS(L26 >= L27) * 26 + ABS(L26 < L27) * (ABS(L27 >= L28) * 27 + ABS(L27 < L28) * (ABS(L28 >= L29) * 28 + ABS(L28 < L29) * (ABS(L29 >= L30) * 29 + ABS(L29 < L30) * 30)))))))))))))))))))))))))))))

Can you do one for: C>C4

and one for C<C4

Thanks

ABS(C > C4) * (ABS(C1 <= C5) + ABS(C1 > C5) * (ABS(C2 <= C6) * 2 + ABS(C2 > C6) * (ABS(C3 <= C7) * 3 + ABS(C3 > C7) * (ABS(C4 <= C8) * 4 + ABS(C4 > C8) * (ABS(C5 <= C9) * 5 + ABS(C5 > C9) * (ABS(C6 <= C10) * 6 + ABS(C6 > C10) * (ABS(C7 <= C11) * 7 + ABS(C7 > C11) * (ABS(C8 <= C12) * 8 + ABS(C8 > C12) * (ABS(C9 <= C13) * 9 + ABS(C9 > C13) * (ABS(C10 <= C14) * 10 + ABS(C10 > C14) * (ABS(C11 <= C15) * 11 + ABS(C11 > C15) * (ABS(C12 <= C16) * 12 + ABS(C12 > C16) * (ABS(C13 <= C17) * 13 + ABS(C13 > C17) * (ABS(C14 <= C18) * 14 + ABS(C14 > C18) * (ABS(C15 <= C19) * 15 + ABS(C15 > C19) * (ABS(C16 <= C20) * 16 + ABS(C16 > C20) * (ABS(C17 <= C21) * 17 + ABS(C17 > C21) * (ABS(C18 <= C22) * 18 + ABS(C18 > C22) * (ABS(C19 <= C23) * 19 + ABS(C19 > C23) * (ABS(C20 <= C24) * 20 + ABS(C20 > C24) * (ABS(C21 <= C25) * 21 + ABS(C21 > C25) * (ABS(C22 <= C26) * 22 + ABS(C22 > C26) * (ABS(C23 <= C27) * 23 + ABS(C23 > C27) * (ABS(C24 <= C28) * 24 + ABS(C24 > C28) * (ABS(C25 <= C29) * 25 + ABS(C25 > C29) * (ABS(C26 <= C30) * 26 + ABS(C26 > C30) * (ABS(C27 <= C31) * 27 + ABS(C27 > C31) * (ABS(C28 <= C32) * 28 + ABS(C28 > C32) * (ABS(C29 <= C33) * 29 + ABS(C29 > C33) * 30)))))))))))))))))))))))))))))

ABS(C < C4) * (ABS(C1 >= C5) + ABS(C1 < C5) * (ABS(C2 >= C6) * 2 + ABS(C2 < C6) * (ABS(C3 >= C7) * 3 + ABS(C3 < C7) * (ABS(C4 >= C8) * 4 + ABS(C4 < C8) * (ABS(C5 >= C9) * 5 + ABS(C5 < C9) * (ABS(C6 >= C10) * 6 + ABS(C6 < C10) * (ABS(C7 >= C11) * 7 + ABS(C7 < C11) * (ABS(C8 >= C12) * 8 + ABS(C8 < C12) * (ABS(C9 >= C13) * 9 + ABS(C9 < C13) * (ABS(C10 >= C14) * 10 + ABS(C10 < C14) * (ABS(C11 >= C15) * 11 + ABS(C11 < C15) * (ABS(C12 >= C16) * 12 + ABS(C12 < C16) * (ABS(C13 >= C17) * 13 + ABS(C13 < C17) * (ABS(C14 >= C18) * 14 + ABS(C14 < C18) * (ABS(C15 >= C19) * 15 + ABS(C15 < C19) * (ABS(C16 >= C20) * 16 + ABS(C16 < C20) * (ABS(C17 >= C21) * 17 + ABS(C17 < C21) * (ABS(C18 >= C22) * 18 + ABS(C18 < C22) * (ABS(C19 >= C23) * 19 + ABS(C19 < C23) * (ABS(C20 >= C24) * 20 + ABS(C20 < C24) * (ABS(C21 >= C25) * 21 + ABS(C21 < C25) * (ABS(C22 >= C26) * 22 + ABS(C22 < C26) * (ABS(C23 >= C27) * 23 + ABS(C23 < C27) * (ABS(C24 >= C28) * 24 + ABS(C24 < C28) * (ABS(C25 >= C29) * 25 + ABS(C25 < C29) * (ABS(C26 >= C30) * 26 + ABS(C26 < C30) * (ABS(C27 >= C31) * 27 + ABS(C27 < C31) * (ABS(C28 >= C32) * 28 + ABS(C28 < C32) * (ABS(C29 >= C33) * 29 + ABS(C29 < C33) * 30)))))))))))))))))))))))))))))

Hi Bruce,

   I am trying to create  pcfs similar to the ones you did for tsv13 and bop above but instead for rising

moneystream and rising obv as separate pcfs.

  Please help me.

Thank you,

Don

Please try the following for rising MoneyStream.

ABS(MS1 > MS1.1) * (ABS(MS1.1 <= MS1.2) + ABS(MS1.1 > MS1.2) * (ABS(MS1.2 <= MS1.3) * 2 + ABS(MS1.2 > MS1.3) * (ABS(MS1.3 <= MS1.4) * 3 + ABS(MS1.3 > MS1.4) * (ABS(MS1.4 <= MS1.5) * 4 + ABS(MS1.4 > MS1.5) * (ABS(MS1.5 <= MS1.6) * 5 + ABS(MS1.5 > MS1.6) * (ABS(MS1.6 <= MS1.7) * 6 + ABS(MS1.6 > MS1.7) * (ABS(MS1.7 <= MS1.8) * 7 + ABS(MS1.7 > MS1.8) * (ABS(MS1.8 <= MS1.9) * 8 + ABS(MS1.8 > MS1.9) * (ABS(MS1.9 <= MS1.10) * 9 + ABS(MS1.9 > MS1.10) * (ABS(MS1.10 <= MS1.11) * 10 + ABS(MS1.10 > MS1.11) * (ABS(MS1.11 <= MS1.12) * 11 + ABS(MS1.11 > MS1.12) * (ABS(MS1.12 <= MS1.13) * 12 + ABS(MS1.12 > MS1.13) * (ABS(MS1.13 <= MS1.14) * 13 + ABS(MS1.13 > MS1.14) * (ABS(MS1.14 <= MS1.15) * 14 + ABS(MS1.14 > MS1.15) * (ABS(MS1.15 <= MS1.16) * 15 + ABS(MS1.15 > MS1.16) * (ABS(MS1.16 <= MS1.17) * 16 + ABS(MS1.16 > MS1.17) * (ABS(MS1.17 <= MS1.18) * 17 + ABS(MS1.17 > MS1.18) * (ABS(MS1.18 <= MS1.19) * 18 + ABS(MS1.18 > MS1.19) * (ABS(MS1.19 <= MS1.20) * 19 + ABS(MS1.19 > MS1.20) * (ABS(MS1.20 <= MS1.21) * 20 + ABS(MS1.20 > MS1.21) * (ABS(MS1.21 <= MS1.22) * 21 + ABS(MS1.21 > MS1.22) * (ABS(MS1.22 <= MS1.23) * 22 + ABS(MS1.22 > MS1.23) * (ABS(MS1.23 <= MS1.24) * 23 + ABS(MS1.23 > MS1.24) * (ABS(MS1.24 <= MS1.25) * 24 + ABS(MS1.24 > MS1.25) * (ABS(MS1.25 <= MS1.26) * 25 + ABS(MS1.25 > MS1.26) * (ABS(MS1.26 <= MS1.27) * 26 + ABS(MS1.26 > MS1.27) * (ABS(MS1.27 <= MS1.28) * 27 + ABS(MS1.27 > MS1.28) * (ABS(MS1.28 <= MS1.29) * 28 + ABS(MS1.28 > MS1.29) * (ABS(MS1.29 <= MS1.30) * 29 + ABS(MS1.29 > MS1.30) * 30)))))))))))))))))))))))))))))

And the following for rising On Balance Volume.

ABS(OBV1 > OBV1.1) * (ABS(OBV1.1 <= OBV1.2) + ABS(OBV1.1 > OBV1.2) * (ABS(OBV1.2 <= OBV1.3) * 2 + ABS(OBV1.2 > OBV1.3) * (ABS(OBV1.3 <= OBV1.4) * 3 + ABS(OBV1.3 > OBV1.4) * (ABS(OBV1.4 <= OBV1.5) * 4 + ABS(OBV1.4 > OBV1.5) * (ABS(OBV1.5 <= OBV1.6) * 5 + ABS(OBV1.5 > OBV1.6) * (ABS(OBV1.6 <= OBV1.7) * 6 + ABS(OBV1.6 > OBV1.7) * (ABS(OBV1.7 <= OBV1.8) * 7 + ABS(OBV1.7 > OBV1.8) * (ABS(OBV1.8 <= OBV1.9) * 8 + ABS(OBV1.8 > OBV1.9) * (ABS(OBV1.9 <= OBV1.10) * 9 + ABS(OBV1.9 > OBV1.10) * (ABS(OBV1.10 <= OBV1.11) * 10 + ABS(OBV1.10 > OBV1.11) * (ABS(OBV1.11 <= OBV1.12) * 11 + ABS(OBV1.11 > OBV1.12) * (ABS(OBV1.12 <= OBV1.13) * 12 + ABS(OBV1.12 > OBV1.13) * (ABS(OBV1.13 <= OBV1.14) * 13 + ABS(OBV1.13 > OBV1.14) * (ABS(OBV1.14 <= OBV1.15) * 14 + ABS(OBV1.14 > OBV1.15) * (ABS(OBV1.15 <= OBV1.16) * 15 + ABS(OBV1.15 > OBV1.16) * (ABS(OBV1.16 <= OBV1.17) * 16 + ABS(OBV1.16 > OBV1.17) * (ABS(OBV1.17 <= OBV1.18) * 17 + ABS(OBV1.17 > OBV1.18) * (ABS(OBV1.18 <= OBV1.19) * 18 + ABS(OBV1.18 > OBV1.19) * (ABS(OBV1.19 <= OBV1.20) * 19 + ABS(OBV1.19 > OBV1.20) * (ABS(OBV1.20 <= OBV1.21) * 20 + ABS(OBV1.20 > OBV1.21) * (ABS(OBV1.21 <= OBV1.22) * 21 + ABS(OBV1.21 > OBV1.22) * (ABS(OBV1.22 <= OBV1.23) * 22 + ABS(OBV1.22 > OBV1.23) * (ABS(OBV1.23 <= OBV1.24) * 23 + ABS(OBV1.23 > OBV1.24) * (ABS(OBV1.24 <= OBV1.25) * 24 + ABS(OBV1.24 > OBV1.25) * (ABS(OBV1.25 <= OBV1.26) * 25 + ABS(OBV1.25 > OBV1.26) * (ABS(OBV1.26 <= OBV1.27) * 26 + ABS(OBV1.26 > OBV1.27) * (ABS(OBV1.27 <= OBV1.28) * 27 + ABS(OBV1.27 > OBV1.28) * (ABS(OBV1.28 <= OBV1.29) * 28 + ABS(OBV1.28 > OBV1.29) * (ABS(OBV1.29 <= OBV1.30) * 29 + ABS(OBV1.29 > OBV1.30) * 30)))))))))))))))))))))))))))))

Bruce,

   Thank you  very much for these.

I really appreciate your efforts!

They both work great.

When I was trying to create them for myself I wasn't sure whether to use MS1 or MS in the first part of the pcf:

ABS(MS1 > MS1.1) *....

I noticed for BOP above you used BOP not BOP1 in the similar position in the pcf.

Does this matter?

The 1 after MS1  designates a 1 period SMA of the indicator.

Thank you again for  all of your help.

Don

It shouldn't matter. MS should be the same MS1 and OBV1 should be the same thing as OBV.

Bruce,

This pcf that you wrote from above has proven to be very useful.

Is there an easy way to expand it from 30 bars to 60 bars?

Many thanks for all of your wonderful help.

Don

Please try the following Indicator Formula.

ABS(C > XAVGC8) * (ABS(C1 <= XAVGC8.1) + ABS(C1 > XAVGC8.1) * (ABS(C2 <= XAVGC8.2) * 2 + ABS(C2 > XAVGC8.2) * (ABS(C3 <= XAVGC8.3) * 3 + ABS(C3 > XAVGC8.3) * (ABS(C4 <= XAVGC8.4) * 4 + ABS(C4 > XAVGC8.4) * (ABS(C5 <= XAVGC8.5) * 5 + ABS(C5 > XAVGC8.5) * (ABS(C6 <= XAVGC8.6) * 6 + ABS(C6 > XAVGC8.6) * (ABS(C7 <= XAVGC8.7) * 7 + ABS(C7 > XAVGC8.7) * (ABS(C8 <= XAVGC8.8) * 8 + ABS(C8 > XAVGC8.8) * (ABS(C9 <= XAVGC8.9) * 9 + ABS(C9 > XAVGC8.9) * (ABS(C10 <= XAVGC8.10) * 10 + ABS(C10 > XAVGC8.10) * (ABS(C11 <= XAVGC8.11) * 11 + ABS(C11 > XAVGC8.11) * (ABS(C12 <= XAVGC8.12) * 12 + ABS(C12 > XAVGC8.12) * (ABS(C13 <= XAVGC8.13) * 13 + ABS(C13 > XAVGC8.13) * (ABS(C14 <= XAVGC8.14) * 14 + ABS(C14 > XAVGC8.14) * (ABS(C15 <= XAVGC8.15) * 15 + ABS(C15 > XAVGC8.15) * (ABS(C16 <= XAVGC8.16) * 16 + ABS(C16 > XAVGC8.16) * (ABS(C17 <= XAVGC8.17) * 17 + ABS(C17 > XAVGC8.17) * (ABS(C18 <= XAVGC8.18) * 18 + ABS(C18 > XAVGC8.18) * (ABS(C19 <= XAVGC8.19) * 19 + ABS(C19 > XAVGC8.19) * (ABS(C20 <= XAVGC8.20) * 20 + ABS(C20 > XAVGC8.20) * (ABS(C21 <= XAVGC8.21) * 21 + ABS(C21 > XAVGC8.21) * (ABS(C22 <= XAVGC8.22) * 22 + ABS(C22 > XAVGC8.22) * (ABS(C23 <= XAVGC8.23) * 23 + ABS(C23 > XAVGC8.23) * (ABS(C24 <= XAVGC8.24) * 24 + ABS(C24 > XAVGC8.24) * (ABS(C25 <= XAVGC8.25) * 25 + ABS(C25 > XAVGC8.25) * (ABS(C26 <= XAVGC8.26) * 26 + ABS(C26 > XAVGC8.26) * (ABS(C27 <= XAVGC8.27) * 27 + ABS(C27 > XAVGC8.27) * (ABS(C28 <= XAVGC8.28) * 28 + ABS(C28 > XAVGC8.28) * (ABS(C29 <= XAVGC8.29) * 29 + ABS(C29 > XAVGC8.29) * (ABS(C30 <= XAVGC8.30) * 30 + ABS(C30 > XAVGC8.30) * (ABS(C31 <= XAVGC8.31) * 31 + ABS(C31 > XAVGC8.31) * (ABS(C32 <= XAVGC8.32) * 32 + ABS(C32 > XAVGC8.32) * (ABS(C33 <= XAVGC8.33) * 33 + ABS(C33 > XAVGC8.33) * (ABS(C34 <= XAVGC8.34) * 34 + ABS(C34 > XAVGC8.34) * (ABS(C35 <= XAVGC8.35) * 35 + ABS(C35 > XAVGC8.35) * (ABS(C36 <= XAVGC8.36) * 36 + ABS(C36 > XAVGC8.36) * (ABS(C37 <= XAVGC8.37) * 37 + ABS(C37 > XAVGC8.37) * (ABS(C38 <= XAVGC8.38) * 38 + ABS(C38 > XAVGC8.38) * (ABS(C39 <= XAVGC8.39) * 39 + ABS(C39 > XAVGC8.39) * (ABS(C40 <= XAVGC8.40) * 40 + ABS(C40 > XAVGC8.40) * (ABS(C41 <= XAVGC8.41) * 41 + ABS(C41 > XAVGC8.41) * (ABS(C42 <= XAVGC8.42) * 42 + ABS(C42 > XAVGC8.42) * (ABS(C43 <= XAVGC8.43) * 43 + ABS(C43 > XAVGC8.43) * (ABS(C44 <= XAVGC8.44) * 44 + ABS(C44 > XAVGC8.44) * (ABS(C45 <= XAVGC8.45) * 45 + ABS(C45 > XAVGC8.45) * (ABS(C46 <= XAVGC8.46) * 46 + ABS(C46 > XAVGC8.46) * (ABS(C47 <= XAVGC8.47) * 47 + ABS(C47 > XAVGC8.47) * (ABS(C48 <= XAVGC8.48) * 48 + ABS(C48 > XAVGC8.48) * (ABS(C49 <= XAVGC8.49) * 49 + ABS(C49 > XAVGC8.49) * (ABS(C50 <= XAVGC8.50) * 50 + ABS(C50 > XAVGC8.50) * (ABS(C51 <= XAVGC8.51) * 51 + ABS(C51 > XAVGC8.51) * (ABS(C52 <= XAVGC8.52) * 52 + ABS(C52 > XAVGC8.52) * (ABS(C53 <= XAVGC8.53) * 53 + ABS(C53 > XAVGC8.53) * (ABS(C54 <= XAVGC8.54) * 54 + ABS(C54 > XAVGC8.54) * (ABS(C55 <= XAVGC8.55) * 55 + ABS(C55 > XAVGC8.55) * (ABS(C56 <= XAVGC8.56) * 56 + ABS(C56 > XAVGC8.56) * (ABS(C57 <= XAVGC8.57) * 57 + ABS(C57 > XAVGC8.57) * (ABS(C58 <= XAVGC8.58) * 58 + ABS(C58 > XAVGC8.58) * (ABS(C59 <= XAVGC8.59) * 59 + ABS(C59 > XAVGC8.59) * 60)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Bruce,

   Thank you very much for all of your excellent work!

Don

You're welcome.

Bruce, 

  Many thanks for creating the above pcfs, they are proving to be very useful.

Could you please create a pcf similar to the above but for a rising TSV13?

Thank you,

Don

Please try the following.

ABS(TSV13 > TSV13.1) * (ABS(TSV13.1 <= TSV13.2) + ABS(TSV13.1 > TSV13.2) * (ABS(TSV13.2 <= TSV13.3) * 2 + ABS(TSV13.2 > TSV13.3) * (ABS(TSV13.3 <= TSV13.4) * 3 + ABS(TSV13.3 > TSV13.4) * (ABS(TSV13.4 <= TSV13.5) * 4 + ABS(TSV13.4 > TSV13.5) * (ABS(TSV13.5 <= TSV13.6) * 5 + ABS(TSV13.5 > TSV13.6) * (ABS(TSV13.6 <= TSV13.7) * 6 + ABS(TSV13.6 > TSV13.7) * (ABS(TSV13.7 <= TSV13.8) * 7 + ABS(TSV13.7 > TSV13.8) * (ABS(TSV13.8 <= TSV13.9) * 8 + ABS(TSV13.8 > TSV13.9) * (ABS(TSV13.9 <= TSV13.10) * 9 + ABS(TSV13.9 > TSV13.10) * (ABS(TSV13.10 <= TSV13.11) * 10 + ABS(TSV13.10 > TSV13.11) * (ABS(TSV13.11 <= TSV13.12) * 11 + ABS(TSV13.11 > TSV13.12) * (ABS(TSV13.12 <= TSV13.13) * 12 + ABS(TSV13.12 > TSV13.13) * (ABS(TSV13.13 <= TSV13.14) * 13 + ABS(TSV13.13 > TSV13.14) * (ABS(TSV13.14 <= TSV13.15) * 14 + ABS(TSV13.14 > TSV13.15) * (ABS(TSV13.15 <= TSV13.16) * 15 + ABS(TSV13.15 > TSV13.16) * (ABS(TSV13.16 <= TSV13.17) * 16 + ABS(TSV13.16 > TSV13.17) * (ABS(TSV13.17 <= TSV13.18) * 17 + ABS(TSV13.17 > TSV13.18) * (ABS(TSV13.18 <= TSV13.19) * 18 + ABS(TSV13.18 > TSV13.19) * (ABS(TSV13.19 <= TSV13.20) * 19 + ABS(TSV13.19 > TSV13.20) * (ABS(TSV13.20 <= TSV13.21) * 20 + ABS(TSV13.20 > TSV13.21) * (ABS(TSV13.21 <= TSV13.22) * 21 + ABS(TSV13.21 > TSV13.22) * (ABS(TSV13.22 <= TSV13.23) * 22 + ABS(TSV13.22 > TSV13.23) * (ABS(TSV13.23 <= TSV13.24) * 23 + ABS(TSV13.23 > TSV13.24) * (ABS(TSV13.24 <= TSV13.25) * 24 + ABS(TSV13.24 > TSV13.25) * (ABS(TSV13.25 <= TSV13.26) * 25 + ABS(TSV13.25 > TSV13.26) * (ABS(TSV13.26 <= TSV13.27) * 26 + ABS(TSV13.26 > TSV13.27) * (ABS(TSV13.27 <= TSV13.28) * 27 + ABS(TSV13.27 > TSV13.28) * (ABS(TSV13.28 <= TSV13.29) * 28 + ABS(TSV13.28 > TSV13.29) * (ABS(TSV13.29 <= TSV13.30) * 29 + ABS(TSV13.29 > TSV13.30) * 30)))))))))))))))))))))))))))))

Bruce,

   Thank you very much.

It works great.

Don

You're welcome.