Registered User Joined: 8/23/2013 Posts: 245
|
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
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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 )
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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 Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/3/2013 Posts: 57
|
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!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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 Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
LOL that was quick, Thanks
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
QUOTE (MoreAces)
THANKS
CAN YOU PRODUCE THESE FOR 50 PERIOD AND 100 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
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)
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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 )
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
MoreAces
I suspect you wanted something lke this:
(C*V+C1*V1+C2*V2)/(AVGV3*3)
Thanks
diceman
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
QUOTE (MoreAces)
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
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
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
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
QUOTE (MoreAces)
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
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
The volume one not the avgc3.
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
I see now thanks
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
QUOTE (Bruce_L)
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
Bruce i would like to covert my formulas on these to new syntax
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
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)
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
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 )
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
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
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
on the dollar volume i need the 10 for
10 Bar Current Bar
10 Bar 1 Bar Ago
10 Bar 2 Bars Ago
thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
Thanks alot
I forgot i dot actually have the standard
Linear regression formula (not high not low normal)
Current and1 bar ago
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |