Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Just plotting that value when it happens is fairly straghtforward. Use the following Formula in a Custom PCF Indicator with the Plot Style set to Dots in the same pane and scale as price.
IIF(BBBOT(2, 20) < BBBOT(2, 20, 1) AND C < BBBOT(2, 20, 1) AND (BBBOT(2, 20, 1) >= BBBOT(2, 20, 2) OR C1 >= BBBOT(2, 20, 2)), BBBOT(6, 20, 1), 1 / 0)
But continuing to plot a horizontal line past this points needs to be done with nested IIF() functions and results in a much longer formula. The following Formula used in the same way would keep plotting dots for up to 30 bars.
IIF(BBBOT(2, 20) < BBBOT(2, 20, 1) AND C < BBBOT(2, 20, 1) AND (BBBOT(2, 20, 1) >= BBBOT(2, 20, 2) OR C1 >= BBBOT(2, 20, 2)), BBBOT(6, 20, 1), IIF(BBBOT(2, 20, 1) < BBBOT(2, 20, 2) AND C1 < BBBOT(2, 20, 2) AND (BBBOT(2, 20, 2) >= BBBOT(2, 20, 3) OR C2 >= BBBOT(2, 20, 3)), BBBOT(6, 20, 2), IIF(BBBOT(2, 20, 2) < BBBOT(2, 20, 3) AND C2 < BBBOT(2, 20, 3) AND (BBBOT(2, 20, 3) >= BBBOT(2, 20, 4) OR C3 >= BBBOT(2, 20, 4)), BBBOT(6, 20, 3), IIF(BBBOT(2, 20, 3) < BBBOT(2, 20, 4) AND C3 < BBBOT(2, 20, 4) AND (BBBOT(2, 20, 4) >= BBBOT(2, 20, 5) OR C4 >= BBBOT(2, 20, 5)), BBBOT(6, 20, 4), IIF(BBBOT(2, 20, 4) < BBBOT(2, 20, 5) AND C4 < BBBOT(2, 20, 5) AND (BBBOT(2, 20, 5) >= BBBOT(2, 20, 6) OR C5 >= BBBOT(2, 20, 6)), BBBOT(6, 20, 5), IIF(BBBOT(2, 20, 5) < BBBOT(2, 20, 6) AND C5 < BBBOT(2, 20, 6) AND (BBBOT(2, 20, 6) >= BBBOT(2, 20, 7) OR C6 >= BBBOT(2, 20, 7)), BBBOT(6, 20, 6), IIF(BBBOT(2, 20, 6) < BBBOT(2, 20, 7) AND C6 < BBBOT(2, 20, 7) AND (BBBOT(2, 20, 7) >= BBBOT(2, 20, 8) OR C7 >= BBBOT(2, 20, 8)), BBBOT(6, 20, 7), IIF(BBBOT(2, 20, 7) < BBBOT(2, 20, 8) AND C7 < BBBOT(2, 20, 8) AND (BBBOT(2, 20, 8) >= BBBOT(2, 20, 9) OR C8 >= BBBOT(2, 20, 9)), BBBOT(6, 20, 8), IIF(BBBOT(2, 20, 8) < BBBOT(2, 20, 9) AND C8 < BBBOT(2, 20, 9) AND (BBBOT(2, 20, 9) >= BBBOT(2, 20, 10) OR C9 >= BBBOT(2, 20, 10)), BBBOT(6, 20, 9), IIF(BBBOT(2, 20, 9) < BBBOT(2, 20, 10) AND C9 < BBBOT(2, 20, 10) AND (BBBOT(2, 20, 10) >= BBBOT(2, 20, 11) OR C10 >= BBBOT(2, 20, 11)), BBBOT(6, 20, 10), IIF(BBBOT(2, 20, 10) < BBBOT(2, 20, 11) AND C10 < BBBOT(2, 20, 11) AND (BBBOT(2, 20, 11) >= BBBOT(2, 20, 12) OR C11 >= BBBOT(2, 20, 12)), BBBOT(6, 20, 11), IIF(BBBOT(2, 20, 11) < BBBOT(2, 20, 12) AND C11 < BBBOT(2, 20, 12) AND (BBBOT(2, 20, 12) >= BBBOT(2, 20, 13) OR C12 >= BBBOT(2, 20, 13)), BBBOT(6, 20, 12), IIF(BBBOT(2, 20, 12) < BBBOT(2, 20, 13) AND C12 < BBBOT(2, 20, 13) AND (BBBOT(2, 20, 13) >= BBBOT(2, 20, 14) OR C13 >= BBBOT(2, 20, 14)), BBBOT(6, 20, 13), IIF(BBBOT(2, 20, 13) < BBBOT(2, 20, 14) AND C13 < BBBOT(2, 20, 14) AND (BBBOT(2, 20, 14) >= BBBOT(2, 20, 15) OR C14 >= BBBOT(2, 20, 15)), BBBOT(6, 20, 14), IIF(BBBOT(2, 20, 14) < BBBOT(2, 20, 15) AND C14 < BBBOT(2, 20, 15) AND (BBBOT(2, 20, 15) >= BBBOT(2, 20, 16) OR C15 >= BBBOT(2, 20, 16)), BBBOT(6, 20, 15), IIF(BBBOT(2, 20, 15) < BBBOT(2, 20, 16) AND C15 < BBBOT(2, 20, 16) AND (BBBOT(2, 20, 16) >= BBBOT(2, 20, 17) OR C16 >= BBBOT(2, 20, 17)), BBBOT(6, 20, 16), IIF(BBBOT(2, 20, 16) < BBBOT(2, 20, 17) AND C16 < BBBOT(2, 20, 17) AND (BBBOT(2, 20, 17) >= BBBOT(2, 20, 18) OR C17 >= BBBOT(2, 20, 18)), BBBOT(6, 20, 17), IIF(BBBOT(2, 20, 17) < BBBOT(2, 20, 18) AND C17 < BBBOT(2, 20, 18) AND (BBBOT(2, 20, 18) >= BBBOT(2, 20, 19) OR C18 >= BBBOT(2, 20, 19)), BBBOT(6, 20, 18), IIF(BBBOT(2, 20, 18) < BBBOT(2, 20, 19) AND C18 < BBBOT(2, 20, 19) AND (BBBOT(2, 20, 19) >= BBBOT(2, 20, 20) OR C19 >= BBBOT(2, 20, 20)), BBBOT(6, 20, 19), IIF(BBBOT(2, 20, 19) < BBBOT(2, 20, 20) AND C19 < BBBOT(2, 20, 20) AND (BBBOT(2, 20, 20) >= BBBOT(2, 20, 21) OR C20 >= BBBOT(2, 20, 21)), BBBOT(6, 20, 20), IIF(BBBOT(2, 20, 20) < BBBOT(2, 20, 21) AND C20 < BBBOT(2, 20, 21) AND (BBBOT(2, 20, 21) >= BBBOT(2, 20, 22) OR C21 >= BBBOT(2, 20, 22)), BBBOT(6, 20, 21), IIF(BBBOT(2, 20, 21) < BBBOT(2, 20, 22) AND C21 < BBBOT(2, 20, 22) AND (BBBOT(2, 20, 22) >= BBBOT(2, 20, 23) OR C22 >= BBBOT(2, 20, 23)), BBBOT(6, 20, 22), IIF(BBBOT(2, 20, 22) < BBBOT(2, 20, 23) AND C22 < BBBOT(2, 20, 23) AND (BBBOT(2, 20, 23) >= BBBOT(2, 20, 24) OR C23 >= BBBOT(2, 20, 24)), BBBOT(6, 20, 23), IIF(BBBOT(2, 20, 23) < BBBOT(2, 20, 24) AND C23 < BBBOT(2, 20, 24) AND (BBBOT(2, 20, 24) >= BBBOT(2, 20, 25) OR C24 >= BBBOT(2, 20, 25)), BBBOT(6, 20, 24), IIF(BBBOT(2, 20, 24) < BBBOT(2, 20, 25) AND C24 < BBBOT(2, 20, 25) AND (BBBOT(2, 20, 25) >= BBBOT(2, 20, 26) OR C25 >= BBBOT(2, 20, 26)), BBBOT(6, 20, 25), IIF(BBBOT(2, 20, 25) < BBBOT(2, 20, 26) AND C25 < BBBOT(2, 20, 26) AND (BBBOT(2, 20, 26) >= BBBOT(2, 20, 27) OR C26 >= BBBOT(2, 20, 27)), BBBOT(6, 20, 26), IIF(BBBOT(2, 20, 26) < BBBOT(2, 20, 27) AND C26 < BBBOT(2, 20, 27) AND (BBBOT(2, 20, 27) >= BBBOT(2, 20, 28) OR C27 >= BBBOT(2, 20, 28)), BBBOT(6, 20, 27), IIF(BBBOT(2, 20, 27) < BBBOT(2, 20, 28) AND C27 < BBBOT(2, 20, 28) AND (BBBOT(2, 20, 28) >= BBBOT(2, 20, 29) OR C28 >= BBBOT(2, 20, 29)), BBBOT(6, 20, 28), IIF(BBBOT(2, 20, 28) < BBBOT(2, 20, 29) AND C28 < BBBOT(2, 20, 29) AND (BBBOT(2, 20, 29) >= BBBOT(2, 20, 30) OR C29 >= BBBOT(2, 20, 30)), BBBOT(6, 20, 29), IIF(BBBOT(2, 20, 29) < BBBOT(2, 20, 30) AND C29 < BBBOT(2, 20, 30) AND (BBBOT(2, 20, 30) >= BBBOT(2, 20, 31) OR C30 >= BBBOT(2, 20, 31)), BBBOT(6, 20, 30), 1 / 0))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
IIF(BBTOP(2, 20) > BBTOP(2, 20, 1) AND C > BBTOP(2, 20, 1) AND (BBTOP(2, 20, 1) <= BBTOP(2, 20, 2) OR C1 <= BBTOP(2, 20, 2)), BBTOP(6, 20, 1), IIF(BBTOP(2, 20, 1) > BBTOP(2, 20, 2) AND C1 > BBTOP(2, 20, 2) AND (BBTOP(2, 20, 2) <= BBTOP(2, 20, 3) OR C2 <= BBTOP(2, 20, 3)), BBTOP(6, 20, 2), IIF(BBTOP(2, 20, 2) > BBTOP(2, 20, 3) AND C2 > BBTOP(2, 20, 3) AND (BBTOP(2, 20, 3) <= BBTOP(2, 20, 4) OR C3 <= BBTOP(2, 20, 4)), BBTOP(6, 20, 3), IIF(BBTOP(2, 20, 3) > BBTOP(2, 20, 4) AND C3 > BBTOP(2, 20, 4) AND (BBTOP(2, 20, 4) <= BBTOP(2, 20, 5) OR C4 <= BBTOP(2, 20, 5)), BBTOP(6, 20, 4), IIF(BBTOP(2, 20, 4) > BBTOP(2, 20, 5) AND C4 > BBTOP(2, 20, 5) AND (BBTOP(2, 20, 5) <= BBTOP(2, 20, 6) OR C5 <= BBTOP(2, 20, 6)), BBTOP(6, 20, 5), IIF(BBTOP(2, 20, 5) > BBTOP(2, 20, 6) AND C5 > BBTOP(2, 20, 6) AND (BBTOP(2, 20, 6) <= BBTOP(2, 20, 7) OR C6 <= BBTOP(2, 20, 7)), BBTOP(6, 20, 6), IIF(BBTOP(2, 20, 6) > BBTOP(2, 20, 7) AND C6 > BBTOP(2, 20, 7) AND (BBTOP(2, 20, 7) <= BBTOP(2, 20, 8) OR C7 <= BBTOP(2, 20, 8)), BBTOP(6, 20, 7), IIF(BBTOP(2, 20, 7) > BBTOP(2, 20, 8) AND C7 > BBTOP(2, 20, 8) AND (BBTOP(2, 20, 8) <= BBTOP(2, 20, 9) OR C8 <= BBTOP(2, 20, 9)), BBTOP(6, 20, 8), IIF(BBTOP(2, 20, 8) > BBTOP(2, 20, 9) AND C8 > BBTOP(2, 20, 9) AND (BBTOP(2, 20, 9) <= BBTOP(2, 20, 10) OR C9 <= BBTOP(2, 20, 10)), BBTOP(6, 20, 9), IIF(BBTOP(2, 20, 9) > BBTOP(2, 20, 10) AND C9 > BBTOP(2, 20, 10) AND (BBTOP(2, 20, 10) <= BBTOP(2, 20, 11) OR C10 <= BBTOP(2, 20, 11)), BBTOP(6, 20, 10), IIF(BBTOP(2, 20, 10) > BBTOP(2, 20, 11) AND C10 > BBTOP(2, 20, 11) AND (BBTOP(2, 20, 11) <= BBTOP(2, 20, 12) OR C11 <= BBTOP(2, 20, 12)), BBTOP(6, 20, 11), IIF(BBTOP(2, 20, 11) > BBTOP(2, 20, 12) AND C11 > BBTOP(2, 20, 12) AND (BBTOP(2, 20, 12) <= BBTOP(2, 20, 13) OR C12 <= BBTOP(2, 20, 13)), BBTOP(6, 20, 12), IIF(BBTOP(2, 20, 12) > BBTOP(2, 20, 13) AND C12 > BBTOP(2, 20, 13) AND (BBTOP(2, 20, 13) <= BBTOP(2, 20, 14) OR C13 <= BBTOP(2, 20, 14)), BBTOP(6, 20, 13), IIF(BBTOP(2, 20, 13) > BBTOP(2, 20, 14) AND C13 > BBTOP(2, 20, 14) AND (BBTOP(2, 20, 14) <= BBTOP(2, 20, 15) OR C14 <= BBTOP(2, 20, 15)), BBTOP(6, 20, 14), IIF(BBTOP(2, 20, 14) > BBTOP(2, 20, 15) AND C14 > BBTOP(2, 20, 15) AND (BBTOP(2, 20, 15) <= BBTOP(2, 20, 16) OR C15 <= BBTOP(2, 20, 16)), BBTOP(6, 20, 15), IIF(BBTOP(2, 20, 15) > BBTOP(2, 20, 16) AND C15 > BBTOP(2, 20, 16) AND (BBTOP(2, 20, 16) <= BBTOP(2, 20, 17) OR C16 <= BBTOP(2, 20, 17)), BBTOP(6, 20, 16), IIF(BBTOP(2, 20, 16) > BBTOP(2, 20, 17) AND C16 > BBTOP(2, 20, 17) AND (BBTOP(2, 20, 17) <= BBTOP(2, 20, 18) OR C17 <= BBTOP(2, 20, 18)), BBTOP(6, 20, 17), IIF(BBTOP(2, 20, 17) > BBTOP(2, 20, 18) AND C17 > BBTOP(2, 20, 18) AND (BBTOP(2, 20, 18) <= BBTOP(2, 20, 19) OR C18 <= BBTOP(2, 20, 19)), BBTOP(6, 20, 18), IIF(BBTOP(2, 20, 18) > BBTOP(2, 20, 19) AND C18 > BBTOP(2, 20, 19) AND (BBTOP(2, 20, 19) <= BBTOP(2, 20, 20) OR C19 <= BBTOP(2, 20, 20)), BBTOP(6, 20, 19), IIF(BBTOP(2, 20, 19) > BBTOP(2, 20, 20) AND C19 > BBTOP(2, 20, 20) AND (BBTOP(2, 20, 20) <= BBTOP(2, 20, 21) OR C20 <= BBTOP(2, 20, 21)), BBTOP(6, 20, 20), IIF(BBTOP(2, 20, 20) > BBTOP(2, 20, 21) AND C20 > BBTOP(2, 20, 21) AND (BBTOP(2, 20, 21) <= BBTOP(2, 20, 22) OR C21 <= BBTOP(2, 20, 22)), BBTOP(6, 20, 21), IIF(BBTOP(2, 20, 21) > BBTOP(2, 20, 22) AND C21 > BBTOP(2, 20, 22) AND (BBTOP(2, 20, 22) <= BBTOP(2, 20, 23) OR C22 <= BBTOP(2, 20, 23)), BBTOP(6, 20, 22), IIF(BBTOP(2, 20, 22) > BBTOP(2, 20, 23) AND C22 > BBTOP(2, 20, 23) AND (BBTOP(2, 20, 23) <= BBTOP(2, 20, 24) OR C23 <= BBTOP(2, 20, 24)), BBTOP(6, 20, 23), IIF(BBTOP(2, 20, 23) > BBTOP(2, 20, 24) AND C23 > BBTOP(2, 20, 24) AND (BBTOP(2, 20, 24) <= BBTOP(2, 20, 25) OR C24 <= BBTOP(2, 20, 25)), BBTOP(6, 20, 24), IIF(BBTOP(2, 20, 24) > BBTOP(2, 20, 25) AND C24 > BBTOP(2, 20, 25) AND (BBTOP(2, 20, 25) <= BBTOP(2, 20, 26) OR C25 <= BBTOP(2, 20, 26)), BBTOP(6, 20, 25), IIF(BBTOP(2, 20, 25) > BBTOP(2, 20, 26) AND C25 > BBTOP(2, 20, 26) AND (BBTOP(2, 20, 26) <= BBTOP(2, 20, 27) OR C26 <= BBTOP(2, 20, 27)), BBTOP(6, 20, 26), IIF(BBTOP(2, 20, 26) > BBTOP(2, 20, 27) AND C26 > BBTOP(2, 20, 27) AND (BBTOP(2, 20, 27) <= BBTOP(2, 20, 28) OR C27 <= BBTOP(2, 20, 28)), BBTOP(6, 20, 27), IIF(BBTOP(2, 20, 27) > BBTOP(2, 20, 28) AND C27 > BBTOP(2, 20, 28) AND (BBTOP(2, 20, 28) <= BBTOP(2, 20, 29) OR C28 <= BBTOP(2, 20, 29)), BBTOP(6, 20, 28), IIF(BBTOP(2, 20, 28) > BBTOP(2, 20, 29) AND C28 > BBTOP(2, 20, 29) AND (BBTOP(2, 20, 29) <= BBTOP(2, 20, 30) OR C29 <= BBTOP(2, 20, 30)), BBTOP(6, 20, 29), IIF(BBTOP(2, 20, 29) > BBTOP(2, 20, 30) AND C29 > BBTOP(2, 20, 30) AND (BBTOP(2, 20, 30) <= BBTOP(2, 20, 31) OR C30 <= BBTOP(2, 20, 31)), BBTOP(6, 20, 30), 1 / 0))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|