Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Aroon PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jpag1
Posted : Tuesday, July 3, 2007 2:32:55 PM
Gold Customer Gold Customer

Joined: 3/20/2006
Posts: 161
Can a PCF be written for crossing of Aroon20 for a buy signal and a sell signal?
Bruce_L
Posted : Tuesday, July 3, 2007 3:22:04 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You may wish to try one or more of the following:

Aroon(+) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2

Aroon(-) 20-Period:

100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2

Aroon Oscillator 20-Period:

((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20) - (H1 = MAXH21) * (H1 > H) - 2 * (H2 = MAXH21) * (H2 > MAXH2) - 3 * (H3 = MAXH21) * (H3 > MAXH3) - 4 * (H4 = MAXH21) * (H4 > MAXH4) - 5 * (H5 = MAXH21) * (H5 > MAXH5) - 6 * (H6 = MAXH21) * (H6 > MAXH6) - 7 * (H7 = MAXH21) * (H7 > MAXH7) - 8 * (H8 = MAXH21) * (H8 > MAXH8) - 9 * (H9 = MAXH21) * (H9 > MAXH9) - 10 * (H10 = MAXH21) * (H10 > MAXH10) - 11 * (H11 = MAXH21) * (H11 > MAXH11) - 12 * (H12 = MAXH21) * (H12 > MAXH12) - 13 * (H13 = MAXH21) * (H13 > MAXH13) - 14 * (H14 = MAXH21) * (H14 > MAXH14) - 15 * (H15 = MAXH21) * (H15 > MAXH15) - 16 * (H16 = MAXH21) * (H16 > MAXH16) - 17 * (H17 = MAXH21) * (H17 > MAXH17) - 18 * (H18 = MAXH21) * (H18 > MAXH18) - 19 * (H19 = MAXH21) * (H19 > MAXH19) - 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2

Aroon(+) xUp Aroon(-) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2 > 100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2 AND 100 - ((H2 = MAXH21.1) * (H2 > H1) + 2 * (H3 = MAXH21.1) * (H3 > MAXH2.1) + 3 * (H4 = MAXH21.1) * (H4 > MAXH3.1) + 4 * (H5 = MAXH21.1) * (H5 > MAXH4.1) + 5 * (H6 = MAXH21.1) * (H6 > MAXH5.1) + 6 * (H7 = MAXH21.1) * (H7 > MAXH6.1) + 7 * (H8 = MAXH21.1) * (H8 > MAXH7.1) + 8 * (H9 = MAXH21.1) * (H9 > MAXH8.1) + 9 * (H10 = MAXH21.1) * (H10 > MAXH9.1) + 10 * (H11 = MAXH21.1) * (H11 > MAXH10.1) + 11 * (H12 = MAXH21.1) * (H12 > MAXH11.1) + 12 * (H13 = MAXH21.1) * (H13 > MAXH12.1) + 13 * (H14 = MAXH21.1) * (H14 > MAXH13.1) + 14 * (H15 = MAXH21.1) * (H15 > MAXH14.1) + 15 * (H16 = MAXH21.1) * (H16 > MAXH15.1) + 16 * (H17 = MAXH21.1) * (H17 > MAXH16.1) + 17 * (H18 = MAXH21.1) * (H18 > MAXH17.1) + 18 * (H19 = MAXH21.1) * (H19 > MAXH18.1) + 19 * (H20 = MAXH21.1) * (H20 > MAXH19.1) + 20 * (H21 = MAXH21.1) * (H21 > MAXH20.1)) / .2 <= 100 - ((L2 = MINL21.1) * (L2 < L1) + 2 * (L3 = MINL21.1) * (L3 < MINL2.1) + 3 * (L4 = MINL21.1) * (L4 < MINL3.1) + 4 * (L5 = MINL21.1) * (L5 < MINL4.1) + 5 * (L6 = MINL21.1) * (L6 < MINL5.1) + 6 * (L7 = MINL21.1) * (L7 < MINL6.1) + 7 * (L8 = MINL21.1) * (L8 < MINL7.1) + 8 * (L9 = MINL21.1) * (L9 < MINL8.1) + 9 * (L10 = MINL21.1) * (L10 < MINL9.1) + 10 * (L11 = MINL21.1) * (L11 < MINL10.1) + 11 * (L12 = MINL21.1) * (L12 < MINL11.1) + 12 * (L13 = MINL21.1) * (L13 < MINL12.1) + 13 * (L14 = MINL21.1) * (L14 < MINL13.1) + 14 * (L15 = MINL21.1) * (L15 < MINL14.1) + 15 * (L16 = MINL21.1) * (L16 < MINL15.1) + 16 * (L17 = MINL21.1) * (L17 < MINL16.1) + 17 * (L18 = MINL21.1) * (L18 < MINL17.1) + 18 * (L19 = MINL21.1) * (L19 < MINL18.1) + 19 * (L20 = MINL21.1) * (L20 < MINL19.1) + 20 * (L21 = MINL21.1) * (L21 < MINL20.1)) / .2

Aroon(+) xDown Aroon(-) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2 < 100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2 AND 100 - ((H2 = MAXH21.1) * (H2 > H1) + 2 * (H3 = MAXH21.1) * (H3 > MAXH2.1) + 3 * (H4 = MAXH21.1) * (H4 > MAXH3.1) + 4 * (H5 = MAXH21.1) * (H5 > MAXH4.1) + 5 * (H6 = MAXH21.1) * (H6 > MAXH5.1) + 6 * (H7 = MAXH21.1) * (H7 > MAXH6.1) + 7 * (H8 = MAXH21.1) * (H8 > MAXH7.1) + 8 * (H9 = MAXH21.1) * (H9 > MAXH8.1) + 9 * (H10 = MAXH21.1) * (H10 > MAXH9.1) + 10 * (H11 = MAXH21.1) * (H11 > MAXH10.1) + 11 * (H12 = MAXH21.1) * (H12 > MAXH11.1) + 12 * (H13 = MAXH21.1) * (H13 > MAXH12.1) + 13 * (H14 = MAXH21.1) * (H14 > MAXH13.1) + 14 * (H15 = MAXH21.1) * (H15 > MAXH14.1) + 15 * (H16 = MAXH21.1) * (H16 > MAXH15.1) + 16 * (H17 = MAXH21.1) * (H17 > MAXH16.1) + 17 * (H18 = MAXH21.1) * (H18 > MAXH17.1) + 18 * (H19 = MAXH21.1) * (H19 > MAXH18.1) + 19 * (H20 = MAXH21.1) * (H20 > MAXH19.1) + 20 * (H21 = MAXH21.1) * (H21 > MAXH20.1)) / .2 >= 100 - ((L2 = MINL21.1) * (L2 < L1) + 2 * (L3 = MINL21.1) * (L3 < MINL2.1) + 3 * (L4 = MINL21.1) * (L4 < MINL3.1) + 4 * (L5 = MINL21.1) * (L5 < MINL4.1) + 5 * (L6 = MINL21.1) * (L6 < MINL5.1) + 6 * (L7 = MINL21.1) * (L7 < MINL6.1) + 7 * (L8 = MINL21.1) * (L8 < MINL7.1) + 8 * (L9 = MINL21.1) * (L9 < MINL8.1) + 9 * (L10 = MINL21.1) * (L10 < MINL9.1) + 10 * (L11 = MINL21.1) * (L11 < MINL10.1) + 11 * (L12 = MINL21.1) * (L12 < MINL11.1) + 12 * (L13 = MINL21.1) * (L13 < MINL12.1) + 13 * (L14 = MINL21.1) * (L14 < MINL13.1) + 14 * (L15 = MINL21.1) * (L15 < MINL14.1) + 15 * (L16 = MINL21.1) * (L16 < MINL15.1) + 16 * (L17 = MINL21.1) * (L17 < MINL16.1) + 17 * (L18 = MINL21.1) * (L18 < MINL17.1) + 18 * (L19 = MINL21.1) * (L19 < MINL18.1) + 19 * (L20 = MINL21.1) * (L20 < MINL19.1) + 20 * (L21 = MINL21.1) * (L21 < MINL20.1)) / .2

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jpag1
Posted : Tuesday, July 3, 2007 5:11:49 PM
Gold Customer Gold Customer

Joined: 3/20/2006
Posts: 161
I have written many PCF's but my brain is not working on this one. I have your formulas but don't know how to put them in right context to show Aroon NEG below Aroon POS then next day Aroon POS above Aroon NEG, giving a buy signal(true)
Bruce_L
Posted : Tuesday, July 3, 2007 5:19:43 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I suspect you want the Aroon(+) and Aroon(-) to cross for your buy signal. I can't say if you want the Aroon(+) xUp Aroon(-) 20-Period formula or the Aroon(+) xDown Aroon(-) 20-Period formula based on your Tuesday, July 03, 2007 5:11:49 PM ET post however because the description seems to have the Aroon(+) above the Aroon(-) two days in a row.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jpag1
Posted : Monday, July 9, 2007 10:27:12 AM
Gold Customer Gold Customer

Joined: 3/20/2006
Posts: 161
Yes I want PCF for Aroon20+ and Aroon20- to cross for buy signal Thanks
Bruce_L
Posted : Monday, July 9, 2007 11:05:16 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Then you want the Aroon(+) xUp Aroon(-) 20-Period formula.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jpag1
Posted : Monday, July 9, 2007 1:52:07 PM
Gold Customer Gold Customer

Joined: 3/20/2006
Posts: 161
Sorry I confused. Usually when you want some formula to cross like a close crossing a moving average you have C1 < AVGC50.1 AND C > AVGC50. Where one day is below and the next day it is above. How do you show aroon20 + below yesterday aroon - and today aroon + above aroon -. Thanks
Bruce_L
Posted : Monday, July 9, 2007 1:57:45 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
jpag1,
Aroon(+) xUp Aroon(-) 20-Period uses exactly the technique you describe:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2
>
100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2
AND
100 - ((H2 = MAXH21.1) * (H2 > H1) + 2 * (H3 = MAXH21.1) * (H3 > MAXH2.1) + 3 * (H4 = MAXH21.1) * (H4 > MAXH3.1) + 4 * (H5 = MAXH21.1) * (H5 > MAXH4.1) + 5 * (H6 = MAXH21.1) * (H6 > MAXH5.1) + 6 * (H7 = MAXH21.1) * (H7 > MAXH6.1) + 7 * (H8 = MAXH21.1) * (H8 > MAXH7.1) + 8 * (H9 = MAXH21.1) * (H9 > MAXH8.1) + 9 * (H10 = MAXH21.1) * (H10 > MAXH9.1) + 10 * (H11 = MAXH21.1) * (H11 > MAXH10.1) + 11 * (H12 = MAXH21.1) * (H12 > MAXH11.1) + 12 * (H13 = MAXH21.1) * (H13 > MAXH12.1) + 13 * (H14 = MAXH21.1) * (H14 > MAXH13.1) + 14 * (H15 = MAXH21.1) * (H15 > MAXH14.1) + 15 * (H16 = MAXH21.1) * (H16 > MAXH15.1) + 16 * (H17 = MAXH21.1) * (H17 > MAXH16.1) + 17 * (H18 = MAXH21.1) * (H18 > MAXH17.1) + 18 * (H19 = MAXH21.1) * (H19 > MAXH18.1) + 19 * (H20 = MAXH21.1) * (H20 > MAXH19.1) + 20 * (H21 = MAXH21.1) * (H21 > MAXH20.1)) / .2
<=
100 - ((L2 = MINL21.1) * (L2 < L1) + 2 * (L3 = MINL21.1) * (L3 < MINL2.1) + 3 * (L4 = MINL21.1) * (L4 < MINL3.1) + 4 * (L5 = MINL21.1) * (L5 < MINL4.1) + 5 * (L6 = MINL21.1) * (L6 < MINL5.1) + 6 * (L7 = MINL21.1) * (L7 < MINL6.1) + 7 * (L8 = MINL21.1) * (L8 < MINL7.1) + 8 * (L9 = MINL21.1) * (L9 < MINL8.1) + 9 * (L10 = MINL21.1) * (L10 < MINL9.1) + 10 * (L11 = MINL21.1) * (L11 < MINL10.1) + 11 * (L12 = MINL21.1) * (L12 < MINL11.1) + 12 * (L13 = MINL21.1) * (L13 < MINL12.1) + 13 * (L14 = MINL21.1) * (L14 < MINL13.1) + 14 * (L15 = MINL21.1) * (L15 < MINL14.1) + 15 * (L16 = MINL21.1) * (L16 < MINL15.1) + 16 * (L17 = MINL21.1) * (L17 < MINL16.1) + 17 * (L18 = MINL21.1) * (L18 < MINL17.1) + 18 * (L19 = MINL21.1) * (L19 < MINL18.1) + 19 * (L20 = MINL21.1) * (L20 < MINL19.1) + 20 * (L21 = MINL21.1) * (L21 < MINL20.1)) / .2

I've just added some line feeds to show you were the <, AND, & >= are located.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lorca
Posted : Wednesday, October 5, 2016 6:15:40 PM
Platinum Customer Platinum Customer

Joined: 7/19/2008
Posts: 2

Dear Bruce,

I cannot say thank you enough for providing the Aroon formula, frankly it is priceless.

One question I have for you, I tried inserting it into TC2000 and the "." Before the 2 gives a formula error message.

Can you please specify if it's all divided by 0.2 or just 2?

Best,

fLorcA

 

QUOTE (Bruce_L)
You may wish to try one or more of the following:

Aroon(+) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2

Aroon(-) 20-Period:

100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2

Aroon Oscillator 20-Period:

((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20) - (H1 = MAXH21) * (H1 > H) - 2 * (H2 = MAXH21) * (H2 > MAXH2) - 3 * (H3 = MAXH21) * (H3 > MAXH3) - 4 * (H4 = MAXH21) * (H4 > MAXH4) - 5 * (H5 = MAXH21) * (H5 > MAXH5) - 6 * (H6 = MAXH21) * (H6 > MAXH6) - 7 * (H7 = MAXH21) * (H7 > MAXH7) - 8 * (H8 = MAXH21) * (H8 > MAXH8) - 9 * (H9 = MAXH21) * (H9 > MAXH9) - 10 * (H10 = MAXH21) * (H10 > MAXH10) - 11 * (H11 = MAXH21) * (H11 > MAXH11) - 12 * (H12 = MAXH21) * (H12 > MAXH12) - 13 * (H13 = MAXH21) * (H13 > MAXH13) - 14 * (H14 = MAXH21) * (H14 > MAXH14) - 15 * (H15 = MAXH21) * (H15 > MAXH15) - 16 * (H16 = MAXH21) * (H16 > MAXH16) - 17 * (H17 = MAXH21) * (H17 > MAXH17) - 18 * (H18 = MAXH21) * (H18 > MAXH18) - 19 * (H19 = MAXH21) * (H19 > MAXH19) - 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2

Aroon(+) xUp Aroon(-) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2 > 100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2 AND 100 - ((H2 = MAXH21.1) * (H2 > H1) + 2 * (H3 = MAXH21.1) * (H3 > MAXH2.1) + 3 * (H4 = MAXH21.1) * (H4 > MAXH3.1) + 4 * (H5 = MAXH21.1) * (H5 > MAXH4.1) + 5 * (H6 = MAXH21.1) * (H6 > MAXH5.1) + 6 * (H7 = MAXH21.1) * (H7 > MAXH6.1) + 7 * (H8 = MAXH21.1) * (H8 > MAXH7.1) + 8 * (H9 = MAXH21.1) * (H9 > MAXH8.1) + 9 * (H10 = MAXH21.1) * (H10 > MAXH9.1) + 10 * (H11 = MAXH21.1) * (H11 > MAXH10.1) + 11 * (H12 = MAXH21.1) * (H12 > MAXH11.1) + 12 * (H13 = MAXH21.1) * (H13 > MAXH12.1) + 13 * (H14 = MAXH21.1) * (H14 > MAXH13.1) + 14 * (H15 = MAXH21.1) * (H15 > MAXH14.1) + 15 * (H16 = MAXH21.1) * (H16 > MAXH15.1) + 16 * (H17 = MAXH21.1) * (H17 > MAXH16.1) + 17 * (H18 = MAXH21.1) * (H18 > MAXH17.1) + 18 * (H19 = MAXH21.1) * (H19 > MAXH18.1) + 19 * (H20 = MAXH21.1) * (H20 > MAXH19.1) + 20 * (H21 = MAXH21.1) * (H21 > MAXH20.1)) / .2 <= 100 - ((L2 = MINL21.1) * (L2 < L1) + 2 * (L3 = MINL21.1) * (L3 < MINL2.1) + 3 * (L4 = MINL21.1) * (L4 < MINL3.1) + 4 * (L5 = MINL21.1) * (L5 < MINL4.1) + 5 * (L6 = MINL21.1) * (L6 < MINL5.1) + 6 * (L7 = MINL21.1) * (L7 < MINL6.1) + 7 * (L8 = MINL21.1) * (L8 < MINL7.1) + 8 * (L9 = MINL21.1) * (L9 < MINL8.1) + 9 * (L10 = MINL21.1) * (L10 < MINL9.1) + 10 * (L11 = MINL21.1) * (L11 < MINL10.1) + 11 * (L12 = MINL21.1) * (L12 < MINL11.1) + 12 * (L13 = MINL21.1) * (L13 < MINL12.1) + 13 * (L14 = MINL21.1) * (L14 < MINL13.1) + 14 * (L15 = MINL21.1) * (L15 < MINL14.1) + 15 * (L16 = MINL21.1) * (L16 < MINL15.1) + 16 * (L17 = MINL21.1) * (L17 < MINL16.1) + 17 * (L18 = MINL21.1) * (L18 < MINL17.1) + 18 * (L19 = MINL21.1) * (L19 < MINL18.1) + 19 * (L20 = MINL21.1) * (L20 < MINL19.1) + 20 * (L21 = MINL21.1) * (L21 < MINL20.1)) / .2

Aroon(+) xDown Aroon(-) 20-Period:

100 - ((H1 = MAXH21) * (H1 > H) + 2 * (H2 = MAXH21) * (H2 > MAXH2) + 3 * (H3 = MAXH21) * (H3 > MAXH3) + 4 * (H4 = MAXH21) * (H4 > MAXH4) + 5 * (H5 = MAXH21) * (H5 > MAXH5) + 6 * (H6 = MAXH21) * (H6 > MAXH6) + 7 * (H7 = MAXH21) * (H7 > MAXH7) + 8 * (H8 = MAXH21) * (H8 > MAXH8) + 9 * (H9 = MAXH21) * (H9 > MAXH9) + 10 * (H10 = MAXH21) * (H10 > MAXH10) + 11 * (H11 = MAXH21) * (H11 > MAXH11) + 12 * (H12 = MAXH21) * (H12 > MAXH12) + 13 * (H13 = MAXH21) * (H13 > MAXH13) + 14 * (H14 = MAXH21) * (H14 > MAXH14) + 15 * (H15 = MAXH21) * (H15 > MAXH15) + 16 * (H16 = MAXH21) * (H16 > MAXH16) + 17 * (H17 = MAXH21) * (H17 > MAXH17) + 18 * (H18 = MAXH21) * (H18 > MAXH18) + 19 * (H19 = MAXH21) * (H19 > MAXH19) + 20 * (H20 = MAXH21) * (H20 > MAXH20)) / .2 < 100 - ((L1 = MINL21) * (L1 < L) + 2 * (L2 = MINL21) * (L2 < MINL2) + 3 * (L3 = MINL21) * (L3 < MINL3) + 4 * (L4 = MINL21) * (L4 < MINL4) + 5 * (L5 = MINL21) * (L5 < MINL5) + 6 * (L6 = MINL21) * (L6 < MINL6) + 7 * (L7 = MINL21) * (L7 < MINL7) + 8 * (L8 = MINL21) * (L8 < MINL8) + 9 * (L9 = MINL21) * (L9 < MINL9) + 10 * (L10 = MINL21) * (L10 < MINL10) + 11 * (L11 = MINL21) * (L11 < MINL11) + 12 * (L12 = MINL21) * (L12 < MINL12) + 13 * (L13 = MINL21) * (L13 < MINL13) + 14 * (L14 = MINL21) * (L14 < MINL14) + 15 * (L15 = MINL21) * (L15 < MINL15) + 16 * (L16 = MINL21) * (L16 < MINL16) + 17 * (L17 = MINL21) * (L17 < MINL17) + 18 * (L18 = MINL21) * (L18 < MINL18) + 19 * (L19 = MINL21) * (L19 < MINL19) + 20 * (L20 = MINL21) * (L20 < MINL20)) / .2 AND 100 - ((H2 = MAXH21.1) * (H2 > H1) + 2 * (H3 = MAXH21.1) * (H3 > MAXH2.1) + 3 * (H4 = MAXH21.1) * (H4 > MAXH3.1) + 4 * (H5 = MAXH21.1) * (H5 > MAXH4.1) + 5 * (H6 = MAXH21.1) * (H6 > MAXH5.1) + 6 * (H7 = MAXH21.1) * (H7 > MAXH6.1) + 7 * (H8 = MAXH21.1) * (H8 > MAXH7.1) + 8 * (H9 = MAXH21.1) * (H9 > MAXH8.1) + 9 * (H10 = MAXH21.1) * (H10 > MAXH9.1) + 10 * (H11 = MAXH21.1) * (H11 > MAXH10.1) + 11 * (H12 = MAXH21.1) * (H12 > MAXH11.1) + 12 * (H13 = MAXH21.1) * (H13 > MAXH12.1) + 13 * (H14 = MAXH21.1) * (H14 > MAXH13.1) + 14 * (H15 = MAXH21.1) * (H15 > MAXH14.1) + 15 * (H16 = MAXH21.1) * (H16 > MAXH15.1) + 16 * (H17 = MAXH21.1) * (H17 > MAXH16.1) + 17 * (H18 = MAXH21.1) * (H18 > MAXH17.1) + 18 * (H19 = MAXH21.1) * (H19 > MAXH18.1) + 19 * (H20 = MAXH21.1) * (H20 > MAXH19.1) + 20 * (H21 = MAXH21.1) * (H21 > MAXH20.1)) / .2 >= 100 - ((L2 = MINL21.1) * (L2 < L1) + 2 * (L3 = MINL21.1) * (L3 < MINL2.1) + 3 * (L4 = MINL21.1) * (L4 < MINL3.1) + 4 * (L5 = MINL21.1) * (L5 < MINL4.1) + 5 * (L6 = MINL21.1) * (L6 < MINL5.1) + 6 * (L7 = MINL21.1) * (L7 < MINL6.1) + 7 * (L8 = MINL21.1) * (L8 < MINL7.1) + 8 * (L9 = MINL21.1) * (L9 < MINL8.1) + 9 * (L10 = MINL21.1) * (L10 < MINL9.1) + 10 * (L11 = MINL21.1) * (L11 < MINL10.1) + 11 * (L12 = MINL21.1) * (L12 < MINL11.1) + 12 * (L13 = MINL21.1) * (L13 < MINL12.1) + 13 * (L14 = MINL21.1) * (L14 < MINL13.1) + 14 * (L15 = MINL21.1) * (L15 < MINL14.1) + 15 * (L16 = MINL21.1) * (L16 < MINL15.1) + 16 * (L17 = MINL21.1) * (L17 < MINL16.1) + 17 * (L18 = MINL21.1) * (L18 < MINL17.1) + 18 * (L19 = MINL21.1) * (L19 < MINL18.1) + 19 * (L20 = MINL21.1) * (L20 < MINL19.1) + 20 * (L21 = MINL21.1) * (L21 < MINL20.1)) / .2

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

Bruce_L
Posted : Thursday, October 6, 2016 9:23:34 AM


Worden Trainer

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

It is a .2 and not just plain 2.

That said, if it is causing an issue for you, please try changing the / .2 into a * 5 and see if it corrects the issue.



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