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 |

Fractal Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Macboy
Posted : Monday, June 4, 2012 7:02:21 PM
Registered User
Joined: 5/28/2012
Posts: 8

I am unable to find Fractals in the indicator library.

I would like to write a PCF for Fractals. This would be a 5 bar pattern where a swing high would have 2 lower highs on each side of the high, the high would be marked by an object like a triangle or dot just above its tip. The exact oppisite would apply for a swing low, where the low would have to lower lows each side of the low.

Bruce_L
Posted : Tuesday, June 5, 2012 7:18:27 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try using the following formula as a Custom PCF Indicator to identify the Fractal Highs on the chart:

H2 * ABS(H < H1 AND H1 < H2 AND H2 > H3 AND H3 > H4)

And the following formula as a Custom PCF Indicator to identify the Fractal Lows on the chart:

L2 * ABS(L > L1 AND L1 > L2 AND L2 < L3 AND L3 < L4)

You will probably want to change the Plot Style to Dot and Overlay and Scale the Custom PCF Indicators with Price History. The plots will occur when the Fractals have been identified. The indicator will not plot in the center of the Fractal.

What's New in TC2000 version 12.2



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Macboy
Posted : Tuesday, June 5, 2012 10:03:27 PM
Registered User
Joined: 5/28/2012
Posts: 8

Bruce,

It's plotting the dot 2 bars to the right instead of above the high.

It's also missing some conitions especially to the far right of the chart.

Bruce_L
Posted : Wednesday, June 6, 2012 7:53:35 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

QUOTE (Macboy)
It's plotting the dot 2 bars to the right instead of above the high.

Yes. That's what "The plots will occur when the Fractals have been identified. The indicator will not plot in the center of the Fractal." means.

This is because the Personal Criteria Formula Language does not have syntax for negative offsets which would reference future values.

The only way I can think of to get the dot to appear at the center of the pattern would be to add a 1-Period Simple Moving Average with an Offset of -2 to the Custom PCF Indicators. You would probably want to set the Opacity of the Custom PCF Indicators to zero (all the way to the left) and set the Plot Style of the Moving Averages to Dots. 

QUOTE (Macboy)
It's also missing some conitions especially to the far right of the chart.

The formulas in my Tuesday, June 05, 2012 7:18:27 AM ET post require a "V" type pattern for the highs or lows. I suspect you actually want to only compare the central high or low against the surrounding highs or lows. If so, please try the following Fractal High formula instead:

H2 * ABS(H < H2 AND H1 < H2 AND H2 > H3 AND H2 > H4)

And the following Fractal Low formula instead:

L2 * ABS(L > L2 AND L1 > L2 AND L2 < L3 AND L2 < L4)

You can compare the new formulas to the old formulas to see how they differ in more detail.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Macboy
Posted : Sunday, June 10, 2012 11:20:35 PM
Registered User
Joined: 5/28/2012
Posts: 8

 

Thank you Bruce this is the version of Fractals that I&rsquo;m looking for.

Now that we&rsquo;ve established this, let me explain to you what I really want.

 

I like to keep my currency pairs in a workspace for every pair I watch, comprising of four charts, a daily, 4 hour, 1 hour and 15 minute.

I start with the Daily and switch it to Monthly and apply my Fractal Indicator, I mark the closest fractal above price with red horizontal line on the tip of the swing low. I then mark the closest fractal below price with a red horizontal line on the tip of the swing high.

I then switch the chart to weekly and mark the closet fractal above price on the tip of the swing low with a blue horizontal line, sometimes the weekly fractal is the same as the monthly so the higher timeframe would take priority with a red horizontal line. The same procedure applies for the closest fractal below price.

I then switch to a Daily and apply the same process with black horizontal lines.

I then move to my 4-hour chart and mark the closest fractal above and below price with dashed horizontal lines and this is as far as I go.

 

I have my charts programmed so the lines appear on all the four timeframes so on my 15 minute chart where I execute my entries, in a perfect situation I would see dashed horizontal lines either side of price showing 4 hour fractals, then black horizontal lines either side of price showing daily fractals, then blue horizontal lines either side of price showing weekly fractals and so on and so forth.

 

The problem is when price moves through one of these lines the other line has to be adjusted to keep the colors above and below price.

This is a time consuming procedure as I am following 10 currency pairs and I can only really do it effectively with 4 pairs.

 

The big question is can a PCF be written to do this automatically?

In my opinion this would be an excellent indicator as its pretty amazing watching price react of these lines and various strategies can be implemented around this system.

 

 

 

 

 

 

 

 

Bruce_L
Posted : Monday, June 11, 2012 8:23:18 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

While it is probably possible to calculate and indicate fractal levels this way in StockFinder, I cannot think of an automated method of doing this in TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Macboy
Posted : Monday, June 11, 2012 10:42:36 PM
Registered User
Joined: 5/28/2012
Posts: 8

Does StockFinder provide the FX Markets?

StockGuy
Posted : Monday, June 11, 2012 10:43:44 PM

Administration

Joined: 9/30/2004
Posts: 9,187

No, Forex markets are available in TC2000, but not StockFinder.

zh_mingbo
Posted : Thursday, June 14, 2012 1:16:13 AM
Registered User
Joined: 11/16/2011
Posts: 1

