Can you write a PCF for the money flow oscillator from the October TASC issue?

If I understand it correctly (which is not guaranteed), an Indicator Formula for a 20 period money flow oscillator as outlined in Vitali Apirine’s article in the October 2015 issue of STOCKS & COMMODITIES, “The Money Flow Oscillator” can be written as follows.

100 * (V * ((H < L1) - (L > H1) - (H >= L1 AND L <= H1) * (H + L - H1 - L1) / (H - L + H1 - L1 - (H + H1 = L + L1))) + V1 * ((H1 < L2) - (L1 > H2) - (H1 >= L2 AND L1 <= H2) * (H1 + L1 - H2 - L2) / (H1 - L1 + H2 - L2 - (H1 + H2 = L1 + L2))) + V2 * ((H2 < L3) - (L2 > H3) - (H2 >= L3 AND L2 <= H3) * (H2 + L2 - H3 - L3) / (H2 - L2 + H3 - L3 - (H2 + H3 = L2 + L3))) + V3 * ((H3 < L4) - (L3 > H4) - (H3 >= L4 AND L3 <= H4) * (H3 + L3 - H4 - L4) / (H3 - L3 + H4 - L4 - (H3 + H4 = L3 + L4))) + V4 * ((H4 < L5) - (L4 > H5) - (H4 >= L5 AND L4 <= H5) * (H4 + L4 - H5 - L5) / (H4 - L4 + H5 - L5 - (H4 + H5 = L4 + L5))) + V5 * ((H5 < L6) - (L5 > H6) - (H5 >= L6 AND L5 <= H6) * (H5 + L5 - H6 - L6) / (H5 - L5 + H6 - L6 - (H5 + H6 = L5 + L6))) + V6 * ((H6 < L7) - (L6 > H7) - (H6 >= L7 AND L6 <= H7) * (H6 + L6 - H7 - L7) / (H6 - L6 + H7 - L7 - (H6 + H7 = L6 + L7))) + V7 * ((H7 < L8) - (L7 > H8) - (H7 >= L8 AND L7 <= H8) * (H7 + L7 - H8 - L8) / (H7 - L7 + H8 - L8 - (H7 + H8 = L7 + L8))) + V8 * ((H8 < L9) - (L8 > H9) - (H8 >= L9 AND L8 <= H9) * (H8 + L8 - H9 - L9) / (H8 - L8 + H9 - L9 - (H8 + H9 = L8 + L9))) + V9 * ((H9 < L10) - (L9 > H10) - (H9 >= L10 AND L9 <= H10) * (H9 + L9 - H10 - L10) / (H9 - L9 + H10 - L10 - (H9 + H10 = L9 + L10))) + V10 * ((H10 < L11) - (L10 > H11) - (H10 >= L11 AND L10 <= H11) * (H10 + L10 - H11 - L11) / (H10 - L10 + H11 - L11 - (H10 + H11 = L10 + L11))) + V11 * ((H11 < L12) - (L11 > H12) - (H11 >= L12 AND L11 <= H12) * (H11 + L11 - H12 - L12) / (H11 - L11 + H12 - L12 - (H11 + H12 = L11 + L12))) + V12 * ((H12 < L13) - (L12 > H13) - (H12 >= L13 AND L12 <= H13) * (H12 + L12 - H13 - L13) / (H12 - L12 + H13 - L13 - (H12 + H13 = L12 + L13))) + V13 * ((H13 < L14) - (L13 > H14) - (H13 >= L14 AND L13 <= H14) * (H13 + L13 - H14 - L14) / (H13 - L13 + H14 - L14 - (H13 + H14 = L13 + L14))) + V14 * ((H14 < L15) - (L14 > H15) - (H14 >= L15 AND L14 <= H15) * (H14 + L14 - H15 - L15) / (H14 - L14 + H15 - L15 - (H14 + H15 = L14 + L15))) + V15 * ((H15 < L16) - (L15 > H16) - (H15 >= L16 AND L15 <= H16) * (H15 + L15 - H16 - L16) / (H15 - L15 + H16 - L16 - (H15 + H16 = L15 + L16))) + V16 * ((H16 < L17) - (L16 > H17) - (H16 >= L17 AND L16 <= H17) * (H16 + L16 - H17 - L17) / (H16 - L16 + H17 - L17 - (H16 + H17 = L16 + L17))) + V17 * ((H17 < L18) - (L17 > H18) - (H17 >= L18 AND L17 <= H18) * (H17 + L17 - H18 - L18) / (H17 - L17 + H18 - L18 - (H17 + H18 = L17 + L18))) + V18 * ((H18 < L19) - (L18 > H19) - (H18 >= L19 AND L18 <= H19) * (H18 + L18 - H19 - L19) / (H18 - L18 + H19 - L19 - (H18 + H19 = L18 + L19))) + V19 * ((H19 < L20) - (L19 > H20) - (H19 >= L20 AND L19 <= H20) * (H19 + L19 - H20 - L20) / (H19 - L19 + H20 - L20 - (H19 + H20 = L19 + L20)))) / 20 / (AVGV20 - (AVGV20 = 0))

Awesome! Thank you!

Bruce if this is the TC2000 Money Flow Index - Can you provide a 3 period formula and can i take that formula and create a true / false statement from that for (MF3 formula) > 99 and (MF3 formula) < 1

It is not the Money Flow Index, it is the Money Flow Oscillator. About the closest I can get to the 3 period Money Flow Index can be written as follows.

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) / ((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) * V1 - .00001))

You can add > 99 to the end or you can add < 1 to the end, but both could not be true at the same time. This means if you were going to create a combined formula, you would use OR instead of AND between the two formulas.