Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 110
|
Hi Bruce;
Got another PCF I'am trying to work out. The condition formula that I'am struggling with right now is one where the objective is to show the current and previous bar Money Flow Index - 5 Period value under the two and seven day moving averages derrived from the Money Flow Index - 5 Period Indicator.
Hoping this is do-able, thanking you in advance.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
100 - 100 / (1 + ((H + L + C > H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4) / ((H + L + C < H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 - .00001)) < 100 - 100 / (1 + ((H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5) / ((H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 - .00001)) AND 6 * (100 - 100 / (1 + ((H + L + C > H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4) / ((H + L + C < H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 - .00001))) < 100 - 100 / (1 + ((H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5) / ((H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 - .00001)) + 100 - 100 / (1 + ((H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6) / ((H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 - .00001)) + 100 - 100 / (1 + ((H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7) / ((H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 - .00001)) + 100 - 100 / (1 + ((H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8) / ((H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 - .00001)) + 100 - 100 / (1 + ((H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 > H10 + L10 + C10) * (H9 + L9 + C9) * V9) / ((H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 < H10 + L10 + C10) * (H9 + L9 + C9) * V9 - .00001)) + 100 - 100 / (1 + ((H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 > H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 > H11 + L11 + C11) * (H10 + L10 + C10) * V10) / ((H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 < H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 < H11 + L11 + C11) * (H10 + L10 + C10) * V10 - .00001))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 110
|
Bruce;
The formula provided worked very well however I'am chagrined to admit that I inadvertantly requested you to provide a condition where the Money Flow Index (5Period) is under both the two and seven day moving averages for the last two bars and what I really wanted was the Money Flow Index (5Period) to be below both the three and seven day moving averages for the last two bars. May I trouble you to provide the revised version ?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
2 * (100 - 100 / (1 + ((H + L + C > H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4) / ((H + L + C < H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 - .00001))) < 100 - 100 / (1 + ((H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5) / ((H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 - .00001)) + 100 - 100 / (1 + ((H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6) / ((H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 - .00001)) AND 6 * (100 - 100 / (1 + ((H + L + C > H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4) / ((H + L + C < H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 - .00001))) < 100 - 100 / (1 + ((H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5) / ((H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 - .00001)) + 100 - 100 / (1 + ((H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6) / ((H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 - .00001)) + 100 - 100 / (1 + ((H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7) / ((H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 - .00001)) + 100 - 100 / (1 + ((H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8) / ((H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 - .00001)) + 100 - 100 / (1 + ((H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 > H10 + L10 + C10) * (H9 + L9 + C9) * V9) / ((H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 < H10 + L10 + C10) * (H9 + L9 + C9) * V9 - .00001)) + 100 - 100 / (1 + ((H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 > H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 > H11 + L11 + C11) * (H10 + L10 + C10) * V10) / ((H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 < H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 < H11 + L11 + C11) * (H10 + L10 + C10) * V10 - .00001))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 110
|
The new version of the formula worked excellent. Thank you very much for your tremendous effort on this condition problem.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |