Tryed reading many of the prev post about linear regression line (most seem far outside what i wish to scan for

In reference to Moving Linear Regression indicator set to 20 period I wish to have a condition in library for  the 2 items below

H < MovLReg 20

and separate

L > MovLReg 20

Thanks

H <= (AVGC20 + 9.5 * (9.5 * C + 8.5 * C1 + 7.5 * C2 + 6.5 * C3 + 5.5 * C4 + 4.5 * C5 + 3.5 * C6 + 2.5 * C7 + 1.5 * C8 + .5 * C9 - .5 * C10 - 1.5 * C11 - 2.5 * C12 - 3.5 * C13 - 4.5 * C14 - 5.5 * C15 - 6.5 * C16 - 7.5 * C17 - 8.5 * C18 - 9.5 * C19) / 665 )

The first formula would be:

H < AVGC20 + 9.5 * (9.5 * C + 8.5 * C1 + 7.5 * C2 + 6.5 * C3 + 5.5 * C4 + 4.5 * C5 + 3.5 * C6 + 2.5 * C7 + 1.5 * C8 + .5 * C9 - .5 * C10 - 1.5 * C11 - 2.5 * C12 - 3.5 * C13 - 4.5 * C14 - 5.5 * C15 - 6.5 * C16 - 7.5 * C17 - 8.5 * C18 - 9.5 * C19) / 665

And the second formula would be:

L > AVGC20 + 9.5 * (9.5 * C + 8.5 * C1 + 7.5 * C2 + 6.5 * C3 + 5.5 * C4 + 4.5 * C5 + 3.5 * C6 + 2.5 * C7 + 1.5 * C8 + .5 * C9 - .5 * C10 - 1.5 * C11 - 2.5 * C12 - 3.5 * C13 - 4.5 * C14 - 5.5 * C15 - 6.5 * C16 - 7.5 * C17 - 8.5 * C18 - 9.5 * C19) / 665

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

Bruce,

Please help w/ an Indicator Formula for a 7-Period Moving Linear Regression. 

Also the 7-Period MLR Xing its own moving average 2 (either up or down).  Thank you in advance! 

Please try the following Indicator Formula for a 7 period moving linear regression.

AVGC7 + 3 * (3 * (C - C6) + 2 * (C1 - C5) + C2 - C4) / 28

Please try the following Condition Formula for a 7-period moving linear regression crossing through its own 2-period moving average in either direction.

SGN(13 * C - 18 * AVGC6.1 + 5 * C7) <> SGN(13 * C1 - 18 * AVGC6.2 + 5 * C8)

Bruce I have 2 requests - 1 is related to this topic the other is not.

LRL H20

(AVGH20 + 19 * (19 * (H - H19) + 17 * (H1 - H18) + 15 * (H2 - H17) + 13 * (H3 - H16) + 11 * (H4 - H15) + 9 * (H5 - H14) + 7 * (H6 - H13) + 5 * (H7 - H12) + 3 * (H8 - H11) + H9 - H10) / 2660 )

LRL L20

(AVGL20 + 19 * (19 * (L - L19) + 17 * (L1 - L18) + 15 * (L2 - L17) + 13 * (L3 - L16) + 11 * (L4 - L15) + 9 * (L5 - L14) + 7 * (L6 - L13) + 5 * (L7 - L12) + 3 * (L8 - L11) + L9 - L10) / 2660 )

CAN YOU PROVIDE ME WITH EACH OF THESE 1 BAR AGO (I dont want to use a moving average as i wish to create a True/False statment with these for my charts)

THIS IS THE UNRELATED PART

3 Period VWAP

((((C*V) / V) + ((C1*V1) / V1) + ((C2*V2) / V2)) / 3)

AND

3.1 Period VWAP

((((C1*V1) / V1) + ((C2*V2) / V2) + ((C3*V3) / V3)) / 3)

Can you provide me with a formula for the 3 Period Moving Average of each of these

Thanks

LRL H20 1 Bar Ago

(AVGH20.1 + 19 * (19 * (H1 - H20) + 17 * (H2 - H19) + 15 * (H3 - H18) + 13 * (H4 - H17) + 11 * (H5 - H16) + 9 * (H6 - H15) + 7 * (H7 - H14) + 5 * (H8 - H13) + 3 * (H9 - H12) + H10 - H11) / 2660)

LRL L20 1 Bar Ago

(AVGL20.1 + 19 * (19 * (L1 - L20) + 17 * (L2 - L19) + 15 * (L3 - L18) + 13 * (L4 - L17) + 11 * (L5 - L16) + 9 * (L6 - L15) + 7 * (L7 - L14) + 5 * (L8 - L13) + 3 * (L9 - L12) + L10 - L11) / 2660)

A note on your VWAP formulas. Your first one just works out to the following.

AVGC3

And your second one just works out to the following.

AVGC3.1

So the 3 period simple moving average of the first formula is just:

AVG(AVGC3,3)

Ad the 3 period simple moving average of the second formula is just:

AVG(AVGC3.1,3)

I suspect what you really want for the first formula is as follows.

(C * V + C1 * V1 + C2 * V2) / 3 / AVGV3

And what you really want for the second formula is as follows.

(C1 * V1 + C2 * V2 * C3 * V3) / 3 / AVGV3.1

Which would make the 3 period simple moving average of the first formula:

((C * V + C1 * V1 + C2 * V2) / AVGV3 + (C1 * V1 + C2 * V2 * C3 * V3) / AVGV3.1 + (C2 * V2 + C3 * V3 * C4 * V4) / AVGV3.2) / 9

And the 3 period simple moving average of the second formula:

((C1 * V1 + C2 * V2 * C3 * V3) / AVGV3.1 + (C2 * V2 + C3 * V3 * C4 * V4) / AVGV3.2 + (C3 * V3 * C4 * V4 + C5 * V5) / AVGV3.3) / 9

THANKS

CAN YOU PRODUCE THESE FOR 5 PERIOD AND 8 PERIOD

LRL H20

(AVGH20 + 19 * (19 * (H - H19) + 17 * (H1 - H18) + 15 * (H2 - H17) + 13 * (H3 - H16) + 11 * (H4 - H15) + 9 * (H5 - H14) + 7 * (H6 - H13) + 5 * (H7 - H12) + 3 * (H8 - H11) + H9 - H10) / 2660 )

LRL H20 1 Bar Ago

(AVGH20.1 + 19 * (19 * (H1 - H20) + 17 * (H2 - H19) + 15 * (H3 - H18) + 13 * (H4 - H17) + 11 * (H5 - H16) + 9 * (H6 - H15) + 7 * (H7 - H14) + 5 * (H8 - H13) + 3 * (H9 - H12) + H10 - H11) / 2660)

LRL L20 (AVGL20 + 19 * (19 * (L - L19) + 17 * (L1 - L18) + 15 * (L2 - L17) + 13 * (L3 - L16) + 11 * (L4 - L15) + 9 * (L5 - L14) + 7 * (L6 - L13) + 5 * (L7 - L12) + 3 * (L8 - L11) + L9 - L10) / 2660 )

LRL L20 1 Bar Ago (AVGL20.1 + 19 * (19 * (L1 - L20) + 17 * (L2 - L19) + 15 * (L3 - L18) + 13 * (L4 - L17) + 11 * (L5 - L16) + 9 * (L6 - L15) + 7 * (L7 - L14) + 5 * (L8 - L13) + 3 * (L9 - L12) + L10 - L11) / 2660)

Thanks again

LRL H8

AVGH8 + 3.5 * (3.5 * (H - H7) + 2.5 * (H1 - H6) + 1.5 * (H2 - H5) + 0.5 * (H3 - H4)) / 42

LRL H8.1

AVGH8.1 + 3.5 * (3.5 * (H1 - H8) + 2.5 * (H2 - H7) + 1.5 * (H3 - H6) + 0.5 * (H4 - H5)) / 42

LRL L8

AVGL8 + 3.5 * (3.5 * (L - L7) + 2.5 * (L1 - L6) + 1.5 * (L2 - L5) + .5 * (L3 - L4)) / 42

LRL L8.1

AVGL8.1 + 3.5 * (3.5 * (L1 - L8) + 2.5 * (L2 - L7) + 1.5 * (L3 - L6) + .5 * (L4 - L5)) / 42

LRL H5

AVGH5 + 2 * (2 * (H - H4) + H1 - H3) / 10

LRL H5.1

AVGH5.1 + 2 * (2 * (H1 - H5) + H2 - H4) / 10

LRL L5

AVGL5 + 2 * (2 * (L - L4) + L1 - L3) / 10

LRL L5.1

AVGL5.1 + 2 * (2 * (L1 - L5) + L2 - L4) / 10

LOL that was quick, Thanks

CAN YOU DO THE 50 AND 100 (MY THINKING CAP WAS ON BACKWARDS)  I thought the shorter period would show me what i wanted quicker, but it is the opposite)

These will be in a slightly different format, but they are the same thing.

LRL H50

AVGH50 + 24.5 * (24.5 * H + 23.5 * H1 + 22.5 * H2 + 21.5 * H3 + 20.5 * H4 + 19.5 * H5 + 18.5 * H6 + 17.5 * H7 + 16.5 * H8 + 15.5 * H9 + 14.5 * H10 + 13.5 * H11 + 12.5 * H12 + 11.5 * H13 + 10.5 * H14 + 9.5 * H15 + 8.5 * H16 + 7.5 * H17 + 6.5 * H18 + 5.5 * H19 + 4.5 * H20 + 3.5 * H21 + 2.5 * H22 + 1.5 * H23 + 0.5 * H24 - 0.5 * H25 - 1.5 * H26 - 2.5 * H27 - 3.5 * H28 - 4.5 * H29 - 5.5 * H30 - 6.5 * H31 - 7.5 * H32 - 8.5 * H33 - 9.5 * H34 - 10.5 * H35 - 11.5 * H36 - 12.5 * H37 - 13.5 * H38 - 14.5 * H39 - 15.5 * H40 - 16.5 * H41 - 17.5 * H42 - 18.5 * H43 - 19.5 * H44 - 20.5 * H45 - 21.5 * H46 - 22.5 * H47 - 23.5 * H48 - 24.5 * H49) / 10412.5

LRL H50.1

AVGH50.1 + 24.5 * (24.5 * H1 + 23.5 * H2 + 22.5 * H3 + 21.5 * H4 + 20.5 * H5 + 19.5 * H6 + 18.5 * H7 + 17.5 * H8 + 16.5 * H9 + 15.5 * H10 + 14.5 * H11 + 13.5 * H12 + 12.5 * H13 + 11.5 * H14 + 10.5 * H15 + 9.5 * H16 + 8.5 * H17 + 7.5 * H18 + 6.5 * H19 + 5.5 * H20 + 4.5 * H21 + 3.5 * H22 + 2.5 * H23 + 1.5 * H24 + 0.5 * H25 - 0.5 * H26 - 1.5 * H27 - 2.5 * H28 - 3.5 * H29 - 4.5 * H30 - 5.5 * H31 - 6.5 * H32 - 7.5 * H33 - 8.5 * H34 - 9.5 * H35 - 10.5 * H36 - 11.5 * H37 - 12.5 * H38 - 13.5 * H39 - 14.5 * H40 - 15.5 * H41 - 16.5 * H42 - 17.5 * H43 - 18.5 * H44 - 19.5 * H45 - 20.5 * H46 - 21.5 * H47 - 22.5 * H48 - 23.5 * H49 - 24.5 * H50) / 10412.5

LRL L50

AVGL50 + 24.5 * (24.5 * L + 23.5 * L1 + 22.5 * L2 + 21.5 * L3 + 20.5 * L4 + 19.5 * L5 + 18.5 * L6 + 17.5 * L7 + 16.5 * L8 + 15.5 * L9 + 14.5 * L10 + 13.5 * L11 + 12.5 * L12 + 11.5 * L13 + 10.5 * L14 + 9.5 * L15 + 8.5 * L16 + 7.5 * L17 + 6.5 * L18 + 5.5 * L19 + 4.5 * L20 + 3.5 * L21 + 2.5 * L22 + 1.5 * L23 + 0.5 * L24 - 0.5 * L25 - 1.5 * L26 - 2.5 * L27 - 3.5 * L28 - 4.5 * L29 - 5.5 * L30 - 6.5 * L31 - 7.5 * L32 - 8.5 * L33 - 9.5 * L34 - 10.5 * L35 - 11.5 * L36 - 12.5 * L37 - 13.5 * L38 - 14.5 * L39 - 15.5 * L40 - 16.5 * L41 - 17.5 * L42 - 18.5 * L43 - 19.5 * L44 - 20.5 * L45 - 21.5 * L46 - 22.5 * L47 - 23.5 * L48 - 24.5 * L49) / 10412.5

LRL L50.1

AVGL50.1 + 24.5 * (24.5 * L1 + 23.5 * L2 + 22.5 * L3 + 21.5 * L4 + 20.5 * L5 + 19.5 * L6 + 18.5 * L7 + 17.5 * L8 + 16.5 * L9 + 15.5 * L10 + 14.5 * L11 + 13.5 * L12 + 12.5 * L13 + 11.5 * L14 + 10.5 * L15 + 9.5 * L16 + 8.5 * L17 + 7.5 * L18 + 6.5 * L19 + 5.5 * L20 + 4.5 * L21 + 3.5 * L22 + 2.5 * L23 + 1.5 * L24 + 0.5 * L25 - 0.5 * L26 - 1.5 * L27 - 2.5 * L28 - 3.5 * L29 - 4.5 * L30 - 5.5 * L31 - 6.5 * L32 - 7.5 * L33 - 8.5 * L34 - 9.5 * L35 - 10.5 * L36 - 11.5 * L37 - 12.5 * L38 - 13.5 * L39 - 14.5 * L40 - 15.5 * L41 - 16.5 * L42 - 17.5 * L43 - 18.5 * L44 - 19.5 * L45 - 20.5 * L46 - 21.5 * L47 - 22.5 * L48 - 23.5 * L49 - 24.5 * L50) / 10412.5

LRL H100

AVGH100 + 49.5 * (49.5 * H + 48.5 * H1 + 47.5 * H2 + 46.5 * H3 + 45.5 * H4 + 44.5 * H5 + 43.5 * H6 + 42.5 * H7 + 41.5 * H8 + 40.5 * H9 + 39.5 * H10 + 38.5 * H11 + 37.5 * H12 + 36.5 * H13 + 35.5 * H14 + 34.5 * H15 + 33.5 * H16 + 32.5 * H17 + 31.5 * H18 + 30.5 * H19 + 29.5 * H20 + 28.5 * H21 + 27.5 * H22 + 26.5 * H23 + 25.5 * H24 + 24.5 * H25 + 23.5 * H26 + 22.5 * H27 + 21.5 * H28 + 20.5 * H29 + 19.5 * H30 + 18.5 * H31 + 17.5 * H32 + 16.5 * H33 + 15.5 * H34 + 14.5 * H35 + 13.5 * H36 + 12.5 * H37 + 11.5 * H38 + 10.5 * H39 + 9.5 * H40 + 8.5 * H41 + 7.5 * H42 + 6.5 * H43 + 5.5 * H44 + 4.5 * H45 + 3.5 * H46 + 2.5 * H47 + 1.5 * H48 + 0.5 * H49 - 0.5 * H50 - 1.5 * H51 - 2.5 * H52 - 3.5 * H53 - 4.5 * H54 - 5.5 * H55 - 6.5 * H56 - 7.5 * H57 - 8.5 * H58 - 9.5 * H59 - 10.5 * H60 - 11.5 * H61 - 12.5 * H62 - 13.5 * H63 - 14.5 * H64 - 15.5 * H65 - 16.5 * H66 - 17.5 * H67 - 18.5 * H68 - 19.5 * H69 - 20.5 * H70 - 21.5 * H71 - 22.5 * H72 - 23.5 * H73 - 24.5 * H74 - 25.5 * H75 - 26.5 * H76 - 27.5 * H77 - 28.5 * H78 - 29.5 * H79 - 30.5 * H80 - 31.5 * H81 - 32.5 * H82 - 33.5 * H83 - 34.5 * H84 - 35.5 * H85 - 36.5 * H86 - 37.5 * H87 - 38.5 * H88 - 39.5 * H89 - 40.5 * H90 - 41.5 * H91 - 42.5 * H92 - 43.5 * H93 - 44.5 * H94 - 45.5 * H95 - 46.5 * H96 - 47.5 * H97 - 48.5 * H98 - 49.5 * H99) / 83325

