| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
This is a part of an answer to a question raised in Ultimate Oscillator. Information on how to construct these formulas is contained in Days Since Last Peak (or other day-counting needs). The following can be used as Personal Criteria Formulas or plotted as Custom Indicators (check Center Zero Line when using the Oscillator as a Custom Indicator):
Aroon(+) 25-Period:
100-((H1=MAXH25)*(H1>H) +2*(H2=MAXH25)*(H2>MAXH2) +3*(H3=MAXH25)*(H3>MAXH3) +4*(H4=MAXH25)*(H4>MAXH4) +5*(H5=MAXH25)*(H5>MAXH5) +6*(H6=MAXH25)*(H6>MAXH6) +7*(H7=MAXH25)*(H7>MAXH7) +8*(H8=MAXH25)*(H8>MAXH8) +9*(H9=MAXH25)*(H9>MAXH9) +10*(H10=MAXH25)*(H10>MAXH10) +11*(H11=MAXH25)*(H11>MAXH11) +12*(H12=MAXH25)*(H12>MAXH12) +13*(H13=MAXH25)*(H13>MAXH13) +14*(H14=MAXH25)*(H14>MAXH14) +15*(H15=MAXH25)*(H15>MAXH15) +16*(H16=MAXH25)*(H16>MAXH16) +17*(H17=MAXH25)*(H17>MAXH17) +18*(H18=MAXH25)*(H18>MAXH18) +19*(H19=MAXH25)*(H19>MAXH19) +20*(H20=MAXH25)*(H20>MAXH20) +21*(H21=MAXH25)*(H21>MAXH21) +22*(H22=MAXH25)*(H22>MAXH22) +23*(H23=MAXH25)*(H23>MAXH23) +24*(H24=MAXH25)*(H24>MAXH24))/.24
Aroon(-) 25-Period:
100-((L1=MINL25)*(L1<L) +2*(L2=MINL25)*(L2<MINL2) +3*(L3=MINL25)*(L3<MINL3) +4*(L4=MINL25)*(L4<MINL4) +5*(L5=MINL25)*(L5<MINL5) +6*(L6=MINL25)*(L6<MINL6) +7*(L7=MINL25)*(L7<MINL7) +8*(L8=MINL25)*(L8<MINL8) +9*(L9=MINL25)*(L9<MINL9) +10*(L10=MINL25)*(L10<MINL10) +11*(L11=MINL25)*(L11<MINL11) +12*(L12=MINL25)*(L12<MINL12) +13*(L13=MINL25)*(L13<MINL13) +14*(L14=MINL25)*(L14<MINL14) +15*(L15=MINL25)*(L15<MINL15) +16*(L16=MINL25)*(L16<MINL16) +17*(L17=MINL25)*(L17<MINL17) +18*(L18=MINL25)*(L18<MINL18) +19*(L19=MINL25)*(L19<MINL19) +20*(L20=MINL25)*(L20<MINL20) +21*(L21=MINL25)*(L21<MINL21) +22*(L22=MINL25)*(L22<MINL22) +23*(L23=MINL25)*(L23<MINL23) +24*(L24=MINL25)*(L24<MINL24))/.24
Aroon Oscillator 25-Period:
((L1=MINL25)*(L1<L) +2*(L2=MINL25)*(L2<MINL2) +3*(L3=MINL25)*(L3<MINL3) +4*(L4=MINL25)*(L4<MINL4) +5*(L5=MINL25)*(L5<MINL5) +6*(L6=MINL25)*(L6<MINL6) +7*(L7=MINL25)*(L7<MINL7) +8*(L8=MINL25)*(L8<MINL8) +9*(L9=MINL25)*(L9<MINL9) +10*(L10=MINL25)*(L10<MINL10) +11*(L11=MINL25)*(L11<MINL11) +12*(L12=MINL25)*(L12<MINL12) +13*(L13=MINL25)*(L13<MINL13) +14*(L14=MINL25)*(L14<MINL14) +15*(L15=MINL25)*(L15<MINL15) +16*(L16=MINL25)*(L16<MINL16) +17*(L17=MINL25)*(L17<MINL17) +18*(L18=MINL25)*(L18<MINL18) +19*(L19=MINL25)*(L19<MINL19) +20*(L20=MINL25)*(L20<MINL20) +21*(L21=MINL25)*(L21<MINL21) +22*(L22=MINL25)*(L22<MINL22) +23*(L23=MINL25)*(L23<MINL23) +24*(L24=MINL25)*(L24<MINL24) -(H1=MAXH25)*(H1>H) -2*(H2=MAXH25)*(H2>MAXH2) -3*(H3=MAXH25)*(H3>MAXH3) -4*(H4=MAXH25)*(H4>MAXH4) -5*(H5=MAXH25)*(H5>MAXH5) -6*(H6=MAXH25)*(H6>MAXH6) -7*(H7=MAXH25)*(H7>MAXH7) -8*(H8=MAXH25)*(H8>MAXH8) -9*(H9=MAXH25)*(H9>MAXH9) -10*(H10=MAXH25)*(H10>MAXH10) -11*(H11=MAXH25)*(H11>MAXH11) -12*(H12=MAXH25)*(H12>MAXH12) -13*(H13=MAXH25)*(H13>MAXH13) -14*(H14=MAXH25)*(H14>MAXH14) -15*(H15=MAXH25)*(H15>MAXH15) -16*(H16=MAXH25)*(H16>MAXH16) -17*(H17=MAXH25)*(H17>MAXH17) -18*(H18=MAXH25)*(H18>MAXH18) -19*(H19=MAXH25)*(H19>MAXH19) -20*(H20=MAXH25)*(H20>MAXH20) -21*(H21=MAXH25)*(H21>MAXH21) -22*(H22=MAXH25)*(H22>MAXH22) -23*(H23=MAXH25)*(H23>MAXH23) -24*(H24=MAXH25)*(H24>MAXH24))/.24
Watching the following videos could be useful in using these formulas:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Adding, removing and saving indicators to a chart template
Customize your charts using Chart Templates
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 35
|
Thank you!!!!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/24/2005
Posts: 2
|
What would the formula be if I wanted an Aroon (8) indicator instead of the Aroon (25)??
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
TicTac,
Try these:
Aroon(+) 8-Period:
100-((H1=MAXH8)*(H1>H) +2*(H2=MAXH8)*(H2>MAXH2) +3*(H3=MAXH8)*(H3>MAXH3) +4*(H4=MAXH8)*(H4>MAXH4) +5*(H5=MAXH8)*(H5>MAXH5) +6*(H6=MAXH8)*(H6>MAXH6) +7*(H7=MAXH8)*(H7>MAXH7))/.07
Aroon(-) 8-Period:
100-((L1=MINL8)*(L1<L) +2*(L2=MINL8)*(L2<MINL2) +3*(L3=MINL8)*(L3<MINL3) +4*(L4=MINL8)*(L4<MINL4) +5*(L5=MINL8)*(L5<MINL5) +6*(L6=MINL8)*(L6<MINL6) +7*(L7=MINL8)*(L7<MINL7))/.07
Aroon Oscillator 8-Period:
((L1=MINL8)*(L1<L) +2*(L2=MINL8)*(L2<MINL2) +3*(L3=MINL8)*(L3<MINL3) +4*(L4=MINL8)*(L4<MINL4) +5*(L5=MINL8)*(L5<MINL5) +6*(L6=MINL8)*(L6<MINL6) +7*(L7=MINL8)*(L7<MINL7) -(H1=MAXH8)*(H1>H) -2*(H2=MAXH8)*(H2>MAXH2) -3*(H3=MAXH8)*(H3>MAXH3) -4*(H4=MAXH8)*(H4>MAXH4) -5*(H5=MAXH8)*(H5>MAXH5) -6*(H6=MAXH8)*(H6>MAXH6) -7*(H7=MAXH8)*(H7>MAXH7))/.07
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Aroon(+) 20-Period:
100-((H1=MAXH20)*(H1>H) +2*(H2=MAXH20)*(H2>MAXH2) +3*(H3=MAXH20)*(H3>MAXH3) +4*(H4=MAXH20)*(H4>MAXH4) +5*(H5=MAXH20)*(H5>MAXH5) +6*(H6=MAXH20)*(H6>MAXH6) +7*(H7=MAXH20)*(H7>MAXH7) +8*(H8=MAXH20)*(H8>MAXH8) +9*(H9=MAXH20)*(H9>MAXH9) +10*(H10=MAXH20)*(H10>MAXH10) +11*(H11=MAXH20)*(H11>MAXH11) +12*(H12=MAXH20)*(H12>MAXH12) +13*(H13=MAXH20)*(H13>MAXH13) +14*(H14=MAXH20)*(H14>MAXH14) +15*(H15=MAXH20)*(H15>MAXH15) +16*(H16=MAXH20)*(H16>MAXH16) +17*(H17=MAXH20)*(H17>MAXH17) +18*(H18=MAXH20)*(H18>MAXH18) +19*(H19=MAXH20)*(H19>MAXH19))/0.19
Aroon(-) 20-Period:
100-((L1=MINL20)*(L1<L) +2*(L2=MINL20)*(L2<MINL2) +3*(L3=MINL20)*(L3<MINL3) +4*(L4=MINL20)*(L4<MINL4) +5*(L5=MINL20)*(L5<MINL5) +6*(L6=MINL20)*(L6<MINL6) +7*(L7=MINL20)*(L7<MINL7) +8*(L8=MINL20)*(L8<MINL8) +9*(L9=MINL20)*(L9<MINL9) +10*(L10=MINL20)*(L10<MINL10) +11*(L11=MINL20)*(L11<MINL11) +12*(L12=MINL20)*(L12<MINL12) +13*(L13=MINL20)*(L13<MINL13) +14*(L14=MINL20)*(L14<MINL14) +15*(L15=MINL20)*(L15<MINL15) +16*(L16=MINL20)*(L16<MINL16) +17*(L17=MINL20)*(L17<MINL17) +18*(L18=MINL20)*(L18<MINL18) +19*(L19=MINL20)*(L19<MINL19))/0.19
Aroon Oscillator 20-Period:
((L1=MINL20)*(L1<L) +2*(L2=MINL20)*(L2<MINL2) +3*(L3=MINL20)*(L3<MINL3) +4*(L4=MINL20)*(L4<MINL4) +5*(L5=MINL20)*(L5<MINL5) +6*(L6=MINL20)*(L6<MINL6) +7*(L7=MINL20)*(L7<MINL7) +8*(L8=MINL20)*(L8<MINL8) +9*(L9=MINL20)*(L9<MINL9) +10*(L10=MINL20)*(L10<MINL10) +11*(L11=MINL20)*(L11<MINL11) +12*(L12=MINL20)*(L12<MINL12) +13*(L13=MINL20)*(L13<MINL13) +14*(L14=MINL20)*(L14<MINL14) +15*(L15=MINL20)*(L15<MINL15) +16*(L16=MINL20)*(L16<MINL16) +17*(L17=MINL20)*(L17<MINL17) +18*(L18=MINL20)*(L18<MINL18) +19*(L19=MINL20)*(L19<MINL19) -(H1=MAXH20)*(H1>H) -2*(H2=MAXH20)*(H2>MAXH2) -3*(H3=MAXH20)*(H3>MAXH3) -4*(H4=MAXH20)*(H4>MAXH4) -5*(H5=MAXH20)*(H5>MAXH5) -6*(H6=MAXH20)*(H6>MAXH6) -7*(H7=MAXH20)*(H7>MAXH7) -8*(H8=MAXH20)*(H8>MAXH8) -9*(H9=MAXH20)*(H9>MAXH9) -10*(H10=MAXH20)*(H10>MAXH10) -11*(H11=MAXH20)*(H11>MAXH11) -12*(H12=MAXH20)*(H12>MAXH12) -13*(H13=MAXH20)*(H13>MAXH13) -14*(H14=MAXH20)*(H14>MAXH14) -15*(H15=MAXH20)*(H15>MAXH15) -16*(H16=MAXH20)*(H16>MAXH16) -17*(H17=MAXH20)*(H17>MAXH17) -18*(H18=MAXH20)*(H18>MAXH18) -19*(H19=MAXH20)*(H19>MAXH19))/0.19
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
 Gold Customer
