Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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?
|
|
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
|
|
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)
|
|
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
|
|
Gold Customer
Joined: 3/20/2006 Posts: 161
|
Yes I want PCF for Aroon20+ and Aroon20- to cross for buy signal Thanks
|
|
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
|
|
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
|
|
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
|
|
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!
|
|
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
|
|
Guest-1 |