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

PCF Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Aces4Me
Posted : Sunday, July 16, 2017 5:09:55 PM
Registered User
Joined: 4/30/2015
Posts: 197

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

Bruce_L
Posted : Monday, July 17, 2017 11:01:12 AM


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
Aces4Me
Posted : Monday, July 17, 2017 1:12:11 PM
Registered User
Joined: 4/30/2015
Posts: 197

i will try this, thanks

Aces4Me
Posted : Monday, July 17, 2017 2:15:02 PM
Registered User
Joined: 4/30/2015
Posts: 197

 

 

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

 

Bruce_L
Posted : Monday, July 17, 2017 2:34:48 PM


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
Aces4Me
Posted : Monday, July 17, 2017 6:55:35 PM
Registered User
Joined: 4/30/2015
Posts: 197

just to verify these stay on chart 30 bars, then just quit plotting?

 

And thanks again

Bruce_L
Posted : Tuesday, July 18, 2017 8:48:42 AM


Worden Trainer

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

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.



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