Last 10 Posts Topic: adx segment Posted: Monday, June 18, 2018 6:06:18 PM Nice....   Thank you.   QUOTE (Bruce_L) Please try the following: `SUM(IIF(ADX14.14 \ 10 <> ADX14.14.1 \ 10, C, 0), 200) / CountTrue(ADX14.14 \ 10 <> ADX14.14.1 \ 10, 200)` Nice....   Thank you. Topic: adx segment Posted: Monday, June 18, 2018 2:12:29 PM Thank you.  I will settle on my rough average... Topic: adx segment Posted: Monday, June 18, 2018 1:32:39 PM I see... The best I can get  is this:  b=  iif(xup(adx14.14,10,1) or xdown(adx14.14,10,1) or             xup(adx14.14,20,1) or xdown(adx14.14,20,1) or xup(adx14.14,30,1) or xdown(adx14.14,30,1) or xup(adx14.14,40,1) or xdown(adx14.14,40,1) or xup(adx14.14,50,1) or xdown(adx14.14,50,1) or xup(adx14.14,60,1) or xdown(adx14.14,60,1) or xup(adx14.14,70,1) or xdown(adx14.14,70,1) , c, 0.0)   and then dividing by  countrue  (b,200) we can get an average.     QUOTE (Bruce_L) No, I can't really think of a practical way to do this. Topic: adx segment Posted: Monday, June 18, 2018 9:31:11 AM HI Bruce:        Is it possible to write a PCF that gives the last price at which ADX has crossed an integer multiple of 10? Topic: ha color change count Posted: Thursday, May 31, 2018 9:15:17 PM Thanks! Topic: ha color change count Posted: Thursday, May 31, 2018 3:43:20 PM Hi Bruce:          I would be interested in the number of heiken ashi color changes over the last n (say 21) periods. Topic: Questions about Heiken-Ashi Formulas Posted: Monday, May 21, 2018 3:10:01 PM Thank you. Great Job. But I think there is a missing ")" at the end. QUOTE (Bruce_L)Please try the following indicator formula. `SGN(XAVG(O1 + H1 + L1 + C1, 3) - HAVG(O + H + L + C, 21)) + SGN(GREATEST(4 * H, XAVG(O1 + H1 + L1 + C1, 3)) - MAX(GREATEST(4 * H1, XAVG(O2 + H2 + L2 + C2, 3)), 2))` Topic: Questions about Heiken-Ashi Formulas Posted: Monday, May 21, 2018 2:30:21 PM Hi Bruce: I would like a PCF that is +2 if:                      heiken ashi low of current bar is above hull 21 of heiken ashi closes                      heiken ashi high of current bar is higher than heiken ashi highs of previous two bars                   0 if only one condition is met and                 -2        if both conditions are not met. Topic: Help With Scan Condition Posted: Monday, May 07, 2018 5:17:58 PM Well done... Thank you.  The second to last  formula works fine.  The main problem with the  final formula is  "51+c13" should be 51*c13". The two formulas still produce slightly different numbers - may be due to floating point in avgc?.   Hope you feel better soon  :) Topic: Help With Scan Condition Posted: Monday, May 07, 2018 4:00:03 PM QUOTE (Bruce_L) Please try the following. (203 * C4 + 3330 * AVGC6.5 + 345 * C11 + 177 * C12 + 51 + C13 - 1075 * C1 - 612 * C2 - 186 * C3 - 33 * C14 - 525 * AVGC7.14 - 50 * C22 - 30 * C23 - 15 * C24 - 5 * C25) / 1575   Hmm. The formula seems to be too low most of the time - should be where havgc slope changes.