Untitled Page

Welcome Guest, please sign in to participate in a discussion.

Search | Active Topics |

Worden Discussion Forum » Members » lorca

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