does tc2000 gold provide the real-time forex data, and which data source is the provider, fxcm? interactive broker?

StockGuy
Posted : Thursday, June 14, 2012 12:24:41 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Yes, real time forex data is in Gold from CMS Forex.

f.lb
Posted : Thursday, February 11, 2016 11:55:43 AM
Registered User
Joined: 4/3/2012
Posts: 56

Could it be possible that instead of a triangle a flat line appears along the chart from that point?

Bruce_L
Posted : Thursday, February 11, 2016 12:21:23 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If I'm understanding correctly, you could do this using the technique given in the Days Since Last Peak (or other day-counting needs) topic. The following Indicator Formulas allow the Fractal to be up to 84 bars in the past.

The Fractal High would be the following.

ABS(H < H1 AND H1 < H2 AND H2 > H3 AND H3 > H4) * H2 + ABS(H >= H1 OR H1 >= H2 OR H2 <= H3 OR H3 <= H4) * (ABS(H1 < H2 AND H2 < H3 AND H3 > H4 AND H4 > H5) * H3 + ABS(H1 >= H2 OR H2 >= H3 OR H3 <= H4 OR H4 <= H5) * (ABS(H2 < H3 AND H3 < H4 AND H4 > H5 AND H5 > H6) * H4 + ABS(H2 >= H3 OR H3 >= H4 OR H4 <= H5 OR H5 <= H6) * (ABS(H3 < H4 AND H4 < H5 AND H5 > H6 AND H6 > H7) * H5 + ABS(H3 >= H4 OR H4 >= H5 OR H5 <= H6 OR H6 <= H7) * (ABS(H4 < H5 AND H5 < H6 AND H6 > H7 AND H7 > H8) * H6 + ABS(H4 >= H5 OR H5 >= H6 OR H6 <= H7 OR H7 <= H8) * (ABS(H5 < H6 AND H6 < H7 AND H7 > H8 AND H8 > H9) * H7 + ABS(H5 >= H6 OR H6 >= H7 OR H7 <= H8 OR H8 <= H9) * (ABS(H6 < H7 AND H7 < H8 AND H8 > H9 AND H9 > H10) * H8 + ABS(H6 >= H7 OR H7 >= H8 OR H8 <= H9 OR H9 <= H10) * (ABS(H7 < H8 AND H8 < H9 AND H9 > H10 AND H10 > H11) * H9 + ABS(H7 >= H8 OR H8 >= H9 OR H9 <= H10 OR H10 <= H11) * (ABS(H8 < H9 AND H9 < H10 AND H10 > H11 AND H11 > H12) * H10 + ABS(H8 >= H9 OR H9 >= H10 OR H10 <= H11 OR H11 <= H12) * (ABS(H9 < H10 AND H10 < H11 AND H11 > H12 AND H12 > H13) * H11 + ABS(H9 >= H10 OR H10 >= H11 OR H11 <= H12 OR H12 <= H13) * (ABS(H10 < H11 AND H11 < H12 AND H12 > H13 AND H13 > H14) * H12 + ABS(H10 >= H11 OR H11 >= H12 OR H12 <= H13 OR H13 <= H14) * (ABS(H11 < H12 AND H12 < H13 AND H13 > H14 AND H14 > H15) * H13 + ABS(H11 >= H12 OR H12 >= H13 OR H13 <= H14 OR H14 <= H15) * (ABS(H12 < H13 AND H13 < H14 AND H14 > H15 AND H15 > H16) * H14 + ABS(H12 >= H13 OR H13 >= H14 OR H14 <= H15 OR H15 <= H16) * (ABS(H13 < H14 AND H14 < H15 AND H15 > H16 AND H16 > H17) * H15 + ABS(H13 >= H14 OR H14 >= H15 OR H15 <= H16 OR H16 <= H17) * (ABS(H14 < H15 AND H15 < H16 AND H16 > H17 AND H17 > H18) * H16 + ABS(H14 >= H15 OR H15 >= H16 OR H16 <= H17 OR H17 <= H18) * (ABS(H15 < H16 AND H16 < H17 AND H17 > H18 AND H18 > H19) * H17 + ABS(H15 >= H16 OR H16 >= H17 OR H17 <= H18 OR H18 <= H19) * (ABS(H16 < H17 AND H17 < H18 AND H18 > H19 AND H19 > H20) * H18 + ABS(H16 >= H17 OR H17 >= H18 OR H18 <= H19 OR H19 <= H20) * (ABS(H17 < H18 AND H18 < H19 AND H19 > H20 AND H20 > H21) * H19 + ABS(H17 >= H18 OR H18 >= H19 OR H19 <= H20 OR H20 <= H21) * (ABS(H18 < H19 AND H19 < H20 AND H20 > H21 AND H21 > H22) * H20 + ABS(H18 >= H19 OR H19 >= H20 OR H20 <= H21 OR H21 <= H22) * (ABS(H19 < H20 AND H20 < H21 AND H21 > H22 AND H22 > H23) * H21 + ABS(H19 >= H20 OR H20 >= H21 OR H21 <= H22 OR H22 <= H23) * (ABS(H20 < H21 AND H21 < H22 AND H22 > H23 AND H23 > H24) * H22 + ABS(H20 >= H21 OR H21 >= H22 OR H22 <= H23 OR H23 <= H24) * (ABS(H21 < H22 AND H22 < H23 AND H23 > H24 AND H24 > H25) * H23 + ABS(H21 >= H22 OR H22 >= H23 OR H23 <= H24 OR H24 <= H25) * (ABS(H22 < H23 AND H23 < H24 AND H24 > H25 AND H25 > H26) * H24 + ABS(H22 >= H23 OR H23 >= H24 OR H24 <= H25 OR H25 <= H26) * (ABS(H23 < H24 AND H24 < H25 AND H25 > H26 AND H26 > H27) * H25 + ABS(H23 >= H24 OR H24 >= H25 OR H25 <= H26 OR H26 <= H27) * (ABS(H24 < H25 AND H25 < H26 AND H26 > H27 AND H27 > H28) * H26 + ABS(H24 >= H25 OR H25 >= H26 OR H26 <= H27 OR H27 <= H28) * (ABS(H25 < H26 AND H26 < H27 AND H27 > H28 AND H28 > H29) * H27 + ABS(H25 >= H26 OR H26 >= H27 OR H27 <= H28 OR H28 <= H29) * (ABS(H26 < H27 AND H27 < H28 AND H28 > H29 AND H29 > H30) * H28 + ABS(H26 >= H27 OR H27 >= H28 OR H28 <= H29 OR H29 <= H30) * (ABS(H27 < H28 AND H28 < H29 AND H29 > H30 AND H30 > H31) * H29 + ABS(H27 >= H28 OR H28 >= H29 OR H29 <= H30 OR H30 <= H31) * (ABS(H28 < H29 AND H29 < H30 AND H30 > H31 AND H31 > H32) * H30 + ABS(H28 >= H29 OR H29 >= H30 OR H30 <= H31 OR H31 <= H32) * (ABS(H29 < H30 AND H30 < H31 AND H31 > H32 AND H32 > H33) * H31 + ABS(H29 >= H30 OR H30 >= H31 OR H31 <= H32 OR H32 <= H33) * (ABS(H30 < H31 AND H31 < H32 AND H32 > H33 AND H33 > H34) * H32 + ABS(H30 >= H31 OR H31 >= H32 OR H32 <= H33 OR H33 <= H34) * (ABS(H31 < H32 AND H32 < H33 AND H33 > H34 AND H34 > H35) * H33 + ABS(H31 >= H32 OR H32 >= H33 OR H33 <= H34 OR H34 <= H35) * (ABS(H32 < H33 AND H33 < H34 AND H34 > H35 AND H35 > H36) * H34 + ABS(H32 >= H33 OR H33 >= H34 OR H34 <= H35 OR H35 <= H36) * (ABS(H33 < H34 AND H34 < H35 AND H35 > H36 AND H36 > H37) * H35 + ABS(H33 >= H34 OR H34 >= H35 OR H35 <= H36 OR H36 <= H37) * (ABS(H34 < H35 AND H35 < H36 AND H36 > H37 AND H37 > H38) * H36 + ABS(H34 >= H35 OR H35 >= H36 OR H36 <= H37 OR H37 <= H38) * (ABS(H35 < H36 AND H36 < H37 AND H37 > H38 AND H38 > H39) * H37 + ABS(H35 >= H36 OR H36 >= H37 OR H37 <= H38 OR H38 <= H39) * (ABS(H36 < H37 AND H37 < H38 AND H38 > H39 AND H39 > H40) * H38 + ABS(H36 >= H37 OR H37 >= H38 OR H38 <= H39 OR H39 <= H40) * (ABS(H37 < H38 AND H38 < H39 AND H39 > H40 AND H40 > H41) * H39 + ABS(H37 >= H38 OR H38 >= H39 OR H39 <= H40 OR H40 <= H41) * (ABS(H38 < H39 AND H39 < H40 AND H40 > H41 AND H41 > H42) * H40 + ABS(H38 >= H39 OR H39 >= H40 OR H40 <= H41 OR H41 <= H42) * (ABS(H39 < H40 AND H40 < H41 AND H41 > H42 AND H42 > H43) * H41 + ABS(H39 >= H40 OR H40 >= H41 OR H41 <= H42 OR H42 <= H43) * (ABS(H40 < H41 AND H41 < H42 AND H42 > H43 AND H43 > H44) * H42 + ABS(H40 >= H41 OR H41 >= H42 OR H42 <= H43 OR H43 <= H44) * (ABS(H41 < H42 AND H42 < H43 AND H43 > H44 AND H44 > H45) * H43 + ABS(H41 >= H42 OR H42 >= H43 OR H43 <= H44 OR H44 <= H45) * (ABS(H42 < H43 AND H43 < H44 AND H44 > H45 AND H45 > H46) * H44 + ABS(H42 >= H43 OR H43 >= H44 OR H44 <= H45 OR H45 <= H46) * (ABS(H43 < H44 AND H44 < H45 AND H45 > H46 AND H46 > H47) * H45 + ABS(H43 >= H44 OR H44 >= H45 OR H45 <= H46 OR H46 <= H47) * (ABS(H44 < H45 AND H45 < H46 AND H46 > H47 AND H47 > H48) * H46 + ABS(H44 >= H45 OR H45 >= H46 OR H46 <= H47 OR H47 <= H48) * (ABS(H45 < H46 AND H46 < H47 AND H47 > H48 AND H48 > H49) * H47 + ABS(H45 >= H46 OR H46 >= H47 OR H47 <= H48 OR H48 <= H49) * (ABS(H46 < H47 AND H47 < H48 AND H48 > H49 AND H49 > H50) * H48 + ABS(H46 >= H47 OR H47 >= H48 OR H48 <= H49 OR H49 <= H50) * (ABS(H47 < H48 AND H48 < H49 AND H49 > H50 AND H50 > H51) * H49 + ABS(H47 >= H48 OR H48 >= H49 OR H49 <= H50 OR H50 <= H51) * (ABS(H48 < H49 AND H49 < H50 AND H50 > H51 AND H51 > H52) * H50 + ABS(H48 >= H49 OR H49 >= H50 OR H50 <= H51 OR H51 <= H52) * (ABS(H49 < H50 AND H50 < H51 AND H51 > H52 AND H52 > H53) * H51 + ABS(H49 >= H50 OR H50 >= H51 OR H51 <= H52 OR H52 <= H53) * (ABS(H50 < H51 AND H51 < H52 AND H52 > H53 AND H53 > H54) * H52 + ABS(H50 >= H51 OR H51 >= H52 OR H52 <= H53 OR H53 <= H54) * (ABS(H51 < H52 AND H52 < H53 AND H53 > H54 AND H54 > H55) * H53 + ABS(H51 >= H52 OR H52 >= H53 OR H53 <= H54 OR H54 <= H55) * (ABS(H52 < H53 AND H53 < H54 AND H54 > H55 AND H55 > H56) * H54 + ABS(H52 >= H53 OR H53 >= H54 OR H54 <= H55 OR H55 <= H56) * (ABS(H53 < H54 AND H54 < H55 AND H55 > H56 AND H56 > H57) * H55 + ABS(H53 >= H54 OR H54 >= H55 OR H55 <= H56 OR H56 <= H57) * (ABS(H54 < H55 AND H55 < H56 AND H56 > H57 AND H57 > H58) * H56 + ABS(H54 >= H55 OR H55 >= H56 OR H56 <= H57 OR H57 <= H58) * (ABS(H55 < H56 AND H56 < H57 AND H57 > H58 AND H58 > H59) * H57 + ABS(H55 >= H56 OR H56 >= H57 OR H57 <= H58 OR H58 <= H59) * (ABS(H56 < H57 AND H57 < H58 AND H58 > H59 AND H59 > H60) * H58 + ABS(H56 >= H57 OR H57 >= H58 OR H58 <= H59 OR H59 <= H60) * (ABS(H57 < H58 AND H58 < H59 AND H59 > H60 AND H60 > H61) * H59 + ABS(H57 >= H58 OR H58 >= H59 OR H59 <= H60 OR H60 <= H61) * (ABS(H58 < H59 AND H59 < H60 AND H60 > H61 AND H61 > H62) * H60 + ABS(H58 >= H59 OR H59 >= H60 OR H60 <= H61 OR H61 <= H62) * (ABS(H59 < H60 AND H60 < H61 AND H61 > H62 AND H62 > H63) * H61 + ABS(H59 >= H60 OR H60 >= H61 OR H61 <= H62 OR H62 <= H63) * (ABS(H60 < H61 AND H61 < H62 AND H62 > H63 AND H63 > H64) * H62 + ABS(H60 >= H61 OR H61 >= H62 OR H62 <= H63 OR H63 <= H64) * (ABS(H61 < H62 AND H62 < H63 AND H63 > H64 AND H64 > H65) * H63 + ABS(H61 >= H62 OR H62 >= H63 OR H63 <= H64 OR H64 <= H65) * (ABS(H62 < H63 AND H63 < H64 AND H64 > H65 AND H65 > H66) * H64 + ABS(H62 >= H63 OR H63 >= H64 OR H64 <= H65 OR H65 <= H66) * (ABS(H63 < H64 AND H64 < H65 AND H65 > H66 AND H66 > H67) * H65 + ABS(H63 >= H64 OR H64 >= H65 OR H65 <= H66 OR H66 <= H67) * (ABS(H64 < H65 AND H65 < H66 AND H66 > H67 AND H67 > H68) * H66 + ABS(H64 >= H65 OR H65 >= H66 OR H66 <= H67 OR H67 <= H68) * (ABS(H65 < H66 AND H66 < H67 AND H67 > H68 AND H68 > H69) * H67 + ABS(H65 >= H66 OR H66 >= H67 OR H67 <= H68 OR H68 <= H69) * (ABS(H66 < H67 AND H67 < H68 AND H68 > H69 AND H69 > H70) * H68 + ABS(H66 >= H67 OR H67 >= H68 OR H68 <= H69 OR H69 <= H70) * (ABS(H67 < H68 AND H68 < H69 AND H69 > H70 AND H70 > H71) * H69 + ABS(H67 >= H68 OR H68 >= H69 OR H69 <= H70 OR H70 <= H71) * (ABS(H68 < H69 AND H69 < H70 AND H70 > H71 AND H71 > H72) * H70 + ABS(H68 >= H69 OR H69 >= H70 OR H70 <= H71 OR H71 <= H72) * (ABS(H69 < H70 AND H70 < H71 AND H71 > H72 AND H72 > H73) * H71 + ABS(H69 >= H70 OR H70 >= H71 OR H71 <= H72 OR H72 <= H73) * (ABS(H70 < H71 AND H71 < H72 AND H72 > H73 AND H73 > H74) * H72 + ABS(H70 >= H71 OR H71 >= H72 OR H72 <= H73 OR H73 <= H74) * (ABS(H71 < H72 AND H72 < H73 AND H73 > H74 AND H74 > H75) * H73 + ABS(H71 >= H72 OR H72 >= H73 OR H73 <= H74 OR H74 <= H75) * (ABS(H72 < H73 AND H73 < H74 AND H74 > H75 AND H75 > H76) * H74 + ABS(H72 >= H73 OR H73 >= H74 OR H74 <= H75 OR H75 <= H76) * (ABS(H73 < H74 AND H74 < H75 AND H75 > H76 AND H76 > H77) * H75 + ABS(H73 >= H74 OR H74 >= H75 OR H75 <= H76 OR H76 <= H77) * (ABS(H74 < H75 AND H75 < H76 AND H76 > H77 AND H77 > H78) * H76 + ABS(H74 >= H75 OR H75 >= H76 OR H76 <= H77 OR H77 <= H78) * (ABS(H75 < H76 AND H76 < H77 AND H77 > H78 AND H78 > H79) * H77 + ABS(H75 >= H76 OR H76 >= H77 OR H77 <= H78 OR H78 <= H79) * (ABS(H76 < H77 AND H77 < H78 AND H78 > H79 AND H79 > H80) * H78 + ABS(H76 >= H77 OR H77 >= H78 OR H78 <= H79 OR H79 <= H80) * (ABS(H77 < H78 AND H78 < H79 AND H79 > H80 AND H80 > H81) * H79 + ABS(H77 >= H78 OR H78 >= H79 OR H79 <= H80 OR H80 <= H81) * (ABS(H78 < H79 AND H79 < H80 AND H80 > H81 AND H81 > H82) * H80 + ABS(H78 >= H79 OR H79 >= H80 OR H80 <= H81 OR H81 <= H82) * (ABS(H79 < H80 AND H80 < H81 AND H81 > H82 AND H82 > H83) * H81 + ABS(H79 >= H80 OR H80 >= H81 OR H81 <= H82 OR H82 <= H83) * (ABS(H80 < H81 AND H81 < H82 AND H82 > H83 AND H83 > H84) * H82 + ABS(H80 >= H81 OR H81 >= H82 OR H82 <= H83 OR H83 <= H84) * (ABS(H81 < H82 AND H82 < H83 AND H83 > H84 AND H84 > H85) * H83 + ABS(H81 >= H82 OR H82 >= H83 OR H83 <= H84 OR H84 <= H85) * (ABS(H82 < H83 AND H83 < H84 AND H84 > H85 AND H85 > H86) * H84))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

And the Fractal Low would be the following.

ABS(L > L1 AND L1 > L2 AND L2 < L3 AND L3 < L4) * L2 + ABS(L <= L1 OR L1 <= L2 OR L2 >= L3 OR L3 >= L4) * (ABS(L1 > L2 AND L2 > L3 AND L3 < L4 AND L4 < L5) * L3 + ABS(L1 <= L2 OR L2 <= L3 OR L3 >= L4 OR L4 >= L5) * (ABS(L2 > L3 AND L3 > L4 AND L4 < L5 AND L5 < L6) * L4 + ABS(L2 <= L3 OR L3 <= L4 OR L4 >= L5 OR L5 >= L6) * (ABS(L3 > L4 AND L4 > L5 AND L5 < L6 AND L6 < L7) * L5 + ABS(L3 <= L4 OR L4 <= L5 OR L5 >= L6 OR L6 >= L7) * (ABS(L4 > L5 AND L5 > L6 AND L6 < L7 AND L7 < L8) * L6 + ABS(L4 <= L5 OR L5 <= L6 OR L6 >= L7 OR L7 >= L8) * (ABS(L5 > L6 AND L6 > L7 AND L7 < L8 AND L8 < L9) * L7 + ABS(L5 <= L6 OR L6 <= L7 OR L7 >= L8 OR L8 >= L9) * (ABS(L6 > L7 AND L7 > L8 AND L8 < L9 AND L9 < L10) * L8 + ABS(L6 <= L7 OR L7 <= L8 OR L8 >= L9 OR L9 >= L10) * (ABS(L7 > L8 AND L8 > L9 AND L9 < L10 AND L10 < L11) * L9 + ABS(L7 <= L8 OR L8 <= L9 OR L9 >= L10 OR L10 >= L11) * (ABS(L8 > L9 AND L9 > L10 AND L10 < L11 AND L11 < L12) * L10 + ABS(L8 <= L9 OR L9 <= L10 OR L10 >= L11 OR L11 >= L12) * (ABS(L9 > L10 AND L10 > L11 AND L11 < L12 AND L12 < L13) * L11 + ABS(L9 <= L10 OR L10 <= L11 OR L11 >= L12 OR L12 >= L13) * (ABS(L10 > L11 AND L11 > L12 AND L12 < L13 AND L13 < L14) * L12 + ABS(L10 <= L11 OR L11 <= L12 OR L12 >= L13 OR L13 >= L14) * (ABS(L11 > L12 AND L12 > L13 AND L13 < L14 AND L14 < L15) * L13 + ABS(L11 <= L12 OR L12 <= L13 OR L13 >= L14 OR L14 >= L15) * (ABS(L12 > L13 AND L13 > L14 AND L14 < L15 AND L15 < L16) * L14 + ABS(L12 <= L13 OR L13 <= L14 OR L14 >= L15 OR L15 >= L16) * (ABS(L13 > L14 AND L14 > L15 AND L15 < L16 AND L16 < L17) * L15 + ABS(L13 <= L14 OR L14 <= L15 OR L15 >= L16 OR L16 >= L17) * (ABS(L14 > L15 AND L15 > L16 AND L16 < L17 AND L17 < L18) * L16 + ABS(L14 <= L15 OR L15 <= L16 OR L16 >= L17 OR L17 >= L18) * (ABS(L15 > L16 AND L16 > L17 AND L17 < L18 AND L18 < L19) * L17 + ABS(L15 <= L16 OR L16 <= L17 OR L17 >= L18 OR L18 >= L19) * (ABS(L16 > L17 AND L17 > L18 AND L18 < L19 AND L19 < L20) * L18 + ABS(L16 <= L17 OR L17 <= L18 OR L18 >= L19 OR L19 >= L20) * (ABS(L17 > L18 AND L18 > L19 AND L19 < L20 AND L20 < L21) * L19 + ABS(L17 <= L18 OR L18 <= L19 OR L19 >= L20 OR L20 >= L21) * (ABS(L18 > L19 AND L19 > L20 AND L20 < L21 AND L21 < L22) * L20 + ABS(L18 <= L19 OR L19 <= L20 OR L20 >= L21 OR L21 >= L22) * (ABS(L19 > L20 AND L20 > L21 AND L21 < L22 AND L22 < L23) * L21 + ABS(L19 <= L20 OR L20 <= L21 OR L21 >= L22 OR L22 >= L23) * (ABS(L20 > L21 AND L21 > L22 AND L22 < L23 AND L23 < L24) * L22 + ABS(L20 <= L21 OR L21 <= L22 OR L22 >= L23 OR L23 >= L24) * (ABS(L21 > L22 AND L22 > L23 AND L23 < L24 AND L24 < L25) * L23 + ABS(L21 <= L22 OR L22 <= L23 OR L23 >= L24 OR L24 >= L25) * (ABS(L22 > L23 AND L23 > L24 AND L24 < L25 AND L25 < L26) * L24 + ABS(L22 <= L23 OR L23 <= L24 OR L24 >= L25 OR L25 >= L26) * (ABS(L23 > L24 AND L24 > L25 AND L25 < L26 AND L26 < L27) * L25 + ABS(L23 <= L24 OR L24 <= L25 OR L25 >= L26 OR L26 >= L27) * (ABS(L24 > L25 AND L25 > L26 AND L26 < L27 AND L27 < L28) * L26 + ABS(L24 <= L25 OR L25 <= L26 OR L26 >= L27 OR L27 >= L28) * (ABS(L25 > L26 AND L26 > L27 AND L27 < L28 AND L28 < L29) * L27 + ABS(L25 <= L26 OR L26 <= L27 OR L27 >= L28 OR L28 >= L29) * (ABS(L26 > L27 AND L27 > L28 AND L28 < L29 AND L29 < L30) * L28 + ABS(L26 <= L27 OR L27 <= L28 OR L28 >= L29 OR L29 >= L30) * (ABS(L27 > L28 AND L28 > L29 AND L29 < L30 AND L30 < L31) * L29 + ABS(L27 <= L28 OR L28 <= L29 OR L29 >= L30 OR L30 >= L31) * (ABS(L28 > L29 AND L29 > L30 AND L30 < L31 AND L31 < L32) * L30 + ABS(L28 <= L29 OR L29 <= L30 OR L30 >= L31 OR L31 >= L32) * (ABS(L29 > L30 AND L30 > L31 AND L31 < L32 AND L32 < L33) * L31 + ABS(L29 <= L30 OR L30 <= L31 OR L31 >= L32 OR L32 >= L33) * (ABS(L30 > L31 AND L31 > L32 AND L32 < L33 AND L33 < L34) * L32 + ABS(L30 <= L31 OR L31 <= L32 OR L32 >= L33 OR L33 >= L34) * (ABS(L31 > L32 AND L32 > L33 AND L33 < L34 AND L34 < L35) * L33 + ABS(L31 <= L32 OR L32 <= L33 OR L33 >= L34 OR L34 >= L35) * (ABS(L32 > L33 AND L33 > L34 AND L34 < L35 AND L35 < L36) * L34 + ABS(L32 <= L33 OR L33 <= L34 OR L34 >= L35 OR L35 >= L36) * (ABS(L33 > L34 AND L34 > L35 AND L35 < L36 AND L36 < L37) * L35 + ABS(L33 <= L34 OR L34 <= L35 OR L35 >= L36 OR L36 >= L37) * (ABS(L34 > L35 AND L35 > L36 AND L36 < L37 AND L37 < L38) * L36 + ABS(L34 <= L35 OR L35 <= L36 OR L36 >= L37 OR L37 >= L38) * (ABS(L35 > L36 AND L36 > L37 AND L37 < L38 AND L38 < L39) * L37 + ABS(L35 <= L36 OR L36 <= L37 OR L37 >= L38 OR L38 >= L39) * (ABS(L36 > L37 AND L37 > L38 AND L38 < L39 AND L39 < L40) * L38 + ABS(L36 <= L37 OR L37 <= L38 OR L38 >= L39 OR L39 >= L40) * (ABS(L37 > L38 AND L38 > L39 AND L39 < L40 AND L40 < L41) * L39 + ABS(L37 <= L38 OR L38 <= L39 OR L39 >= L40 OR L40 >= L41) * (ABS(L38 > L39 AND L39 > L40 AND L40 < L41 AND L41 < L42) * L40 + ABS(L38 <= L39 OR L39 <= L40 OR L40 >= L41 OR L41 >= L42) * (ABS(L39 > L40 AND L40 > L41 AND L41 < L42 AND L42 < L43) * L41 + ABS(L39 <= L40 OR L40 <= L41 OR L41 >= L42 OR L42 >= L43) * (ABS(L40 > L41 AND L41 > L42 AND L42 < L43 AND L43 < L44) * L42 + ABS(L40 <= L41 OR L41 <= L42 OR L42 >= L43 OR L43 >= L44) * (ABS(L41 > L42 AND L42 > L43 AND L43 < L44 AND L44 < L45) * L43 + ABS(L41 <= L42 OR L42 <= L43 OR L43 >= L44 OR L44 >= L45) * (ABS(L42 > L43 AND L43 > L44 AND L44 < L45 AND L45 < L46) * L44 + ABS(L42 <= L43 OR L43 <= L44 OR L44 >= L45 OR L45 >= L46) * (ABS(L43 > L44 AND L44 > L45 AND L45 < L46 AND L46 < L47) * L45 + ABS(L43 <= L44 OR L44 <= L45 OR L45 >= L46 OR L46 >= L47) * (ABS(L44 > L45 AND L45 > L46 AND L46 < L47 AND L47 < L48) * L46 + ABS(L44 <= L45 OR L45 <= L46 OR L46 >= L47 OR L47 >= L48) * (ABS(L45 > L46 AND L46 > L47 AND L47 < L48 AND L48 < L49) * L47 + ABS(L45 <= L46 OR L46 <= L47 OR L47 >= L48 OR L48 >= L49) * (ABS(L46 > L47 AND L47 > L48 AND L48 < L49 AND L49 < L50) * L48 + ABS(L46 <= L47 OR L47 <= L48 OR L48 >= L49 OR L49 >= L50) * (ABS(L47 > L48 AND L48 > L49 AND L49 < L50 AND L50 < L51) * L49 + ABS(L47 <= L48 OR L48 <= L49 OR L49 >= L50 OR L50 >= L51) * (ABS(L48 > L49 AND L49 > L50 AND L50 < L51 AND L51 < L52) * L50 + ABS(L48 <= L49 OR L49 <= L50 OR L50 >= L51 OR L51 >= L52) * (ABS(L49 > L50 AND L50 > L51 AND L51 < L52 AND L52 < L53) * L51 + ABS(L49 <= L50 OR L50 <= L51 OR L51 >= L52 OR L52 >= L53) * (ABS(L50 > L51 AND L51 > L52 AND L52 < L53 AND L53 < L54) * L52 + ABS(L50 <= L51 OR L51 <= L52 OR L52 >= L53 OR L53 >= L54) * (ABS(L51 > L52 AND L52 > L53 AND L53 < L54 AND L54 < L55) * L53 + ABS(L51 <= L52 OR L52 <= L53 OR L53 >= L54 OR L54 >= L55) * (ABS(L52 > L53 AND L53 > L54 AND L54 < L55 AND L55 < L56) * L54 + ABS(L52 <= L53 OR L53 <= L54 OR L54 >= L55 OR L55 >= L56) * (ABS(L53 > L54 AND L54 > L55 AND L55 < L56 AND L56 < L57) * L55 + ABS(L53 <= L54 OR L54 <= L55 OR L55 >= L56 OR L56 >= L57) * (ABS(L54 > L55 AND L55 > L56 AND L56 < L57 AND L57 < L58) * L56 + ABS(L54 <= L55 OR L55 <= L56 OR L56 >= L57 OR L57 >= L58) * (ABS(L55 > L56 AND L56 > L57 AND L57 < L58 AND L58 < L59) * L57 + ABS(L55 <= L56 OR L56 <= L57 OR L57 >= L58 OR L58 >= L59) * (ABS(L56 > L57 AND L57 > L58 AND L58 < L59 AND L59 < L60) * L58 + ABS(L56 <= L57 OR L57 <= L58 OR L58 >= L59 OR L59 >= L60) * (ABS(L57 > L58 AND L58 > L59 AND L59 < L60 AND L60 < L61) * L59 + ABS(L57 <= L58 OR L58 <= L59 OR L59 >= L60 OR L60 >= L61) * (ABS(L58 > L59 AND L59 > L60 AND L60 < L61 AND L61 < L62) * L60 + ABS(L58 <= L59 OR L59 <= L60 OR L60 >= L61 OR L61 >= L62) * (ABS(L59 > L60 AND L60 > L61 AND L61 < L62 AND L62 < L63) * L61 + ABS(L59 <= L60 OR L60 <= L61 OR L61 >= L62 OR L62 >= L63) * (ABS(L60 > L61 AND L61 > L62 AND L62 < L63 AND L63 < L64) * L62 + ABS(L60 <= L61 OR L61 <= L62 OR L62 >= L63 OR L63 >= L64) * (ABS(L61 > L62 AND L62 > L63 AND L63 < L64 AND L64 < L65) * L63 + ABS(L61 <= L62 OR L62 <= L63 OR L63 >= L64 OR L64 >= L65) * (ABS(L62 > L63 AND L63 > L64 AND L64 < L65 AND L65 < L66) * L64 + ABS(L62 <= L63 OR L63 <= L64 OR L64 >= L65 OR L65 >= L66) * (ABS(L63 > L64 AND L64 > L65 AND L65 < L66 AND L66 < L67) * L65 + ABS(L63 <= L64 OR L64 <= L65 OR L65 >= L66 OR L66 >= L67) * (ABS(L64 > L65 AND L65 > L66 AND L66 < L67 AND L67 < L68) * L66 + ABS(L64 <= L65 OR L65 <= L66 OR L66 >= L67 OR L67 >= L68) * (ABS(L65 > L66 AND L66 > L67 AND L67 < L68 AND L68 < L69) * L67 + ABS(L65 <= L66 OR L66 <= L67 OR L67 >= L68 OR L68 >= L69) * (ABS(L66 > L67 AND L67 > L68 AND L68 < L69 AND L69 < L70) * L68 + ABS(L66 <= L67 OR L67 <= L68 OR L68 >= L69 OR L69 >= L70) * (ABS(L67 > L68 AND L68 > L69 AND L69 < L70 AND L70 < L71) * L69 + ABS(L67 <= L68 OR L68 <= L69 OR L69 >= L70 OR L70 >= L71) * (ABS(L68 > L69 AND L69 > L70 AND L70 < L71 AND L71 < L72) * L70 + ABS(L68 <= L69 OR L69 <= L70 OR L70 >= L71 OR L71 >= L72) * (ABS(L69 > L70 AND L70 > L71 AND L71 < L72 AND L72 < L73) * L71 + ABS(L69 <= L70 OR L70 <= L71 OR L71 >= L72 OR L72 >= L73) * (ABS(L70 > L71 AND L71 > L72 AND L72 < L73 AND L73 < L74) * L72 + ABS(L70 <= L71 OR L71 <= L72 OR L72 >= L73 OR L73 >= L74) * (ABS(L71 > L72 AND L72 > L73 AND L73 < L74 AND L74 < L75) * L73 + ABS(L71 <= L72 OR L72 <= L73 OR L73 >= L74 OR L74 >= L75) * (ABS(L72 > L73 AND L73 > L74 AND L74 < L75 AND L75 < L76) * L74 + ABS(L72 <= L73 OR L73 <= L74 OR L74 >= L75 OR L75 >= L76) * (ABS(L73 > L74 AND L74 > L75 AND L75 < L76 AND L76 < L77) * L75 + ABS(L73 <= L74 OR L74 <= L75 OR L75 >= L76 OR L76 >= L77) * (ABS(L74 > L75 AND L75 > L76 AND L76 < L77 AND L77 < L78) * L76 + ABS(L74 <= L75 OR L75 <= L76 OR L76 >= L77 OR L77 >= L78) * (ABS(L75 > L76 AND L76 > L77 AND L77 < L78 AND L78 < L79) * L77 + ABS(L75 <= L76 OR L76 <= L77 OR L77 >= L78 OR L78 >= L79) * (ABS(L76 > L77 AND L77 > L78 AND L78 < L79 AND L79 < L80) * L78 + ABS(L76 <= L77 OR L77 <= L78 OR L78 >= L79 OR L79 >= L80) * (ABS(L77 > L78 AND L78 > L79 AND L79 < L80 AND L80 < L81) * L79 + ABS(L77 <= L78 OR L78 <= L79 OR L79 >= L80 OR L80 >= L81) * (ABS(L78 > L79 AND L79 > L80 AND L80 < L81 AND L81 < L82) * L80 + ABS(L78 <= L79 OR L79 <= L80 OR L80 >= L81 OR L81 >= L82) * (ABS(L79 > L80 AND L80 > L81 AND L81 < L82 AND L82 < L83) * L81 + ABS(L79 <= L80 OR L80 <= L81 OR L81 >= L82 OR L82 >= L83) * (ABS(L80 > L81 AND L81 > L82 AND L82 < L83 AND L83 < L84) * L82 + ABS(L80 <= L81 OR L81 <= L82 OR L82 >= L83 OR L83 >= L84) * (ABS(L81 > L82 AND L82 > L83 AND L83 < L84 AND L84 < L85) * L83 + ABS(L81 <= L82 OR L82 <= L83 OR L83 >= L84 OR L84 >= L85) * (ABS(L82 > L83 AND L83 > L84 AND L84 < L85 AND L85 < L86) * L84))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



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