Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Moving Linear Regression Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
MoreAces
Posted : Tuesday, October 7, 2014 10:02:53 PM
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

MoreAces
Posted : Wednesday, October 8, 2014 8:35:16 PM
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 )

Bruce_L
Posted : Thursday, October 9, 2014 9:53:16 AM


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
stochastics
Posted : Thursday, March 5, 2015 2:07:36 AM
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! 

Bruce_L
Posted : Thursday, March 5, 2015 10:31:04 AM


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
MoreAces
Posted : Friday, January 29, 2016 8:03:07 AM
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

 

Bruce_L
Posted : Friday, January 29, 2016 10:05:51 AM


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
MoreAces
Posted : Friday, January 29, 2016 12:55:59 PM
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

Bruce_L
Posted : Friday, January 29, 2016 1:08:33 PM


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
MoreAces
Posted : Friday, January 29, 2016 1:14:43 PM
Registered User
Joined: 8/23/2013
Posts: 245


LOL that was quick, Thanks

 

MoreAces
Posted : Friday, January 29, 2016 2:39:09 PM
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)

Bruce_L
Posted : Friday, January 29, 2016 2:54:50 PM


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
MoreAces
Posted : Saturday, January 30, 2016 5:05:54 PM
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 )

 

Bruce_L
Posted : Monday, February 1, 2016 11:24:45 AM


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
diceman
Posted : Monday, February 1, 2016 1:51:53 PM
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

 

 

MoreAces
Posted : Saturday, February 6, 2016 8:36:00 AM
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

diceman
Posted : Saturday, February 6, 2016 9:12:48 AM
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

MoreAces
Posted : Saturday, February 6, 2016 12:32:41 PM
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

diceman
Posted : Saturday, February 6, 2016 4:08:03 PM
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

 

diceman
Posted : Saturday, February 6, 2016 4:09:11 PM
Registered User
Joined: 1/28/2005
Posts: 6,049

The volume one not the avgc3.

MoreAces
Posted : Saturday, February 6, 2016 11:48:22 PM
Registered User
Joined: 8/23/2013
Posts: 245

I see now thanks

Aces4Me
Posted : Saturday, February 4, 2017 3:33:33 PM
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 

 
Aces4Me
Posted : Saturday, February 4, 2017 3:35:30 PM
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)

Aces4Me
Posted : Saturday, February 4, 2017 3:36:46 PM
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 )

Aces4Me
Posted : Saturday, February 4, 2017 5:37:01 PM
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

Aces4Me
Posted : Saturday, February 4, 2017 5:48:05 PM
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

 

Bruce_L
Posted : Monday, February 6, 2017 10:08:39 AM


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
Aces4Me
Posted : Wednesday, February 8, 2017 8:36:13 AM
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

 

 

Bruce_L
Posted : Wednesday, February 8, 2017 7:58:11 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.