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 |

Profile: lorca
About
User Name: lorca
Groups: Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Saturday, July 19, 2008
Last Visit: Monday, August 19, 2019 4:27:26 PM
Number of Posts: 2
[0.00% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: Aroon PCF
Posted: Wednesday, October 5, 2016 6:15:40 PM

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!

Topic: Write an indicator
Posted: Friday, April 17, 2015 10:07:31 PM

AVG(AVGC28,14) + 6.5 * (6.5 * AVGC28. + 5.5 * AVGC28.1 + 4.5 * AVGC28.2 + 3.5 * AVGC28.3 + 2.5 * AVGC28.4 + 1.5 * AVGC28.5 + .5 * AVGC28.6 - .5 * AVGC28.7 - 1.5 * AVGC28.8 - 2.5 * AVGC28.9 - 3.5 * AVGC28.10 - 4.5 * AVGC28.11 - 5.5 * AVGC28.12 - 6.5 * AVGC28.13) / 227.5

 bRUCE COPY PASTE IN TC200 AND DONT WORK AND ALL THE INDICATOR  AND EXP ATR EITHER WAY ARE WRONG 

 

LIKE YOU MAKE THE CORRECTION 

THANKS BRUCE

LOOKINF FORWARD FOR AN EXPLANATION