LRL H100.1

AVGH100.1 + 49.5 * (49.5 * H1 + 48.5 * H2 + 47.5 * H3 + 46.5 * H4 + 45.5 * H5 + 44.5 * H6 + 43.5 * H7 + 42.5 * H8 + 41.5 * H9 + 40.5 * H10 + 39.5 * H11 + 38.5 * H12 + 37.5 * H13 + 36.5 * H14 + 35.5 * H15 + 34.5 * H16 + 33.5 * H17 + 32.5 * H18 + 31.5 * H19 + 30.5 * H20 + 29.5 * H21 + 28.5 * H22 + 27.5 * H23 + 26.5 * H24 + 25.5 * H25 + 24.5 * H26 + 23.5 * H27 + 22.5 * H28 + 21.5 * H29 + 20.5 * H30 + 19.5 * H31 + 18.5 * H32 + 17.5 * H33 + 16.5 * H34 + 15.5 * H35 + 14.5 * H36 + 13.5 * H37 + 12.5 * H38 + 11.5 * H39 + 10.5 * H40 + 9.5 * H41 + 8.5 * H42 + 7.5 * H43 + 6.5 * H44 + 5.5 * H45 + 4.5 * H46 + 3.5 * H47 + 2.5 * H48 + 1.5 * H49 + 0.5 * H50 - 0.5 * H51 - 1.5 * H52 - 2.5 * H53 - 3.5 * H54 - 4.5 * H55 - 5.5 * H56 - 6.5 * H57 - 7.5 * H58 - 8.5 * H59 - 9.5 * H60 - 10.5 * H61 - 11.5 * H62 - 12.5 * H63 - 13.5 * H64 - 14.5 * H65 - 15.5 * H66 - 16.5 * H67 - 17.5 * H68 - 18.5 * H69 - 19.5 * H70 - 20.5 * H71 - 21.5 * H72 - 22.5 * H73 - 23.5 * H74 - 24.5 * H75 - 25.5 * H76 - 26.5 * H77 - 27.5 * H78 - 28.5 * H79 - 29.5 * H80 - 30.5 * H81 - 31.5 * H82 - 32.5 * H83 - 33.5 * H84 - 34.5 * H85 - 35.5 * H86 - 36.5 * H87 - 37.5 * H88 - 38.5 * H89 - 39.5 * H90 - 40.5 * H91 - 41.5 * H92 - 42.5 * H93 - 43.5 * H94 - 44.5 * H95 - 45.5 * H96 - 46.5 * H97 - 47.5 * H98 - 48.5 * H99 - 49.5 * H100) / 83325

LRL L100

