Hi Bruce.

I would like to get pcf of 20 & 50 periods Money Flow Oscillator indicator mentioned on October 2015 S &C magazine.

Calculating the MFO

1. Multiplier=[( High - Previous low) - ( Previous high - low)] / [( High - previous low) + ( previous high - low)]

2. Money Flow Volume = Multiplier x Volume for the period.

3. 20 period MFO = 20 period sum of money flow volume / 20 period sum of volume.

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))

And the 50 period 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))) + V20 * ((H20 < L21) - (L20 > H21) - (H20 >= L21 AND L20 <= H21) * (H20 + L20 - H21 - L21) / (H20 - L20 + H21 - L21 - (H20 + H21 = L20 + L21))) + V21 * ((H21 < L22) - (L21 > H22) - (H21 >= L22 AND L21 <= H22) * (H21 + L21 - H22 - L22) / (H21 - L21 + H22 - L22 - (H21 + H22 = L21 + L22))) + V22 * ((H22 < L23) - (L22 > H23) - (H22 >= L23 AND L22 <= H23) * (H22 + L22 - H23 - L23) / (H22 - L22 + H23 - L23 - (H22 + H23 = L22 + L23))) + V23 * ((H23 < L24) - (L23 > H24) - (H23 >= L24 AND L23 <= H24) * (H23 + L23 - H24 - L24) / (H23 - L23 + H24 - L24 - (H23 + H24 = L23 + L24))) + V24 * ((H24 < L25) - (L24 > H25) - (H24 >= L25 AND L24 <= H25) * (H24 + L24 - H25 - L25) / (H24 - L24 + H25 - L25 - (H24 + H25 = L24 + L25))) + V25 * ((H25 < L26) - (L25 > H26) - (H25 >= L26 AND L25 <= H26) * (H25 + L25 - H26 - L26) / (H25 - L25 + H26 - L26 - (H25 + H26 = L25 + L26))) + V26 * ((H26 < L27) - (L26 > H27) - (H26 >= L27 AND L26 <= H27) * (H26 + L26 - H27 - L27) / (H26 - L26 + H27 - L27 - (H26 + H27 = L26 + L27))) + V27 * ((H27 < L28) - (L27 > H28) - (H27 >= L28 AND L27 <= H28) * (H27 + L27 - H28 - L28) / (H27 - L27 + H28 - L28 - (H27 + H28 = L27 + L28))) + V28 * ((H28 < L29) - (L28 > H29) - (H28 >= L29 AND L28 <= H29) * (H28 + L28 - H29 - L29) / (H28 - L28 + H29 - L29 - (H28 + H29 = L28 + L29))) + V29 * ((H29 < L30) - (L29 > H30) - (H29 >= L30 AND L29 <= H30) * (H29 + L29 - H30 - L30) / (H29 - L29 + H30 - L30 - (H29 + H30 = L29 + L30))) + V30 * ((H30 < L31) - (L30 > H31) - (H30 >= L31 AND L30 <= H31) * (H30 + L30 - H31 - L31) / (H30 - L30 + H31 - L31 - (H30 + H31 = L30 + L31))) + V31 * ((H31 < L32) - (L31 > H32) - (H31 >= L32 AND L31 <= H32) * (H31 + L31 - H32 - L32) / (H31 - L31 + H32 - L32 - (H31 + H32 = L31 + L32))) + V32 * ((H32 < L33) - (L32 > H33) - (H32 >= L33 AND L32 <= H33) * (H32 + L32 - H33 - L33) / (H32 - L32 + H33 - L33 - (H32 + H33 = L32 + L33))) + V33 * ((H33 < L34) - (L33 > H34) - (H33 >= L34 AND L33 <= H34) * (H33 + L33 - H34 - L34) / (H33 - L33 + H34 - L34 - (H33 + H34 = L33 + L34))) + V34 * ((H34 < L35) - (L34 > H35) - (H34 >= L35 AND L34 <= H35) * (H34 + L34 - H35 - L35) / (H34 - L34 + H35 - L35 - (H34 + H35 = L34 + L35))) + V35 * ((H35 < L36) - (L35 > H36) - (H35 >= L36 AND L35 <= H36) * (H35 + L35 - H36 - L36) / (H35 - L35 + H36 - L36 - (H35 + H36 = L35 + L36))) + V36 * ((H36 < L37) - (L36 > H37) - (H36 >= L37 AND L36 <= H37) * (H36 + L36 - H37 - L37) / (H36 - L36 + H37 - L37 - (H36 + H37 = L36 + L37))) + V37 * ((H37 < L38) - (L37 > H38) - (H37 >= L38 AND L37 <= H38) * (H37 + L37 - H38 - L38) / (H37 - L37 + H38 - L38 - (H37 + H38 = L37 + L38))) + V38 * ((H38 < L39) - (L38 > H39) - (H38 >= L39 AND L38 <= H39) * (H38 + L38 - H39 - L39) / (H38 - L38 + H39 - L39 - (H38 + H39 = L38 + L39))) + V39 * ((H39 < L40) - (L39 > H40) - (H39 >= L40 AND L39 <= H40) * (H39 + L39 - H40 - L40) / (H39 - L39 + H40 - L40 - (H39 + H40 = L39 + L40))) + V40 * ((H40 < L41) - (L40 > H41) - (H40 >= L41 AND L40 <= H41) * (H40 + L40 - H41 - L41) / (H40 - L40 + H41 - L41 - (H40 + H41 = L40 + L41))) + V41 * ((H41 < L42) - (L41 > H42) - (H41 >= L42 AND L41 <= H42) * (H41 + L41 - H42 - L42) / (H41 - L41 + H42 - L42 - (H41 + H42 = L41 + L42))) + V42 * ((H42 < L43) - (L42 > H43) - (H42 >= L43 AND L42 <= H43) * (H42 + L42 - H43 - L43) / (H42 - L42 + H43 - L43 - (H42 + H43 = L42 + L43))) + V43 * ((H43 < L44) - (L43 > H44) - (H43 >= L44 AND L43 <= H44) * (H43 + L43 - H44 - L44) / (H43 - L43 + H44 - L44 - (H43 + H44 = L43 + L44))) + V44 * ((H44 < L45) - (L44 > H45) - (H44 >= L45 AND L44 <= H45) * (H44 + L44 - H45 - L45) / (H44 - L44 + H45 - L45 - (H44 + H45 = L44 + L45))) + V45 * ((H45 < L46) - (L45 > H46) - (H45 >= L46 AND L45 <= H46) * (H45 + L45 - H46 - L46) / (H45 - L45 + H46 - L46 - (H45 + H46 = L45 + L46))) + V46 * ((H46 < L47) - (L46 > H47) - (H46 >= L47 AND L46 <= H47) * (H46 + L46 - H47 - L47) / (H46 - L46 + H47 - L47 - (H46 + H47 = L46 + L47))) + V47 * ((H47 < L48) - (L47 > H48) - (H47 >= L48 AND L47 <= H48) * (H47 + L47 - H48 - L48) / (H47 - L47 + H48 - L48 - (H47 + H48 = L47 + L48))) + V48 * ((H48 < L49) - (L48 > H49) - (H48 >= L49 AND L48 <= H49) * (H48 + L48 - H49 - L49) / (H48 - L48 + H49 - L49 - (H48 + H49 = L48 + L49))) + V49 * ((H49 < L50) - (L49 > H50) - (H49 >= L50 AND L49 <= H50) * (H49 + L49 - H50 - L50) / (H49 - L49 + H50 - L50 - (H49 + H50 = L49 + L50)))) / 50 / (AVGV50 - (AVGV50 = 0))

Bruce I dont think Money Flow Index and Money Flow Oscillator are the same

I am looking for the Formula that would Equal the TC2000 indicator "Money Flow Index" when set to a 3 Period

Please try the following Indicator 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) / ((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 - .00001))

Perfect.  Thanks !!

Bruce  I think this the last formula i am using in the old format

Can you convert to new syntax Thanks

Maybe the following?

100 - 100 / (1 + SUM((H + L + C > H1 + L1 + C1) * (H + L + C) * V, 3) / SUM((H + L + C < H1 + L1 + C1) * (H + L + C) * V, 3)