TC2000.com• Download software • Tutorial videos • Subscription & data-feed pricing • Class schedule
TC2000Brokerage.com• New account application • Trading resources • Margin rates • Stock & option commissions
Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » PCF Formula
Bruce
This involve pcf over my head
When this goes from False To TRUE
(BBBOT(2, 20, 0) < BBBOT(2, 20, 1) AND C < BBBOT(2, 20, 1))
I wish to Plot This Value
((BBBOT(2,20,1)) - ( (BBTOP(2, 20, 1)) - (BBBOT(2, 20, 1) )))
as a horizontal line
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))))))))))))))))))))))))))))))
i will try this, thanks
yes i had the short formula working but not the LONG on very nice
WORKS VERY NICE THANKS - i could use the reverse as well
here is the reverse setup
When this goes from False to TRUE
(BBTOP(2, 20, 0) > BBTOP(2, 20, 1) AND C > BBTOP(2, 20, 1))
I wish to PLot this Value
((BBTOP(2,20,1)) + ( (BBTOP(2, 20, 1)) - (BBBOT(2, 20, 1) )))
as a horizontal Line
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))))))))))))))))))))))))))))))
just to verify these stay on chart 30 bars, then just quit plotting?
And thanks again
Yes, the lookback on these formulas is 30 bars, after which they will just stop plotting. You have to have an additional nested IIF() function for each additional bar.