AVGL100 + 49.5 * (49.5 * L + 48.5 * L1 + 47.5 * L2 + 46.5 * L3 + 45.5 * L4 + 44.5 * L5 + 43.5 * L6 + 42.5 * L7 + 41.5 * L8 + 40.5 * L9 + 39.5 * L10 + 38.5 * L11 + 37.5 * L12 + 36.5 * L13 + 35.5 * L14 + 34.5 * L15 + 33.5 * L16 + 32.5 * L17 + 31.5 * L18 + 30.5 * L19 + 29.5 * L20 + 28.5 * L21 + 27.5 * L22 + 26.5 * L23 + 25.5 * L24 + 24.5 * L25 + 23.5 * L26 + 22.5 * L27 + 21.5 * L28 + 20.5 * L29 + 19.5 * L30 + 18.5 * L31 + 17.5 * L32 + 16.5 * L33 + 15.5 * L34 + 14.5 * L35 + 13.5 * L36 + 12.5 * L37 + 11.5 * L38 + 10.5 * L39 + 9.5 * L40 + 8.5 * L41 + 7.5 * L42 + 6.5 * L43 + 5.5 * L44 + 4.5 * L45 + 3.5 * L46 + 2.5 * L47 + 1.5 * L48 + 0.5 * L49 - 0.5 * L50 - 1.5 * L51 - 2.5 * L52 - 3.5 * L53 - 4.5 * L54 - 5.5 * L55 - 6.5 * L56 - 7.5 * L57 - 8.5 * L58 - 9.5 * L59 - 10.5 * L60 - 11.5 * L61 - 12.5 * L62 - 13.5 * L63 - 14.5 * L64 - 15.5 * L65 - 16.5 * L66 - 17.5 * L67 - 18.5 * L68 - 19.5 * L69 - 20.5 * L70 - 21.5 * L71 - 22.5 * L72 - 23.5 * L73 - 24.5 * L74 - 25.5 * L75 - 26.5 * L76 - 27.5 * L77 - 28.5 * L78 - 29.5 * L79 - 30.5 * L80 - 31.5 * L81 - 32.5 * L82 - 33.5 * L83 - 34.5 * L84 - 35.5 * L85 - 36.5 * L86 - 37.5 * L87 - 38.5 * L88 - 39.5 * L89 - 40.5 * L90 - 41.5 * L91 - 42.5 * L92 - 43.5 * L93 - 44.5 * L94 - 45.5 * L95 - 46.5 * L96 - 47.5 * L97 - 48.5 * L98 - 49.5 * L99) / 83325

LRL L100.1

AVGL100.1 + 49.5 * (49.5 * L1 + 48.5 * L2 + 47.5 * L3 + 46.5 * L4 + 45.5 * L5 + 44.5 * L6 + 43.5 * L7 + 42.5 * L8 + 41.5 * L9 + 40.5 * L10 + 39.5 * L11 + 38.5 * L12 + 37.5 * L13 + 36.5 * L14 + 35.5 * L15 + 34.5 * L16 + 33.5 * L17 + 32.5 * L18 + 31.5 * L19 + 30.5 * L20 + 29.5 * L21 + 28.5 * L22 + 27.5 * L23 + 26.5 * L24 + 25.5 * L25 + 24.5 * L26 + 23.5 * L27 + 22.5 * L28 + 21.5 * L29 + 20.5 * L30 + 19.5 * L31 + 18.5 * L32 + 17.5 * L33 + 16.5 * L34 + 15.5 * L35 + 14.5 * L36 + 13.5 * L37 + 12.5 * L38 + 11.5 * L39 + 10.5 * L40 + 9.5 * L41 + 8.5 * L42 + 7.5 * L43 + 6.5 * L44 + 5.5 * L45 + 4.5 * L46 + 3.5 * L47 + 2.5 * L48 + 1.5 * L49 + 0.5 * L50 - 0.5 * L51 - 1.5 * L52 - 2.5 * L53 - 3.5 * L54 - 4.5 * L55 - 5.5 * L56 - 6.5 * L57 - 7.5 * L58 - 8.5 * L59 - 9.5 * L60 - 10.5 * L61 - 11.5 * L62 - 12.5 * L63 - 13.5 * L64 - 14.5 * L65 - 15.5 * L66 - 16.5 * L67 - 17.5 * L68 - 18.5 * L69 - 19.5 * L70 - 20.5 * L71 - 21.5 * L72 - 22.5 * L73 - 23.5 * L74 - 24.5 * L75 - 25.5 * L76 - 26.5 * L77 - 27.5 * L78 - 28.5 * L79 - 29.5 * L80 - 30.5 * L81 - 31.5 * L82 - 32.5 * L83 - 33.5 * L84 - 34.5 * L85 - 35.5 * L86 - 36.5 * L87 - 37.5 * L88 - 38.5 * L89 - 39.5 * L90 - 40.5 * L91 - 41.5 * L92 - 42.5 * L93 - 43.5 * L94 - 44.5 * L95 - 45.5 * L96 - 46.5 * L97 - 47.5 * L98 - 48.5 * L99 - 49.5 * L100) / 83325

Back to the VWAP - your statement of

"A note on your VWAP formulas. Your first one just works out to the following. AVGV3

And your second one just works out to the following. AVGV3.1"  

IS INCORRECT

My formula's results produce $ figures not Volume amounts

Your Basic formula is ( C * V ) .  My Basic Formula is (( C * V ) / V )

I just mis-typed. Your first formulas just returns AVGC3 and your second formula just returns AVGC3.1. This has been corrected above. It is still probably not what you intended or actually want.

Think about it this way.

(C * V) / V

Is the same thing as:

C * V / V

Or:

C * 1

Or:

C

MoreAces

I suspect you wanted something lke this:

(C*V+C1*V1+C2*V2)/(AVGV3*3)

Thanks

diceman

This is actually the formula, I was looking for a shorter way to say it (may not be a shorter version)

( ( ((((C*V) / V) + ((C1*V1) / V1) + ((C2*V2) / V2)) / 3) +

((((C1*V1) / V1) + ((C2*V2) / V2) + ((C3*V3) / V3)) / 3) +

((((C2*V2) / V2) + ((C3*V3) / V3) + ((C4*V4) / V4)) / 3) ) / 3 ) 

But thanks for the input

Did you see Bruce's post above mine?

You're not using volume at all.

Your PCF is the same as:

(AVGC3+AVGC3.1+AVGC3.2)/3

Thanks

diceman

OK create a pcf with my formula and your formula and see if you get the same answer if so, then I guess you and bruce are correct

MY FORMULA

((((C*V) / V) + ((C1*V1) / V1) + ((C2*V2) / V2)) / 3)

YOUR FORMULA

(AVGC3+AVGC3.1+AVGC3.2)/3

Id guess what you want is a 3 period simple  moving average on my formula.

Thanks

diceman

The volume one not the avgc3.

I see now thanks

Bruce i would like to covert my formulas on these to new  syntax 

Bruce the next 2 post as well

LRL H20 1 Bar Ago

(AVGH20.1 + 19 * (19 * (H1 - H20) + 17 * (H2 - H19) + 15 * (H3 - H18) + 13 * (H4 - H17) + 11 * (H5 - H16) + 9 * (H6 - H15) + 7 * (H7 - H14) + 5 * (H8 - H13) + 3 * (H9 - H12) + H10 - H11) / 2660)

LRL L20 1 Bar Ago

(AVGL20.1 + 19 * (19 * (L1 - L20) + 17 * (L2 - L19) + 15 * (L3 - L18) + 13 * (L4 - L17) + 11 * (L5 - L16) + 9 * (L6 - L15) + 7 * (L7 - L14) + 5 * (L8 - L13) + 3 * (L9 - L12) + L10 - L11) / 2660)

Thanks

LRL H20

(AVGH20 + 19 * (19 * (H - H19) + 17 * (H1 - H18) + 15 * (H2 - H17) + 13 * (H3 - H16) + 11 * (H4 - H15) + 9 * (H5 - H14) + 7 * (H6 - H13) + 5 * (H7 - H12) + 3 * (H8 - H11) + H9 - H10) / 2660 )

LRL L20

(AVGL20 + 19 * (19 * (L - L19) + 17 * (L1 - L18) + 15 * (L2 - L17) + 13 * (L3 - L16) + 11 * (L4 - L15) + 9 * (L5 - L14) + 7 * (L6 - L13) + 5 * (L7 - L12) + 3 * (L8 - L11) + L9 - L10) / 2660 )

I have a couple of volume i would like reduced to new syntax too

10 Bar Dollar Volume

C * V > C1 * V1 AND C * V > C2 * V2 AND C * V > C3 * V3 AND C * V > C4 * V4 AND C * V > C5 * V5 AND C * V > C6 * V6 AND C * V > C7 * V7 AND C * V > C8 * V8 AND C * V > C9 * V9

15 Bar Dollar Volume

C * V > C1 * V1 AND C * V > C2 * V2 AND C * V > C3 * V3 AND C * V > C4 * V4 AND C * V > C5 * V5 AND C * V > C6 * V6 AND C * V > C7 * V7 AND C * V > C8 * V8 AND C * V > C9 * V9 AND C * V > C10 * V10 AND C * V > C11 * V11 AND C * V > C12 * V12 AND C * V > C13 * V13 AND C * V > C14 * V14

Thanks

on the dollar volume i need the 10 for

10 Bar Current Bar

10 Bar 1 Bar Ago

10 Bar 2 Bars Ago

thanks

LRL H50:

3 * FAVGH50 - 2 * AVGH50

LRL H50.1

3 * FAVGH50.1 - 2 * AVGH50.1

LRL L50

3 * FAVGL50 - 2 * AVGL50

LRL L50.1

3 * FAVGL50.1 - 2 * AVGL50.1

LRL H100

3 * FAVGH100 - 2 * AVGH50

LRL H100.1

3 * FAVGH100.1 - 2 * AVGH50.1

LRL L100

3 * FAVGL100 - 2 * AVGL100

LRL L100.1

3 * FAVGL100.1 - 2 * AVGL100.1

LRL H20

3 * FAVGH20 - 2 * AVGH20

LRL H20.1

3 * FAVGH20.1 - 2 * AVGH20.1

LRL L20

3 * FAVGL20 - 2 * AVGL20

LRL L20.1

3 * FAVGL20.1 - 2 * AVGL20.1

10 Bar Dollar Volume:

C * V > MAX(C1 * V1, 9)

10 Bar Dollar Volume (1 bar ago):

C1 * V1 > MAX(C2 * V2, 9)

10 Bar Dollar Volume (2 bars ago):

C2 * V2 > MAX(C3 * V3, 9)

15 Bar Dollar Volume:

C * V > MAX(C1 * V1, 14)

15 Bar Dollar Volume (1 bar ago):

C1 * V1 > MAX(C2 * V2, 14)

15 Bar Dollar Volume (2 bars ago):

C2 * V2 > MAX(C3 * V3, 14)

Thanks alot

I forgot i dot actually have the standard

Linear regression formula (not high not low normal)

Current and1 bar ago

Just replace the H or L with a C instead. You can do that using the replace function in a text editor. The pattern for the TC2000 v17 versions should be pretty obvious after looking at a few of the formulas.

LRL C50:

3 * FAVGC50 - 2 * AVGC50

LRL C50.1

3 * FAVGC50.1 - 2 * AVGC50.1

LRL C100

3 * FAVGC100 - 2 * AVGC50

LRL C100.1

3 * FAVGC100.1 - 2 * AVGC50.1

LRL C20

3 * FAVGC20 - 2 * AVGC20

LRL C20.1

3 * FAVGC20.1 - 2 * AVGC20.1