Joined: 3/20/2006
Posts: 161
|
Can you show formula for Aroon as a histogram with 20 periods? Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
jpag1,
That would already be available as the Aroon Oscillator 20-Period in my Monday, February 06, 2006 8:08:15 PM ET post.
If you wish to plot it, you would use a Custom Indicator:
Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Checked
- Plot using price scale: Unchecked
- Smoothing Average: 1
- Average Type: Simple or Exponential (Doesn't matter because the Smoothing Average is 1)
- Indicator Formula: ((L1 = MINL20) * (L1 < L) + 2 * (L2 = MINL20) * (L2 < MINL2) + 3 * (L3 = MINL20) * (L3 < MINL3) + 4 * (L4 = MINL20) * (L4 < MINL4) + 5 * (L5 = MINL20) * (L5 < MINL5) + 6 * (L6 = MINL20) * (L6 < MINL6) + 7 * (L7 = MINL20) * (L7 < MINL7) + 8 * (L8 = MINL20) * (L8 < MINL8) + 9 * (L9 = MINL20) * (L9 < MINL9) + 10 * (L10 = MINL20) * (L10 < MINL10) + 11 * (L11 = MINL20) * (L11 < MINL11) + 12 * (L12 = MINL20) * (L12 < MINL12) + 13 * (L13 = MINL20) * (L13 < MINL13) + 14 * (L14 = MINL20) * (L14 < MINL14) + 15 * (L15 = MINL20) * (L15 < MINL15) + 16 * (L16 = MINL20) * (L16 < MINL16) + 17 * (L17 = MINL20) * (L17 < MINL17) + 18 * (L18 = MINL20) * (L18 < MINL18) + 19 * (L19 = MINL20) * (L19 < MINL19) - (H1 = MAXH20) * (H1 > H) - 2 * (H2 = MAXH20) * (H2 > MAXH2) - 3 * (H3 = MAXH20) * (H3 > MAXH3) - 4 * (H4 = MAXH20) * (H4 > MAXH4) - 5 * (H5 = MAXH20) * (H5 > MAXH5) - 6 * (H6 = MAXH20) * (H6 > MAXH6) - 7 * (H7 = MAXH20) * (H7 > MAXH7) - 8 * (H8 = MAXH20) * (H8 > MAXH8) - 9 * (H9 = MAXH20) * (H9 > MAXH9) - 10 * (H10 = MAXH20) * (H10 > MAXH10) - 11 * (H11 = MAXH20) * (H11 > MAXH11) - 12 * (H12 = MAXH20) * (H12 > MAXH12) - 13 * (H13 = MAXH20) * (H13 > MAXH13) - 14 * (H14 = MAXH20) * (H14 > MAXH14) - 15 * (H15 = MAXH20) * (H15 > MAXH15) - 16 * (H16 = MAXH20) * (H16 > MAXH16) - 17 * (H17 = MAXH20) * (H17 > MAXH17) - 18 * (H18 = MAXH20) * (H18 > MAXH18) - 19 * (H19 = MAXH20) * (H19 > MAXH19)) / .19
It will not plot as a Histogram (with lines going up and down from zero, but will draw an outline of the Histogram (the values will be the same).
If you can't live without the "Histogram Look", you can use Personal Chartist for Blocks Player. The Aroon Oscillator is available in the Web Library.
You may wish to review the following:
Plotting Custom Indicators with Examples
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
|
Thanks That will work
|
|
Registered User
Joined: 4/5/2014
Posts: 4
|
Buy using the pdf code above I can create this conditionfor a filter:
Aroon(+) 25-Period > Aroon(-) 25-Period
What I am trying to do now is set a limit as to how many days this has been true. Is this possible?
Thanks
GIb
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you have a Condition Formula and you need that Condition Formula to be true less than a certain number of bars in a row, you could use that Condition Formula as the Boolean Formula in a Custom PCF % True Indicator with the Period set to the number of bars in a row of interest and the Average Type set to Simple.
How to add an indicator to a chart template
How to edit an Indicator
The Custom PCF % True Indicator will be less than 100 if and only if its Boolean Formula was not true for Simple Period bars in a row.
This means you could click on the Custom PCF % True Indicator and select Create Scan Condition to create a condition for the Custom PCF % True Indicator being less than 100. This would be a condition for when the Condition Formulas was not true Period bars in a row.
Create Conditions from Your Chart (5:25)
If you actually want to scan for the current bar being true as well, you would add both the condition you already created and the new condition to the same EasyScan.
Building a Scan with Multiple Conditions (7:29)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Can I have:
Aroon(+) 6-period.
Aroon Osc 6-period.
Aroon Osc 11-period.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Aroon(+) 6-period:
100 * (1 - (ABS(H = MAXH7) * 0 + ABS(H < MAXH7) * (ABS(H1 = MAXH7) * 1 + ABS(H1 < MAXH7) * (ABS(H2 = MAXH7) * 2 + ABS(H2 < MAXH7) * (ABS(H3 = MAXH7) * 3 + ABS(H3 < MAXH7) * (ABS(H4 = MAXH7) * 4 + ABS(H4 < MAXH7) * (ABS(H5 = MAXH7) * 5 + ABS(H5 < MAXH7) * (ABS(H6 = MAXH7) * 6))))))) / 6)
Aroon Osc 6-period:
100 * ((ABS(L > MINL7) * (ABS(L1 = MINL7) + ABS(L1 > MINL7) * (ABS(L2 = MINL7) * 2 + ABS(L2 > MINL7) * (ABS(L3 = MINL7) * 3 + ABS(L3 > MINL7) * (ABS(L4 = MINL7) * 4 + ABS(L4 > MINL7) * (ABS(L5 = MINL7) * 5 + ABS(L5 > MINL7) * (ABS(L6 = MINL7) * 6))))))) / 6 - (ABS(H < MAXH7) * (ABS(H1 = MAXH7) + ABS(H1 < MAXH7) * (ABS(H2 = MAXH7) * 2 + ABS(H2 < MAXH7) * (ABS(H3 = MAXH7) * 3 + ABS(H3 < MAXH7) * (ABS(H4 = MAXH7) * 4 + ABS(H4 < MAXH7) * (ABS(H5 = MAXH7) * 5 + ABS(H5 < MAXH7) * (ABS(H6 = MAXH7) * 6))))))) / 6)
Aroon Osc 11-period:
100 * ((ABS(L > MINL12) * (ABS(L1 = MINL12) + ABS(L1 > MINL12) * (ABS(L2 = MINL12) * 2 + ABS(L2 > MINL12) * (ABS(L3 = MINL12) * 3 + ABS(L3 > MINL12) * (ABS(L4 = MINL12) * 4 + ABS(L4 > MINL12) * (ABS(L5 = MINL12) * 5 + ABS(L5 > MINL12) * (ABS(L6 = MINL12) * 6 + ABS(L6 > MINL12) * (ABS(L7 = MINL12) * 7 + ABS(L7 > MINL12) * (ABS(L8 = MINL12) * 8 + ABS(L8 > MINL12) * (ABS(L9 = MINL12) * 9 + ABS(L9 > MINL12) * (ABS(L10 = MINL12) * 10 + ABS(L10 > MINL12) * (ABS(L11 = MINL12) * 11)))))))))))) - (ABS(H < MAXH12) * (ABS(H1 = MAXH12) + ABS(H1 < MAXH12) * (ABS(H2 = MAXH12) * 2 + ABS(H2 < MAXH12) * (ABS(H3 = MAXH12) * 3 + ABS(H3 < MAXH12) * (ABS(H4 = MAXH12) * 4 + ABS(H4 < MAXH12) * (ABS(H5 = MAXH12) * 5 + ABS(H5 < MAXH12) * (ABS(H6 = MAXH12) * 6 + ABS(H6 < MAXH12) * (ABS(H7 = MAXH12) * 7 + ABS(H7 < MAXH12) * (ABS(H8 = MAXH12) * 8 + ABS(H8 < MAXH12) * (ABS(H9 = MAXH12) * 9 + ABS(H9 < MAXH12) * (ABS(H10 = MAXH12) * 10 + ABS(H10 < MAXH12) * (ABS(H11 = MAXH12) * 11))))))))))))) / 11
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |