| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 12/18/2004
Posts: 50
|
Is there a way to create a PCF that will indicate an Aroon(13) crossing up through an Aroon(34)?
I'd also like to do the reverse, e.g., Aroon(13) crossing down through an Aroon(34).
Too bad we can't just do Aroon(13) > Aroon(34) AND Aroon(13.1) < Aroon (34.1) and vice versa.
I tried the following (13 crossing 34 up) in both TC2007 and TC2000. But the results do not seem to match a TC2000 V12 plot of Aroon(13) and Aroon(34) in the same window. Maybe there are mistakes in my formula.
(( (L1=MINL13)*(L1<L) +2*(L2=MINL13)*(L2<MINL2) +3*(L3=MINL13)*(L3<MINL3) +4*(L4=MINL13)*(L4<MINL4) +5*(L5=MINL13)*(L5<MINL5) +6*(L6=MINL13)*(L6<MINL6) +7*(L7=MINL13)*(L7<MINL7) +8*(L8=MINL13)*(L8<MINL8) +9*(L9=MINL13)*(L9<MINL9) +10*(L10=MINL13)*(L10<MINL10) +11*(L11=MINL13)*(L11<MINL11) +12*(L12=MINL13)*(L12<MINL12) -(H1=MAXH13)*(H1>H) -2*(H2=MAXH13)*(H2>MAXH2) -3*(H3=MAXH13)*(H3>MAXH3) -4*(H4=MAXH13)*(H4>MAXH4) -5*(H5=MAXH13)*(H5>MAXH5) -6*(H6=MAXH13)*(H6>MAXH6) -7*(H7=MAXH13)*(H7>MAXH7) -8*(H8=MAXH13)*(H8>MAXH8) -9*(H9=MAXH13)*(H9>MAXH9) -10*(H10=MAXH13)*(H10>MAXH10) -11*(H11=MAXH13)*(H11>MAXH11) -12*(H12=MAXH13)*(H12>MAXH12))/0.12)
>
(( (L1=MINL34)*(L1<L) +2*(L2=MINL34)*(L2<MINL2) +3*(L3=MINL34)*(L3<MINL3) +4*(L4=MINL34)*(L4<MINL4) +5*(L5=MINL34)*(L5<MINL5) +6*(L6=MINL34)*(L6<MINL6) +7*(L7=MINL34)*(L7<MINL7) +8*(L8=MINL34)*(L8<MINL8) +9*(L9=MINL34)*(L9<MINL9) +10*(L10=MINL34)*(L10<MINL10) +11*(L11=MINL34)*(L11<MINL11) +12*(L12=MINL34)*(L12<MINL12) +13*(L13=MINL34)*(L13<MINL13) +14*(L14=MINL34)*(L14<MINL14) +15*(L15=MINL34)*(L15<MINL15) +16*(L16=MINL34)*(L16<MINL16) +17*(L17=MINL34)*(L17<MINL17) +18*(L18=MINL34)*(L18<MINL18) +19*(L19=MINL34)*(L19<MINL19) +20*(L20=MINL34)*(L20<MINL20) +21*(L21=MINL34)*(L21<MINL21) +22*(L22=MINL34)*(L22<MINL22) +23*(L23=MINL34)*(L23<MINL23) +24*(L24=MINL34)*(L24<MINL24) +25*(L25=MINL34)*(L25<MINL25) +26*(L26=MINL34)*(L26<MINL26) +27*(L27=MINL34)*(L27<MINL27) +28*(L28=MINL34)*(L28<MINL28) +29*(L29=MINL34)*(L29<MINL29) +30*(L30=MINL34)*(L30<MINL30) +31*(L31=MINL34)*(L31<MINL31) +32*(L32=MINL34)*(L32<MINL32) +33*(L33=MINL34)*(L33<MINL33) -(H1=MAXH34)*(H1>H) -2*(H2=MAXH34)*(H2>MAXH2) -3*(H3=MAXH34)*(H3>MAXH3) -4*(H4=MAXH34)*(H4>MAXH4) -5*(H5=MAXH34)*(H5>MAXH5) -6*(H6=MAXH34)*(H6>MAXH6) -7*(H7=MAXH34)*(H7>MAXH7) -8*(H8=MAXH34)*(H8>MAXH8) -9*(H9=MAXH34)*(H9>MAXH9) -10*(H10=MAXH34)*(H10>MAXH10) -11*(H11=MAXH34)*(H11>MAXH11) -12*(H12=MAXH34)*(H12>MAXH12) -13*(H13=MAXH34)*(H13>MAXH13) -14*(H14=MAXH34)*(H14>MAXH14) -15*(H15=MAXH34)*(H15>MAXH15) -16*(H16=MAXH34)*(H16>MAXH16) -17*(H17=MAXH34)*(H17>MAXH17) -18*(H18=MAXH34)*(H18>MAXH18) -19*(H19=MAXH34)*(H19>MAXH19) -20*(H20=MAXH34)*(H20>MAXH20) -21*(H21=MAXH34)*(H21>MAXH21) -22*(H22=MAXH34)*(H22>MAXH22) -23*(H23=MAXH34)*(H23>MAXH23) -24*(H24=MAXH34)*(H24>MAXH24) -25*(H25=MAXH34)*(H25>MAXH25) -26*(H26=MAXH34)*(H26>MAXH26) -27*(H27=MAXH34)*(H27>MAXH27) -28*(H28=MAXH34)*(H28>MAXH28) -29*(H29=MAXH34)*(H29>MAXH29) -30*(H30=MAXH34)*(H30>MAXH30) -31*(H31=MAXH34)*(H31>MAXH31) -32*(H32=MAXH34)*(H32>MAXH32) -33*(H33=MAXH34)*(H33>MAXH33) )/0.33)
AND
(( (L1.1=MINL13.1)*(L1.1<L.1) +2*(L2.1=MINL13.1)*(L2.1<MINL2.1) +3*(L3.1=MINL13.1)*(L3.1<MINL3.1) +4*(L4.1=MINL13.1)*(L4.1<MINL4.1) +5*(L5.1=MINL13.1)*(L5.1<MINL5.1) +6*(L6.1=MINL13.1)*(L6.1<MINL6.1) +7*(L7.1=MINL13.1)*(L7.1<MINL7.1) +8*(L8.1=MINL13.1)*(L8.1<MINL8.1) +9*(L9.1=MINL13.1)*(L9.1<MINL9.1) +10*(L10.1=MINL13.1)*(L10.1<MINL10) +11*(L11.1=MINL13.1)*(L11.1<MINL11.1) +12*(L12.1=MINL13.1)*(L12.1<MINL12.1) -(H1.1=MAXH13.1)*(H1.1>H.1) -2*(H2.1=MAXH13.1)*(H2.1>MAXH2.1) -3*(H3.1=MAXH13.1)*(H3.1>MAXH3.1) -4*(H4.1=MAXH13.1)*(H4.1>MAXH4.1) -5*(H5.1=MAXH13.1)*(H5.1>MAXH5.1) -6*(H6.1=MAXH13.1)*(H6.1>MAXH6.1) -7*(H7.1=MAXH13.1)*(H7.1>MAXH7.1) -8*(H8.1=MAXH13.1)*(H8.1>MAXH8.1) -9*(H9.1=MAXH13.1)*(H9.1>MAXH9.1) -10*(H10.1=MAXH13.1)*(H10.1>MAXH10.1) -11*(H11.1=MAXH13.1)*(H11.1>MAXH11.1) -12*(H12.1=MAXH13.1)*(H12.1>MAXH12.1))/0.12)
<
(( (L1.1=MINL34)*(L1.1<L) +2*(L2.1=MINL34)*(L2.1<MINL2.1) +3*(L3.1=MINL34)*(L3.1<MINL3.1) +4*(L4.1=MINL34)*(L4.1<MINL4.1) +5*(L5.1=MINL34)*(L5.1<MINL5.1) +6*(L6.1=MINL34)*(L6.1<MINL6.1) +7*(L7.1=MINL34)*(L7.1<MINL7.1) +8*(L8.1=MINL34)*(L8.1<MINL8.1) +9*(L9.1=MINL34)*(L9.1<MINL9.1) +10*(L10.1=MINL34)*(L10.1<MINL10.1) +11*(L11.1=MINL34)*(L11.1<MINL11.1) +12*(L12.1=MINL34)*(L12.1<MINL12.1) +13*(L13.1=MINL34)*(L13.1<MINL13.1) +14*(L14.1=MINL34)*(L14.1<MINL14.1) +15*(L15.1=MINL34)*(L15.1<MINL15.1) +16*(L16.1=MINL34)*(L16.1<MINL16.1) +17*(L17.1=MINL34)*(L17.1<MINL17.1) +18*(L18.1=MINL34)*(L18.1<MINL18.1) +19*(L19.1=MINL34)*(L19.1<MINL19.1) +20*(L20.1=MINL34)*(L20.1<MINL20.1) +21*(L21.1=MINL34)*(L21.1<MINL21.1) +22*(L22.1=MINL34)*(L22.1<MINL22.1) +23*(L23.1=MINL34)*(L23.1<MINL23.1) +24*(L24.1=MINL34)*(L24.1<MINL24.1) +25*(L25.1=MINL34)*(L25.1<MINL25.1) +26*(L26.1=MINL34)*(L26.1<MINL26.1) +27*(L27.1=MINL34)*(L27.1<MINL27.1) +28*(L28.1=MINL34)*(L28.1<MINL28.1) +29*(L29.1=MINL34)*(L29.1<MINL29.1) +30*(L30.1=MINL34)*(L30.1<MINL30.1) +31*(L31.1=MINL34)*(L31.1<MINL31.1) +32*(L32.1=MINL34)*(L32.1<MINL32.1) +33*(L33.1=MINL34)*(L33.1<MINL33.1)
-(H1.1=MAXH34.1)*(H1.1>H.1) -2*(H2.1=MAXH34.1)*(H2.1>MAXH2.1) -3*(H3.1=MAXH34.1)*(H3.1>MAXH3.1) -4*(H4.1=MAXH34.1)*(H4.1>MAXH4.1) -5*(H5.1=MAXH34.1)*(H5.1>MAXH5.1) -6*(H6.1=MAXH34.1)*(H6.1>MAXH6.1) -7*(H7.1=MAXH34.1)*(H7.1>MAXH7.1) -8*(H8.1=MAXH34.1)*(H8.1>MAXH8.1) -9*(H9.1=MAXH34.1)*(H9.1>MAXH9.1) -10*(H10.1=MAXH34.1)*(H10.1>MAXH10.1) -11*(H11.1=MAXH34.1)*(H11.1>MAXH11.1) -12*(H12.1=MAXH34.1)*(H12.1>MAXH12.1) -13*(H13.1=MAXH34.1)*(H13.1>MAXH13.1) -14*(H14.1=MAXH34.1)*(H14.1>MAXH14.1) -15*(H15.1=MAXH34.1)*(H15.1>MAXH15.1) -16*(H16.1=MAXH34.1)*(H16.1>MAXH16.1) -17*(H17.1=MAXH34.1)*(H17.1>MAXH17.1) -18*(H18.1=MAXH34.1)*(H18.1>MAXH18.1) -19*(H19.1=MAXH34.1)*(H19.1>MAXH19.1) -20*(H20.1=MAXH34.1)*(H20.1>MAXH20.1) -21*(H21.1=MAXH34.1)*(H21.1>MAXH21.1) -22*(H22.1=MAXH34.1)*(H22.1>MAXH22.1) -23*(H23.1=MAXH34.1)*(H23.1>MAXH23.1) -24*(H24.1=MAXH34.1)*(H24.1>MAXH24.1) -25*(H25.1=MAXH34.1)*(H25.1>MAXH25.1) -26*(H26.1=MAXH34.1)*(H26.1>MAXH26.1) -27*(H27.1=MAXH34.1)*(H27.1>MAXH27.1) -28*(H28.1=MAXH34.1)*(H28.1>MAXH28.1) -29*(H29.1=MAXH34.1)*(H29.1>MAXH29.1) -30*(H30.1=MAXH34.1)*(H30.1>MAXH30.1) -31*(H31.1=MAXH34.1)*(H31.1>MAXH31.1) -32*(H32.1=MAXH34.1)*(H32.1>MAXH32.1) -33*(H33.1=MAXH34.1)*(H33.1>MAXH33.1) )/0.33)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula instead to match the charts in TC2000 version 12:
((L1 = MINL14) * (L1 < L) + 2 * (L2 = MINL14) * (L2 < MINL2) + 3 * (L3 = MINL14) * (L3 < MINL3) + 4 * (L4 = MINL14) * (L4 < MINL4) + 5 * (L5 = MINL14) * (L5 < MINL5) + 6 * (L6 = MINL14) * (L6 < MINL6) + 7 * (L7 = MINL14) * (L7 < MINL7) + 8 * (L8 = MINL14) * (L8 < MINL8) + 9 * (L9 = MINL14) * (L9 < MINL9) + 10 * (L10 = MINL14) * (L10 < MINL10) + 11 * (L11 = MINL14) * (L11 < MINL11) + 12 * (L12 = MINL14) * (L12 < MINL12) + 13 * (L13 = MINL14) * (L13 < MINL13) - (H1 = MAXH14) * (H1 > H) - 2 * (H2 = MAXH14) * (H2 > MAXH2) - 3 * (H3 = MAXH14) * (H3 > MAXH3) - 4 * (H4 = MAXH14) * (H4 > MAXH4) - 5 * (H5 = MAXH14) * (H5 > MAXH5) - 6 * (H6 = MAXH14) * (H6 > MAXH6) - 7 * (H7 = MAXH14) * (H7 > MAXH7) - 8 * (H8 = MAXH14) * (H8 > MAXH8) - 9 * (H9 = MAXH14) * (H9 > MAXH9) - 10 * (H10 = MAXH14) * (H10 > MAXH10) - 11 * (H11 = MAXH14) * (H11 > MAXH11) - 12 * (H12 = MAXH14) * (H12 > MAXH12) - 13 * (H13 = MAXH14) * (H13 > MAXH13)) / .13 > ((L1 = MINL35) * (L1 < L) + 2 * (L2 = MINL35) * (L2 < MINL2) + 3 * (L3 = MINL35) * (L3 < MINL3) + 4 * (L4 = MINL35) * (L4 < MINL4) + 5 * (L5 = MINL35) * (L5 < MINL5) + 6 * (L6 = MINL35) * (L6 < MINL6) + 7 * (L7 = MINL35) * (L7 < MINL7) + 8 * (L8 = MINL35) * (L8 < MINL8) + 9 * (L9 = MINL35) * (L9 < MINL9) + 10 * (L10 = MINL35) * (L10 < MINL10) + 11 * (L11 = MINL35) * (L11 < MINL11) + 12 * (L12 = MINL35) * (L12 < MINL12) + 13 * (L13 = MINL35) * (L13 < MINL13) + 14 * (L14 = MINL35) * (L14 < MINL14) + 15 * (L15 = MINL35) * (L15 < MINL15) + 16 * (L16 = MINL35) * (L16 < MINL16) + 17 * (L17 = MINL35) * (L17 < MINL17) + 18 * (L18 = MINL35) * (L18 < MINL18) + 19 * (L19 = MINL35) * (L19 < MINL19) + 20 * (L20 = MINL35) * (L20 < MINL20) + 21 * (L21 = MINL35) * (L21 < MINL21) + 22 * (L22 = MINL35) * (L22 < MINL22) + 23 * (L23 = MINL35) * (L23 < MINL23) + 24 * (L24 = MINL35) * (L24 < MINL24) + 25 * (L25 = MINL35) * (L25 < MINL25) + 26 * (L26 = MINL35) * (L26 < MINL26) + 27 * (L27 = MINL35) * (L27 < MINL27) + 28 * (L28 = MINL35) * (L28 < MINL28) + 29 * (L29 = MINL35) * (L29 < MINL29) + 30 * (L30 = MINL35) * (L30 < MINL30) + 31 * (L31 = MINL35) * (L31 < MINL31) + 32 * (L32 = MINL35) * (L32 < MINL32) + 33 * (L33 = MINL35) * (L33 < MINL33) + 34 * (L34 = MINL35) * (L34 < MINL34) - (H1 = MAXH35) * (H1 > H) - 2 * (H2 = MAXH35) * (H2 > MAXH2) - 3 * (H3 = MAXH35) * (H3 > MAXH3) - 4 * (H4 = MAXH35) * (H4 > MAXH4) - 5 * (H5 = MAXH35) * (H5 > MAXH5) - 6 * (H6 = MAXH35) * (H6 > MAXH6) - 7 * (H7 = MAXH35) * (H7 > MAXH7) - 8 * (H8 = MAXH35) * (H8 > MAXH8) - 9 * (H9 = MAXH35) * (H9 > MAXH9) - 10 * (H10 = MAXH35) * (H10 > MAXH10) - 11 * (H11 = MAXH35) * (H11 > MAXH11) - 12 * (H12 = MAXH35) * (H12 > MAXH12) - 13 * (H13 = MAXH35) * (H13 > MAXH13) - 14 * (H14 = MAXH35) * (H14 > MAXH14) - 15 * (H15 = MAXH35) * (H15 > MAXH15) - 16 * (H16 = MAXH35) * (H16 > MAXH16) - 17 * (H17 = MAXH35) * (H17 > MAXH17) - 18 * (H18 = MAXH35) * (H18 > MAXH18) - 19 * (H19 = MAXH35) * (H19 > MAXH19) - 20 * (H20 = MAXH35) * (H20 > MAXH20) - 21 * (H21 = MAXH35) * (H21 > MAXH21) - 22 * (H22 = MAXH35) * (H22 > MAXH22) - 23 * (H23 = MAXH35) * (H23 > MAXH23) - 24 * (H24 = MAXH35) * (H24 > MAXH24) - 25 * (H25 = MAXH35) * (H25 > MAXH25) - 26 * (H26 = MAXH35) * (H26 > MAXH26) - 27 * (H27 = MAXH35) * (H27 > MAXH27) - 28 * (H28 = MAXH35) * (H28 > MAXH28) - 29 * (H29 = MAXH35) * (H29 > MAXH29) - 30 * (H30 = MAXH35) * (H30 > MAXH30) - 31 * (H31 = MAXH35) * (H31 > MAXH31) - 32 * (H32 = MAXH35) * (H32 > MAXH32) - 33 * (H33 = MAXH35) * (H33 > MAXH33) - 34 * (H34 = MAXH35) * (H34 > MAXH34)) / .34 AND ((L2 = MINL14.1) * (L2 < L1) + 3 * (L3 = MINL14.1) * (L3 < MINL2.1) + 4 * (L4 = MINL14.1) * (L4 < MINL3.1) + 5 * (L5 = MINL14.1) * (L5 < MINL4.1) + 6 * (L6 = MINL14.1) * (L6 < MINL5.1) + 7 * (L7 = MINL14.1) * (L7 < MINL6.1) + 8 * (L8 = MINL14.1) * (L8 < MINL7.1) + 9 * (L9 = MINL14.1) * (L9 < MINL8.1) + 10 * (L10 = MINL14.1) * (L10 < MINL9.1) + 11 * (L11 = MINL14.1) * (L11 < MINL10.1) + 12 * (L12 = MINL14.1) * (L12 < MINL11.1) + 13 * (L13 = MINL14.1) * (L13 < MINL12.1) + 14 * (L14 = MINL14.1) * (L14 < MINL13.1) - (H2 = MAXH14.1) * (H2 > H1) - 3 * (H3 = MAXH14.1) * (H3 > MAXH2.1) - 4 * (H4 = MAXH14.1) * (H4 > MAXH3.1) - 5 * (H5 = MAXH14.1) * (H5 > MAXH4.1) - 6 * (H6 = MAXH14.1) * (H6 > MAXH5.1) - 7 * (H7 = MAXH14.1) * (H7 > MAXH6.1) - 8 * (H8 = MAXH14.1) * (H8 > MAXH7.1) - 9 * (H9 = MAXH14.1) * (H9 > MAXH8.1) - 10 * (H10 = MAXH14.1) * (H10 > MAXH9.1) - 11 * (H11 = MAXH14.1) * (H11 > MAXH10.1) - 12 * (H12 = MAXH14.1) * (H12 > MAXH11.1) - 13 * (H13 = MAXH14.1) * (H13 > MAXH12.1) - 14 * (H14 = MAXH14.1) * (H14 > MAXH13.1)) / .13 <= ((L2 = MINL35.1) * (L2 < L1) + 2 * (L3 = MINL35.1) * (L3 < MINL2.1) + 3 * (L4 = MINL35.1) * (L4 < MINL3.1) + 4 * (L5 = MINL35.1) * (L5 < MINL4.1) + 5 * (L6 = MINL35.1) * (L6 < MINL5.1) + 6 * (L7 = MINL35.1) * (L7 < MINL6.1) + 7 * (L8 = MINL35.1) * (L8 < MINL7.1) + 8 * (L9 = MINL35.1) * (L9 < MINL8.1) + 9 * (L10 = MINL35.1) * (L10 < MINL9.1) + 10 * (L11 = MINL35.1) * (L11 < MINL10.1) + 11 * (L12 = MINL35.1) * (L12 < MINL11.1) + 12 * (L13 = MINL35.1) * (L13 < MINL12.1) + 13 * (L14 = MINL35.1) * (L14 < MINL13.1) + 14 * (L15 = MINL35.1) * (L15 < MINL14.1) + 15 * (L16 = MINL35.1) * (L16 < MINL15.1) + 16 * (L17 = MINL35.1) * (L17 < MINL16.1) + 17 * (L18 = MINL35.1) * (L18 < MINL17.1) + 18 * (L19 = MINL35.1) * (L19 < MINL18.1) + 19 * (L20 = MINL35.1) * (L20 < MINL19.1) + 20 * (L21 = MINL35.1) * (L21 < MINL20.1) + 21 * (L22 = MINL35.1) * (L22 < MINL21.1) + 22 * (L23 = MINL35.1) * (L23 < MINL22.1) + 23 * (L24 = MINL35.1) * (L24 < MINL23.1) + 24 * (L25 = MINL35.1) * (L25 < MINL24.1) + 25 * (L26 = MINL35.1) * (L26 < MINL25.1) + 26 * (L27 = MINL35.1) * (L27 < MINL26.1) + 27 * (L28 = MINL35.1) * (L28 < MINL27.1) + 28 * (L29 = MINL35.1) * (L29 < MINL28.1) + 29 * (L30 = MINL35.1) * (L30 < MINL29.1) + 30 * (L31 = MINL35.1) * (L31 < MINL30.1) + 31 * (L32 = MINL35.1) * (L32 < MINL31.1) + 32 * (L33 = MINL35.1) * (L33 < MINL32.1) + 33 * (L34 = MINL35.1) * (L34 < MINL33.1) + 34 * (L35 = MINL35.1) * (L35 < MINL34.1) - (H2 = MAXH35.1) * (H2 > H1) - 2 * (H3 = MAXH35.1) * (H3 > MAXH2.1) - 3 * (H4 = MAXH35.1) * (H4 > MAXH3.1) - 4 * (H5 = MAXH35.1) * (H5 > MAXH4.1) - 5 * (H6 = MAXH35.1) * (H6 > MAXH5.1) - 6 * (H7 = MAXH35.1) * (H7 > MAXH6.1) - 7 * (H8 = MAXH35.1) * (H8 > MAXH7.1) - 8 * (H9 = MAXH35.1) * (H9 > MAXH8.1) - 9 * (H10 = MAXH35.1) * (H10 > MAXH9.1) - 10 * (H11 = MAXH35.1) * (H11 > MAXH10.1) - 11 * (H12 = MAXH35.1) * (H12 > MAXH11.1) - 12 * (H13 = MAXH35.1) * (H13 > MAXH12.1) - 13 * (H14 = MAXH35.1) * (H14 > MAXH13.1) - 14 * (H15 = MAXH35.1) * (H15 > MAXH14.1) - 15 * (H16 = MAXH35.1) * (H16 > MAXH15.1) - 16 * (H17 = MAXH35.1) * (H17 > MAXH16.1) - 17 * (H18 = MAXH35.1) * (H18 > MAXH17.1) - 18 * (H19 = MAXH35.1) * (H19 > MAXH18.1) - 19 * (H20 = MAXH35.1) * (H20 > MAXH19.1) - 20 * (H21 = MAXH35.1) * (H21 > MAXH20.1) - 21 * (H22 = MAXH35.1) * (H22 > MAXH21.1) - 22 * (H23 = MAXH35.1) * (H23 > MAXH22.1) - 23 * (H24 = MAXH35.1) * (H24 > MAXH23.1) - 24 * (H25 = MAXH35.1) * (H25 > MAXH24.1) - 25 * (H26 = MAXH35.1) * (H26 > MAXH25.1) - 26 * (H27 = MAXH35.1) * (H27 > MAXH26.1) - 27 * (H28 = MAXH35.1) * (H28 > MAXH27.1) - 28 * (H29 = MAXH35.1) * (H29 > MAXH28.1) - 29 * (H30 = MAXH35.1) * (H30 > MAXH29.1) - 30 * (H31 = MAXH35.1) * (H31 > MAXH30.1) - 31 * (H32 = MAXH35.1) * (H32 > MAXH31.1) - 32 * (H33 = MAXH35.1) * (H33 > MAXH32.1) - 33 * (H34 = MAXH35.1) * (H34 > MAXH33.1) - 34 * (H35 = MAXH35.1) * (H35 > MAXH34.1)) / .34
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 12/18/2004
Posts: 50
|
Thank you Bruce. Both values (13 and 34) match exactly.
|
|
Gold Customer
Joined: 12/18/2004
Posts: 50
|
Bruce,
I must be doing something wrong. As I mentioned, the formulas that you provided for the Aroon with values of 13 and 34 match the values of the chart pefectly on a daily basis.
When I plot the Up and Down portions in a %True indicator, they reflect each and every signal of the TC2000 Aroon chart.
However, when I use the complete formula in a %True PCF, it does not appear to display the Aroon (13-34) buy signal of the SP-500 on 8/16/2011. Don't know why.
I'm not really sure how to test the formula values for yesterday's number.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Since you indicated the values of 13 and 34 match the chart perfectly, I'm assuming you have broken the formulas for the 13-Period Aroon Oscillator and 34-Period Aroon Oscillator out, plotted them as Custom PCF Indicators and compared them directly to the Aroon Oscillators
You can break out the 13-Period Aroon Oscillator and 34-Period Oscillator for yesterday out of the formula and compare them to 1-Period Simple Moving Averages with an Offset of 1 to the Aroon Oscillators to test those values as well.
I have adjusted the formula slightly in my Tuesday, August 23, 2011 2:58:32 PM ET version however, so you may want to give that a try instead of your current version.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 12/18/2004
Posts: 50
|
Bruce,
When I said that I tested the Up and Down portions, I was referring to your formula.
I also used your 8/23 version of the formula in a %True PCF and it does not show the SP-500 buy signal on 8/16 that is displayed by the TC2000 Aroon (13 and 34).
Here's what I used. Did I do something wrong? Thanks.
((L1 = MINL14) * (L1 < L) + 2 * (L2 = MINL14) * (L2 < MINL2) + 3 * (L3 = MINL14) * (L3 < MINL3) + 4 * (L4 = MINL14) * (L4 < MINL4) + 5 * (L5 = MINL14) * (L5 < MINL5) + 6 * (L6 = MINL14) * (L6 < MINL6) + 7 * (L7 = MINL14) * (L7 < MINL7) + 8 * (L8 = MINL14) * (L8 < MINL8) + 9 * (L9 = MINL14) * (L9 < MINL9) + 10 * (L10 = MINL14) * (L10 < MINL10) + 11 * (L11 = MINL14) * (L11 < MINL11) + 12 * (L12 = MINL14) * (L12 < MINL12) + 13 * (L13 = MINL14) * (L13 < MINL13) - (H1 = MAXH14) * (H1 > H) - 2 * (H2 = MAXH14) * (H2 > MAXH2) - 3 * (H3 = MAXH14) * (H3 > MAXH3) - 4 * (H4 = MAXH14) * (H4 > MAXH4) - 5 * (H5 = MAXH14) * (H5 > MAXH5) - 6 * (H6 = MAXH14) * (H6 > MAXH6) - 7 * (H7 = MAXH14) * (H7 > MAXH7) - 8 * (H8 = MAXH14) * (H8 > MAXH8) - 9 * (H9 = MAXH14) * (H9 > MAXH9) - 10 * (H10 = MAXH14) * (H10 > MAXH10) - 11 * (H11 = MAXH14) * (H11 > MAXH11) - 12 * (H12 = MAXH14) * (H12 > MAXH12) - 13 * (H13 = MAXH14) * (H13 > MAXH13)) / .13 > ((L1 = MINL35) * (L1 < L) + 2 * (L2 = MINL35) * (L2 < MINL2) + 3 * (L3 = MINL35) * (L3 < MINL3) + 4 * (L4 = MINL35) * (L4 < MINL4) + 5 * (L5 = MINL35) * (L5 < MINL5) + 6 * (L6 = MINL35) * (L6 < MINL6) + 7 * (L7 = MINL35) * (L7 < MINL7) + 8 * (L8 = MINL35) * (L8 < MINL8) + 9 * (L9 = MINL35) * (L9 < MINL9) + 10 * (L10 = MINL35) * (L10 < MINL10) + 11 * (L11 = MINL35) * (L11 < MINL11) + 12 * (L12 = MINL35) * (L12 < MINL12) + 13 * (L13 = MINL35) * (L13 < MINL13) + 14 * (L14 = MINL35) * (L14 < MINL14) + 15 * (L15 = MINL35) * (L15 < MINL15) + 16 * (L16 = MINL35) * (L16 < MINL16) + 17 * (L17 = MINL35) * (L17 < MINL17) + 18 * (L18 = MINL35) * (L18 < MINL18) + 19 * (L19 = MINL35) * (L19 < MINL19) + 20 * (L20 = MINL35) * (L20 < MINL20) + 21 * (L21 = MINL35) * (L21 < MINL21) + 22 * (L22 = MINL35) * (L22 < MINL22) + 23 * (L23 = MINL35) * (L23 < MINL23) + 24 * (L24 = MINL35) * (L24 < MINL24) + 25 * (L25 = MINL35) * (L25 < MINL25) + 26 * (L26 = MINL35) * (L26 < MINL26) + 27 * (L27 = MINL35) * (L27 < MINL27) + 28 * (L28 = MINL35) * (L28 < MINL28) + 29 * (L29 = MINL35) * (L29 < MINL29) + 30 * (L30 = MINL35) * (L30 < MINL30) + 31 * (L31 = MINL35) * (L31 < MINL31) + 32 * (L32 = MINL35) * (L32 < MINL32) + 33 * (L33 = MINL35) * (L33 < MINL33) + 34 * (L34 = MINL35) * (L34 < MINL34) - (H1 = MAXH35) * (H1 > H) - 2 * (H2 = MAXH35) * (H2 > MAXH2) - 3 * (H3 = MAXH35) * (H3 > MAXH3) - 4 * (H4 = MAXH35) * (H4 > MAXH4) - 5 * (H5 = MAXH35) * (H5 > MAXH5) - 6 * (H6 = MAXH35) * (H6 > MAXH6) - 7 * (H7 = MAXH35) * (H7 > MAXH7) - 8 * (H8 = MAXH35) * (H8 > MAXH8) - 9 * (H9 = MAXH35) * (H9 > MAXH9) - 10 * (H10 = MAXH35) * (H10 > MAXH10) - 11 * (H11 = MAXH35) * (H11 > MAXH11) - 12 * (H12 = MAXH35) * (H12 > MAXH12) - 13 * (H13 = MAXH35) * (H13 > MAXH13) - 14 * (H14 = MAXH35) * (H14 > MAXH14) - 15 * (H15 = MAXH35) * (H15 > MAXH15) - 16 * (H16 = MAXH35) * (H16 > MAXH16) - 17 * (H17 = MAXH35) * (H17 > MAXH17) - 18 * (H18 = MAXH35) * (H18 > MAXH18) - 19 * (H19 = MAXH35) * (H19 > MAXH19) - 20 * (H20 = MAXH35) * (H20 > MAXH20) - 21 * (H21 = MAXH35) * (H21 > MAXH21) - 22 * (H22 = MAXH35) * (H22 > MAXH22) - 23 * (H23 = MAXH35) * (H23 > MAXH23) - 24 * (H24 = MAXH35) * (H24 > MAXH24) - 25 * (H25 = MAXH35) * (H25 > MAXH25) - 26 * (H26 = MAXH35) * (H26 > MAXH26) - 27 * (H27 = MAXH35) * (H27 > MAXH27) - 28 * (H28 = MAXH35) * (H28 > MAXH28) - 29 * (H29 = MAXH35) * (H29 > MAXH29) - 30 * (H30 = MAXH35) * (H30 > MAXH30) - 31 * (H31 = MAXH35) * (H31 > MAXH31) - 32 * (H32 = MAXH35) * (H32 > MAXH32) - 33 * (H33 = MAXH35) * (H33 > MAXH33) - 34 * (H34 = MAXH35) * (H34 > MAXH34)) / .34 AND ((L2 = MINL14.1) * (L2 < L1) + 3 * (L3 = MINL14.1) * (L3 < MINL2.1) + 4 * (L4 = MINL14.1) * (L4 < MINL3.1) + 5 * (L5 = MINL14.1) * (L5 < MINL4.1) + 6 * (L6 = MINL14.1) * (L6 < MINL5.1) + 7 * (L7 = MINL14.1) * (L7 < MINL6.1) + 8 * (L8 = MINL14.1) * (L8 < MINL7.1) + 9 * (L9 = MINL14.1) * (L9 < MINL8.1) + 10 * (L10 = MINL14.1) * (L10 < MINL9.1) + 11 * (L11 = MINL14.1) * (L11 < MINL10.1) + 12 * (L12 = MINL14.1) * (L12 < MINL11.1) + 13 * (L13 = MINL14.1) * (L13 < MINL12.1) + 14 * (L14 = MINL14.1) * (L14 < MINL13.1) - (H2 = MAXH14.1) * (H2 > H1) - 3 * (H3 = MAXH14.1) * (H3 > MAXH2.1) - 4 * (H4 = MAXH14.1) * (H4 > MAXH3.1) - 5 * (H5 = MAXH14.1) * (H5 > MAXH4.1) - 6 * (H6 = MAXH14.1) * (H6 > MAXH5.1) - 7 * (H7 = MAXH14.1) * (H7 > MAXH6.1) - 8 * (H8 = MAXH14.1) * (H8 > MAXH7.1) - 9 * (H9 = MAXH14.1) * (H9 > MAXH8.1) - 10 * (H10 = MAXH14.1) * (H10 > MAXH9.1) - 11 * (H11 = MAXH14.1) * (H11 > MAXH10.1) - 12 * (H12 = MAXH14.1) * (H12 > MAXH11.1) - 13 * (H13 = MAXH14.1) * (H13 > MAXH12.1) - 14 * (H14 = MAXH14.1) * (H14 > MAXH13.1)) / .14 <= ((L2 = MINL35.1) * (L2 < L1) + 3 * (L3 = MINL35.1) * (L3 < MINL2.1) + 4 * (L4 = MINL35.1) * (L4 < MINL3.1) + 5 * (L5 = MINL35.1) * (L5 < MINL4.1) + 6 * (L6 = MINL35.1) * (L6 < MINL5.1) + 7 * (L7 = MINL35.1) * (L7 < MINL6.1) + 8 * (L8 = MINL35.1) * (L8 < MINL7.1) + 9 * (L9 = MINL35.1) * (L9 < MINL8.1) + 10 * (L10 = MINL35.1) * (L10 < MINL9.1) + 11 * (L11 = MINL35.1) * (L11 < MINL10.1) + 12 * (L12 = MINL35.1) * (L12 < MINL11.1) + 13 * (L13 = MINL35.1) * (L13 < MINL12.1) + 14 * (L14 = MINL35.1) * (L14 < MINL13.1) + 15 * (L15 = MINL35.1) * (L15 < MINL14.1) + 16 * (L16 = MINL35.1) * (L16 < MINL15.1) + 17 * (L17 = MINL35.1) * (L17 < MINL16.1) + 18 * (L18 = MINL35.1) * (L18 < MINL17.1) + 19 * (L19 = MINL35.1) * (L19 < MINL18.1) + 20 * (L20 = MINL35.1) * (L20 < MINL19.1) + 21 * (L21 = MINL35.1) * (L21 < MINL20.1) + 22 * (L22 = MINL35.1) * (L22 < MINL21.1) + 23 * (L23 = MINL35.1) * (L23 < MINL22.1) + 24 * (L24 = MINL35.1) * (L24 < MINL23.1) + 25 * (L25 = MINL35.1) * (L25 < MINL24.1) + 26 * (L26 = MINL35.1) * (L26 < MINL25.1) + 27 * (L27 = MINL35.1) * (L27 < MINL26.1) + 28 * (L28 = MINL35.1) * (L28 < MINL27.1) + 29 * (L29 = MINL35.1) * (L29 < MINL28.1) + 30 * (L30 = MINL35.1) * (L30 < MINL29.1) + 31 * (L31 = MINL35.1) * (L31 < MINL30.1) + 32 * (L32 = MINL35.1) * (L32 < MINL31.1) + 33 * (L33 = MINL35.1) * (L33 < MINL32.1) + 34 * (L34 = MINL35.1) * (L34 < MINL33.1) + 35 * (L35 = MINL35.1) * (L35 < MINL34.1) - (H2 = MAXH35.1) * (H2 > H1) - 3 * (H3 = MAXH35.1) * (H3 > MAXH2.1) - 4 * (H4 = MAXH35.1) * (H4 > MAXH3.1) - 5 * (H5 = MAXH35.1) * (H5 > MAXH4.1) - 6 * (H6 = MAXH35.1) * (H6 > MAXH5.1) - 7 * (H7 = MAXH35.1) * (H7 > MAXH6.1) - 8 * (H8 = MAXH35.1) * (H8 > MAXH7.1) - 9 * (H9 = MAXH35.1) * (H9 > MAXH8.1) - 10 * (H10 = MAXH35.1) * (H10 > MAXH9.1) - 11 * (H11 = MAXH35.1) * (H11 > MAXH10.1) - 12 * (H12 = MAXH35.1) * (H12 > MAXH11.1) - 13 * (H13 = MAXH35.1) * (H13 > MAXH12.1) - 14 * (H14 = MAXH35.1) * (H14 > MAXH13.1) - 15 * (H15 = MAXH35.1) * (H15 > MAXH14.1) - 16 * (H16 = MAXH35.1) * (H16 > MAXH15.1) - 17 * (H17 = MAXH35.1) * (H17 > MAXH16.1) - 18 * (H18 = MAXH35.1) * (H18 > MAXH17.1) - 19 * (H19 = MAXH35.1) * (H19 > MAXH18.1) - 20 * (H20 = MAXH35.1) * (H20 > MAXH19.1) - 21 * (H21 = MAXH35.1) * (H21 > MAXH20.1) - 22 * (H22 = MAXH35.1) * (H22 > MAXH21.1) - 23 * (H23 = MAXH35.1) * (H23 > MAXH22.1) - 24 * (H24 = MAXH35.1) * (H24 > MAXH23.1) - 25 * (H25 = MAXH35.1) * (H25 > MAXH24.1) - 26 * (H26 = MAXH35.1) * (H26 > MAXH25.1) - 27 * (H27 = MAXH35.1) * (H27 > MAXH26.1) - 28 * (H28 = MAXH35.1) * (H28 > MAXH27.1) - 29 * (H29 = MAXH35.1) * (H29 > MAXH28.1) - 30 * (H30 = MAXH35.1) * (H30 > MAXH29.1) - 31 * (H31 = MAXH35.1) * (H31 > MAXH30.1) - 32 * (H32 = MAXH35.1) * (H32 > MAXH31.1) - 33 * (H33 = MAXH35.1) * (H33 > MAXH32.1) - 34 * (H34 = MAXH35.1) * (H34 > MAXH33.1) - 35 * (H35 = MAXH35.1) * (H35 > MAXH34.1)) / .34
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (robbiefx125) Here's what I used. Did I do something wrong?
You need to go back to my Tuesday, August 23, 2011 2:58:32 PM ET post and re-copy the newer version of the formula.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 12/18/2004
Posts: 50
|
Got it....finally. I misunderstood when you said that you modified your formula. I was looking for a new post (from you) and assumed you thought I was back to my incorrect formula.
Plots correctly now. Thanks for your help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |