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

Worden Discussion Forum » Customer Training & Support » PCFs, EasyScan and Custom Indicators » TSI Crossing Zero

TSI Crossing Zero Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
grainmerchant
Posted : Monday, February 5, 2007 7:15:40 PM
Registered User
Joined: 1/15/2007
Posts: 4
 Here's the TSI 25,13 code. What I want to do is create a PCF that shows a crossing up through 0. I looked at the stochastic crossing upward through 20.
That formula was a lot simpler it because it has a function for stochastic (STOC) and that sure shortens things up. How do I do it with a humdinger like this though? Where do I put my ".1's" to compare yesterdays indicator close with todays value and the zero line?

100 * (XAVG(XAVGC25,13) - XAVG(XAVGC25.1,13)) / (0.01113441 * ABS(C - C1) + 0.01969708 * ABS(C1 - C2) + 0.02625549 * ABS(C2 - C3) + 0.03115604 * ABS(C3 - C4) + 0.03469103 * ABS(C4 - C5) + 0.03710672 * ABS(C5 - C6) + 0.03861027 * ABS(C6 - C7) + 0.0393756 * ABS(C7 - C8) + 0.03954844 * ABS(C8 - C9) + 0.03925059 * ABS(C9 - C10) + 0.03858361 * ABS(C10 - C11) + 0.03763189 * ABS(C11 - C12) + 0.03646535 * ABS(C12 - C13) + 0.03514165 * ABS(C13 - C14) + 0.03370815 * ABS(C14 - C15) + 0.03220354 * ABS(C15 - C16) + 0.03065919 * ABS(C16 - C17) + 0.02910038 * ABS(C17 - C18) + 0.02754724 * ABS(C18 - C19) + 0.02601567 * ABS(C19 - C20) + 0.02451799 * ABS(C20 - C21) + 0.02306359 * ABS(C21 - C22) + 0.02165941 * ABS(C22 - C23) + 0.02031039 * ABS(C23 - C24) + 0.01901984 * ABS(C24 - C25) + 0.01778974 * ABS(C25 - C26) + 0.01662098 * ABS(C26 - C27) + 0.01551361 * ABS(C27 - C28) + 0.01446696 * ABS(C28 - C29) + 0.01347986 * ABS(C29 - C30) + 0.01255073 * ABS(C30 - C31) + 0.01167768 * ABS(C31 - C32) + 0.01085859 * ABS(C32 - C33) + 0.01009119 * ABS(C33 - C34) + 0.00937312 * ABS(C34 - C35) + 0.00870198 * ABS(C35 - C36) + 0.00807534 * ABS(C36 - C37) + 0.0074908 * ABS(C37 - C38) + 0.00694599 * ABS(C38 - C39) + 0.0064386 * ABS(C39 - C40) + 0.00596639 * ABS(C40 - C41) + 0.00552721 * ABS(C41 - C42) + 0.005119 * ABS(C42 - C43) + 0.00473976 * ABS(C43 - C44) + 0.00438761 * ABS(C44 - C45) + 0.00406078 * ABS(C45 - C46) + 0.00375756 * ABS(C46 - C47) + 0.00347636 * ABS(C47 - C48) + 0.00321567 * ABS(C48 - C49) + 0.00297407 * ABS(C49 - C50) + 0.00275024 * ABS(C50 - C51) + 0.00254291 * ABS(C51 - C52) + 0.00235093 * ABS(C52 - C53) + 0.0021732 * ABS(C53 - C54) + 0.0020087 * ABS(C54 - C55) + 0.00185647 * ABS(C55 - C56) + 0.00171562 * ABS(C56 - C57) + 0.00158533 * ABS(C57 - C58) + 0.00146482 * ABS(C58 - C59) + 0.00135338 * ABS(C59 - C60) + 0.00125033 * ABS(C60 - C61) + 0.00115505 * ABS(C61 - C62) + 0.00106698 * ABS(C62 - C63) + 0.00098557 * ABS(C63 - C64) + 0.00091033 * ABS(C64 - C65) + 0.00084079 * ABS(C65 - C66) + 0.00077653 * ABS(C66 - C67) + 0.00071716 * ABS(C67 - C68) + 0.0006623 * ABS(C68 - C69) + 0.00061162 * ABS(C69 - C70) + 0.0005648 * ABS(C70 - C71) + 0.00052155 * ABS(C71 - C72) + 0.00048159 * ABS(C72 - C73) + 0.00044469 * ABS(C73 - C74) + 0.00041061 * ABS(C74 - C75) + 0.00037913 * ABS(C75 - C76) + 0.00035005 * ABS(C76 - C77) + 0.0003232 * ABS(C77 - C78) + 0.00029841 * ABS(C78 - C79) + 0.00027551 * ABS(C79 - C80) + 0.00025436 * ABS(C80 - C81) + 0.00023484 * ABS(C81 - C82) + 0.00021681 * ABS(C82 - C83) + 0.00020016 * ABS(C83 - C84) + 0.00018479 * ABS(C84 - C85) + 0.0001706 * ABS(C85 - C86) + 0.0001575 * ABS(C86 - C87))
Back to top
bustermu
Posted : Tuesday, February 6, 2007 12:26:41 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
QUOTE (grainmerchant)
Here's the TSI 25,13 code. What I want to do is create a PCF that shows a crossing up through 0.


grainmerchant,

The normalizing denominator plays no role in determining an upcrossing of zero by the TSI; only the numerator in relevant. A PCF for an upcrossing of zero is:

XAVG(XAVGC25,13)-XAVG(XAVGC25.1,13)>0 AND XAVG(XAVGC25.1,13)-XAVG(XAVGC25.2,13)<0

There are other forms.

Thanks,
Jim Murphy
Back to top
grainmerchant
Posted : Tuesday, February 6, 2007 1:20:37 PM
Registered User
Joined: 1/15/2007
Posts: 4
 Thanks Jim! What about a TSI crossing above of a 5 period SMA instead of the zero line...is that much different ?

GM
Back to top
bustermu
Posted : Tuesday, February 6, 2007 3:36:22 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
QUOTE (grainmerchant)
Thanks Jim! What about a TSI crossing above of a 5 period SMA instead of the zero line...is that much different?


CM,

There is a big difference. It is too long for me; so I will defer to Bruce.

A PCF for the numerator of the TSI upcrossing its SMA5 is:

XAVG(XAVGC25,13)-XAVG(XAVGC25.1,13)>(XAVG(XAVGC25,13)-XAVG(XAVGC25.5,13))/5
AND XAVG(XAVGC25.1,13)-XAVG(XAVGC25.2,13)<(XAVG(XAVGC25.1,13)-XAVG(XAVGC25.6,13))/5

This will give you fairly accurate results. You are approximately looking for an upcrossing of zero by a filtered version of:

4*C-5*C1+C5

This may help you evaluate your request.

Thanks,
Jim Murphy
Back to top
Lefty86
Posted : Monday, February 26, 2007 1:42:16 PM
Registered User
Joined: 1/27/2005
Posts: 88
 How do you create a personal Criteria Formula for A TSV 38 and a Moving Average 19 that is above the Zero line for 5 months or more.
Thank you
El Vozeolas @21301
Back to top
Craig_S
Posted : Monday, February 26, 2007 2:39:41 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 ARE your TSV and moving average simple or exponential?
- Craig
Here to Help!
Back to top
Lefty86
Posted : Monday, February 26, 2007 6:30:59 PM
Registered User
Joined: 1/27/2005
Posts: 88
 They are simple

El
Back to top
Lefty86
Posted : Monday, February 26, 2007 10:23:25 PM
Registered User
Joined: 1/27/2005
Posts: 88
 How do you create a personal Criteria Formula for A TSV 38 Simple and a Moving Average 19 simple that they are all above the Zero line for 5 months or more.

Thank you
Lefty 86
Back to top
Bruce_L
Posted : Tuesday, February 27, 2007 9:41:43 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 Lefty86,
TSV38 Simple > 0 for 105-Periods:

MIN(TSV38,105) > 0

19-Period Simple Moving Average of TSV38 Simple > 0 for 105-Periods:

AVG(TSV38,19) > 0 AND AVG(TSV38.1,19) > 0 AND AVG(TSV38.2,19) > 0 AND AVG(TSV38.3,19) > 0 AND AVG(TSV38.4,19) > 0 AND AVG(TSV38.5,19) > 0 AND AVG(TSV38.6,19) > 0 AND AVG(TSV38.7,19) > 0 AND AVG(TSV38.8,19) > 0 AND AVG(TSV38.9,19) > 0 AND AVG(TSV38.10,19) > 0 AND AVG(TSV38.11,19) > 0 AND AVG(TSV38.12,19) > 0 AND AVG(TSV38.13,19) > 0 AND AVG(TSV38.14,19) > 0 AND AVG(TSV38.15,19) > 0 AND AVG(TSV38.16,19) > 0 AND AVG(TSV38.17,19) > 0 AND AVG(TSV38.18,19) > 0 AND AVG(TSV38.19,19) > 0 AND AVG(TSV38.20,19) > 0 AND AVG(TSV38.21,19) > 0 AND AVG(TSV38.22,19) > 0 AND AVG(TSV38.23,19) > 0 AND AVG(TSV38.24,19) > 0 AND AVG(TSV38.25,19) > 0 AND AVG(TSV38.26,19) > 0 AND AVG(TSV38.27,19) > 0 AND AVG(TSV38.28,19) > 0 AND AVG(TSV38.29,19) > 0 AND AVG(TSV38.30,19) > 0 AND AVG(TSV38.31,19) > 0 AND AVG(TSV38.32,19) > 0 AND AVG(TSV38.33,19) > 0 AND AVG(TSV38.34,19) > 0 AND AVG(TSV38.35,19) > 0 AND AVG(TSV38.36,19) > 0 AND AVG(TSV38.37,19) > 0 AND AVG(TSV38.38,19) > 0 AND AVG(TSV38.39,19) > 0 AND AVG(TSV38.40,19) > 0 AND AVG(TSV38.41,19) > 0 AND AVG(TSV38.42,19) > 0 AND AVG(TSV38.43,19) > 0 AND AVG(TSV38.44,19) > 0 AND AVG(TSV38.45,19) > 0 AND AVG(TSV38.46,19) > 0 AND AVG(TSV38.47,19) > 0 AND AVG(TSV38.48,19) > 0 AND AVG(TSV38.49,19) > 0 AND AVG(TSV38.50,19) > 0 AND AVG(TSV38.51,19) > 0 AND AVG(TSV38.52,19) > 0 AND AVG(TSV38.53,19) > 0 AND AVG(TSV38.54,19) > 0 AND AVG(TSV38.55,19) > 0 AND AVG(TSV38.56,19) > 0 AND AVG(TSV38.57,19) > 0 AND AVG(TSV38.58,19) > 0 AND AVG(TSV38.59,19) > 0 AND AVG(TSV38.60,19) > 0 AND AVG(TSV38.61,19) > 0 AND AVG(TSV38.62,19) > 0 AND AVG(TSV38.63,19) > 0 AND AVG(TSV38.64,19) > 0 AND AVG(TSV38.65,19) > 0 AND AVG(TSV38.66,19) > 0 AND AVG(TSV38.67,19) > 0 AND AVG(TSV38.68,19) > 0 AND AVG(TSV38.69,19) > 0 AND AVG(TSV38.70,19) > 0 AND AVG(TSV38.71,19) > 0 AND AVG(TSV38.72,19) > 0 AND AVG(TSV38.73,19) > 0 AND AVG(TSV38.74,19) > 0 AND AVG(TSV38.75,19) > 0 AND AVG(TSV38.76,19) > 0 AND AVG(TSV38.77,19) > 0 AND AVG(TSV38.78,19) > 0 AND AVG(TSV38.79,19) > 0 AND AVG(TSV38.80,19) > 0 AND AVG(TSV38.81,19) > 0 AND AVG(TSV38.82,19) > 0 AND AVG(TSV38.83,19) > 0 AND AVG(TSV38.84,19) > 0 AND AVG(TSV38.85,19) > 0 AND AVG(TSV38.86,19) > 0 AND AVG(TSV38.87,19) > 0 AND AVG(TSV38.88,19) > 0 AND AVG(TSV38.89,19) > 0 AND AVG(TSV38.90,19) > 0 AND AVG(TSV38.91,19) > 0 AND AVG(TSV38.92,19) > 0 AND AVG(TSV38.93,19) > 0 AND AVG(TSV38.94,19) > 0 AND AVG(TSV38.95,19) > 0 AND AVG(TSV38.96,19) > 0 AND AVG(TSV38.97,19) > 0 AND AVG(TSV38.98,19) > 0 AND AVG(TSV38.99,19) > 0 AND AVG(TSV38.100,19) > 0 AND AVG(TSV38.101,19) > 0 AND AVG(TSV38.102,19) > 0 AND AVG(TSV38.103,19) > 0 AND AVG(TSV38.104,19) > 0

TSV38 Simple > 0 and 19-Period Simple Moving Average of TSV38 Simple > 0 for 105-Periods:

MIN(TSV38,105) > 0 AND AVG(TSV38,19) > 0 AND AVG(TSV38.1,19) > 0 AND AVG(TSV38.2,19) > 0 AND AVG(TSV38.3,19) > 0 AND AVG(TSV38.4,19) > 0 AND AVG(TSV38.5,19) > 0 AND AVG(TSV38.6,19) > 0 AND AVG(TSV38.7,19) > 0 AND AVG(TSV38.8,19) > 0 AND AVG(TSV38.9,19) > 0 AND AVG(TSV38.10,19) > 0 AND AVG(TSV38.11,19) > 0 AND AVG(TSV38.12,19) > 0 AND AVG(TSV38.13,19) > 0 AND AVG(TSV38.14,19) > 0 AND AVG(TSV38.15,19) > 0 AND AVG(TSV38.16,19) > 0 AND AVG(TSV38.17,19) > 0 AND AVG(TSV38.18,19) > 0 AND AVG(TSV38.19,19) > 0 AND AVG(TSV38.20,19) > 0 AND AVG(TSV38.21,19) > 0 AND AVG(TSV38.22,19) > 0 AND AVG(TSV38.23,19) > 0 AND AVG(TSV38.24,19) > 0 AND AVG(TSV38.25,19) > 0 AND AVG(TSV38.26,19) > 0 AND AVG(TSV38.27,19) > 0 AND AVG(TSV38.28,19) > 0 AND AVG(TSV38.29,19) > 0 AND AVG(TSV38.30,19) > 0 AND AVG(TSV38.31,19) > 0 AND AVG(TSV38.32,19) > 0 AND AVG(TSV38.33,19) > 0 AND AVG(TSV38.34,19) > 0 AND AVG(TSV38.35,19) > 0 AND AVG(TSV38.36,19) > 0 AND AVG(TSV38.37,19) > 0 AND AVG(TSV38.38,19) > 0 AND AVG(TSV38.39,19) > 0 AND AVG(TSV38.40,19) > 0 AND AVG(TSV38.41,19) > 0 AND AVG(TSV38.42,19) > 0 AND AVG(TSV38.43,19) > 0 AND AVG(TSV38.44,19) > 0 AND AVG(TSV38.45,19) > 0 AND AVG(TSV38.46,19) > 0 AND AVG(TSV38.47,19) > 0 AND AVG(TSV38.48,19) > 0 AND AVG(TSV38.49,19) > 0 AND AVG(TSV38.50,19) > 0 AND AVG(TSV38.51,19) > 0 AND AVG(TSV38.52,19) > 0 AND AVG(TSV38.53,19) > 0 AND AVG(TSV38.54,19) > 0 AND AVG(TSV38.55,19) > 0 AND AVG(TSV38.56,19) > 0 AND AVG(TSV38.57,19) > 0 AND AVG(TSV38.58,19) > 0 AND AVG(TSV38.59,19) > 0 AND AVG(TSV38.60,19) > 0 AND AVG(TSV38.61,19) > 0 AND AVG(TSV38.62,19) > 0 AND AVG(TSV38.63,19) > 0 AND AVG(TSV38.64,19) > 0 AND AVG(TSV38.65,19) > 0 AND AVG(TSV38.66,19) > 0 AND AVG(TSV38.67,19) > 0 AND AVG(TSV38.68,19) > 0 AND AVG(TSV38.69,19) > 0 AND AVG(TSV38.70,19) > 0 AND AVG(TSV38.71,19) > 0 AND AVG(TSV38.72,19) > 0 AND AVG(TSV38.73,19) > 0 AND AVG(TSV38.74,19) > 0 AND AVG(TSV38.75,19) > 0 AND AVG(TSV38.76,19) > 0 AND AVG(TSV38.77,19) > 0 AND AVG(TSV38.78,19) > 0 AND AVG(TSV38.79,19) > 0 AND AVG(TSV38.80,19) > 0 AND AVG(TSV38.81,19) > 0 AND AVG(TSV38.82,19) > 0 AND AVG(TSV38.83,19) > 0 AND AVG(TSV38.84,19) > 0 AND AVG(TSV38.85,19) > 0 AND AVG(TSV38.86,19) > 0 AND AVG(TSV38.87,19) > 0 AND AVG(TSV38.88,19) > 0 AND AVG(TSV38.89,19) > 0 AND AVG(TSV38.90,19) > 0 AND AVG(TSV38.91,19) > 0 AND AVG(TSV38.92,19) > 0 AND AVG(TSV38.93,19) > 0 AND AVG(TSV38.94,19) > 0 AND AVG(TSV38.95,19) > 0 AND AVG(TSV38.96,19) > 0 AND AVG(TSV38.97,19) > 0 AND AVG(TSV38.98,19) > 0 AND AVG(TSV38.99,19) > 0 AND AVG(TSV38.100,19) > 0 AND AVG(TSV38.101,19) > 0 AND AVG(TSV38.102,19) > 0 AND AVG(TSV38.103,19) > 0 AND AVG(TSV38.104,19) > 0

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Lefty86
Posted : Wednesday, February 28, 2007 3:59:06 PM
Registered User
Joined: 1/27/2005
Posts: 88
 Thank you for the formula...
Is there another way with a shorter formular be created for stocks that 5 months ago, when both the TSV 38 & MA 19 have been above the Zero and never went below the Zero line during it's last 5 months? I am not interested in the interim periods Ex. TRA
If a shorter formula is created what will be the consequence in the results?
If you have the time, why do you have to have such a long formula so I can understand the reason why it was written that way so I can copy and just change numbers?

Again, Thanks's for your help on this...

Lefty86
Back to top
Bruce_L
Posted : Wednesday, February 28, 2007 4:32:06 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Lefty86)
Is there another way with a shorter formular be created for stocks that 5 months ago, when both the TSV 38 & MA 19 have been above the Zero and never went below the Zero line during it's last 5 months?

I could certainly be missing something (it happens all the time), but I'm not aware of a shorter way to do this.

QUOTE (Lefty86)
I am not interested in the interim periods Ex. TRA

This could be what I'm missing. This seems to be a direct contradiction based on my understanding of the word "interim" and the phrase "above the Zero and never went below the Zero line". It would seem you are interested in the interim period.

QUOTE (Lefty86)
If a shorter formula is created what will be the consequence in the results?

I suppose that would depend on the formula created. I am not sure how it would be created and still return results "when both the TSV 38 & MA 19 have been above the Zero and never went below the Zero line during it's last 5 months".

QUOTE (Lefty86)
If you have the time, why do you have to have such a long formula so I can understand the reason why it was written that way so I can copy and just change numbers?

You probably noticed how much shorter the "TSV38 Simple > 0 for 105-Periods" Personal Criteria Formula is compared to the other formulas. The reason is that the MIN() function can be used on TSV38, but cannot be used on other functions or complex formulas (complex in this case meaning composed of more than one indicator included in the Personal Criteria Formula Language).

This means MIN(AVG(TSV38,19),105) is not valid syntax and must be expanded. Actually expanding this would have resulted in a formula that is too long to be practical, but we don't need to return the actual value since it is being compared to a fixed value (in this case, zero). We can compare each day's value to zero independently:

The current comparison is written as:

AVG(TSV38,19) > 0

And each previous day is written by adding a days ago parameter to TSV. So the value one period ago would be written as:

AVG(TSV38.1,19) > 0

Everything is connected using AND statements because all of the comparisons must be True to for the condition as a whole to be True.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dnhoward
Posted : Monday, February 2, 2009 5:58:55 PM
Registered User
Joined: 1/5/2007
Posts: 21
QUOTE (bustermu)
QUOTE (grainmerchant)
Thanks Jim! What about a TSI crossing above of a 5 period SMA instead of the zero line...is that much different?


CM,

There is a big difference. It is too long for me; so I will defer to Bruce.

A PCF for the numerator of the TSI upcrossing its SMA5 is:

XAVG(XAVGC25,13)-XAVG(XAVGC25.1,13)>(XAVG(XAVGC25,13)-XAVG(XAVGC25.5,13))/5
AND XAVG(XAVGC25.1,13)-XAVG(XAVGC25.2,13)<(XAVG(XAVGC25.1,13)-XAVG(XAVGC25.6,13))/5

This will give you fairly accurate results. You are approximately looking for an upcrossing of zero by a filtered version of:

4*C-5*C1+C5

This may help you evaluate your request.

Thanks,
Jim Murphy


Howdy all,

I love the above formula.  I use it as a custom daily % true indicator along with some other pcfs.  How do I modify the above to give me a weekly TSI approxiamation PCF?   I'd like to get a TSI crossing 5sma %true custom indicator on a Weekly chart.  Ideas??

many thanks!
dnhoward
Back to top
Bruce_L
Posted : Tuesday, February 3, 2009 11:01:07 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 dnhoward,
If you want a Weekly Custom Percent True Indicator, just use the original formula. It will automatically use the Weekly Bars on a Weekly Chart. If you need a Weekly version of the following for use as a Personal Criteria Formula:

Visually Backtesting Specific Symbols

XAVG(XAVGC25,13)-XAVG(XAVGC25.1,13)>(XAVG(XAVGC25,13)-XAVG(XAVGC25.5,13))/5
AND XAVG(XAVGC25.1,13)-XAVG(XAVGC25.2,13)<(XAVG(XAVGC25.1,13)-XAVG(XAVGC25.6,13))/5

You might want to try the following:

Cascades of Moving Averages

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

.153991764868743 * (4 * C - 5 * C5 + C25 + 12 / 13 * (4 * C5 - 5 * C10 + C30 + 12 / 13 * (4 * C10 - 5 * C15 + C35 + 12 / 13 * (4 * C15 - 5 * C20 + C40 + 12 / 13 * (4 * C20 - 5 * C25 + C45 + 12 / 13 * (4 * C25 - 5 * C30 + C50 + 12 / 13 * (4 * C30 - 5 * C35 + C55 + 12 / 13 * (4 * C35 - 5 * C40 + C60 + 12 / 13 * (4 * C40 - 5 * C45 + C65 + 12 / 13 * (4 * C45 - 5 * C50 + C70 + 12 / 13 * (4 * C50 - 5 * C55 + C75 + 12 / 13 * (4 * C55 - 5 * C60 + C80 + 12 / 13 * (4 * C60 - 5 * C65 + C85 + 12 / 13 * (4 * C65 - 5 * C70 + C90 + 12 / 13 * (4 * C70 - 5 * C75 + C95 + 12 / 13 * (4 * C75 - 5 * C80 + C100 + 12 / 13 * (4 * C80 - 5 * C85 + C105 + 12 / 13 * (4 * C85 - 5 * C90 + C110 + 12 / 13 * (4 * C90 - 5 * C95 + C115 + 12 / 13 * (4 * C95 - 5 * C100 + C120 + 12 / 13 * (4 * C100 - 5 * C105 + C125 + 12 / 13 * (4 * C105 - 5 * C110 + C130 + 12 / 13 * (4 * C110 - 5 * C115 + C135 + 12 / 13 * (4 * C115 - 5 * C120 + C140 + 12 / 13 * (4 * C120 - 5 * C125 + C145 + 12 / 13 * (4 * C125 - 5 * C130 + C150 + 12 / 13 * (4 * C130 - 5 * C135 + C155 + 12 / 13 * (4 * C135 - 5 * C140 + C160 + 12 / 13 * (4 * C140 - 5 * C145 + C165 + 12 / 13 * (4 * C145 - 5 * C150 + C170 + 12 / 13 * (4 * C150 - 5 * C155 + C175 + 12 / 13 * (4 * C155 - 5 * C160 + C180 + 12 / 13 * (4 * C160 - 5 * C165 + C185 + 12 / 13 * (4 * C165 - 5 * C170 + C190 + 12 / 13 * (4 * C170 - 5 * C175 + C195 + 12 / 13 * (4 * C175 - 5 * C180 + C200 + 12 / 13 * (4 * C180 - 5 * C185 + C205 + 12 / 13 * (4 * C185 - 5 * C190 + C210 + 12 / 13 * (4 * C190 - 5 * C195 + C215 + 12 / 13 * (4 * C195 - 5 * C200 + C220 + 12 / 13 * (4 * C200 - 5 * C205 + C225 + 12 / 13 * (4 * C205 - 5 * C210 + C230 + 12 / 13 * (4 * C210 - 5 * C215 + C235 + 12 / 13 * (4 * C215 - 5 * C220 + C240 + 12 / 13 * (4 * C220 - 5 * C225 + C245 + 12 / 13 * (4 * C225 - 5 * C230 + C250 + 12 / 13 * (4 * C230 - 5 * C235 + C255 + 12 / 13 * (4 * C235 - 5 * C240 + C260 + 12 / 13 * (4 * C240 - 5 * C245 + C265 + 12 / 13 * (4 * C245 - 5 * C250 + C270 + 12 / 13 * (4 * C250 - 5 * C255 + C275 + 12 / 13 * (4 * C255 - 5 * C260 + C280 + 12 / 13 * (4 * C260 - 5 * C265 + C285 + 12 / 13 * (4 * C265 - 5 * C270 + C290 + 12 / 13 * (4 * C270 - 5 * C275 + C295 + 12 / 13 * (4 * C275 - 5 * C280 + C300 + 12 / 13 * (4 * C280 - 5 * C285 + C305 + 12 / 13 * (4 * C285 - 5 * C290 + C310 + 12 / 13 * (4 * C290 - 5 * C295 + C315 + 12 / 13 * (4 * C295 - 5 * C300 + C320 + 12 / 13 * (4 * C300 - 5 * C305 + C325 + 12 / 13 * (4 * C305 - 5 * C310 + C330 + 12 / 13 * (4 * C310 - 5 * C315 + C335 + 12 / 13 * (4 * C315 - 5 * C320 + C340 + 12 / 13 * (4 * C320 - 5 * C325 + C345 + 12 / 13 * (4 * C325 - 5 * C330 + C350 + 12 / 13 * (4 * C330 - 5 * C335 + C355 + 12 / 13 * (4 * C335 - 5 * C340 + C360 + 12 / 13 * (4 * C340 - 5 * C345 + C365 + 12 / 13 * (4 * C345 - 5 * C350 + C370 + 12 / 13 * (4 * C350 - 5 * C355 + C375 + 12 / 13 * (4 * C355 - 5 * C360 + C380 + 12 / 13 * (4 * C360 - 5 * C365 + C385 + 12 / 13 * (4 * C365 - 5 * C370 + C390 + 12 / 13 * (4 * C370 - 5 * C375 + C395 + 12 / 13 * (4 * C375 - 5 * C380 + C400 + 12 / 13 * (4 * C380 - 5 * C385 + C405 + 12 / 13 * (4 * C385 - 5 * C390 + C410 + 12 / 13 * (4 * C390 - 5 * C395 + C415 + 12 / 13 * (4 * C395 - 5 * C400 + C420 + 12 / 13 * (4 * C400 - 5 * C405 + C425 + 12 / 13 * (4 * C405 - 5 * C410 + C430 + 12 / 13 * (4 * C410 - 5 * C415 + C435 + 12 / 13 * (4 * C415 - 5 * C420 + C440 + 12 / 13 * (4 * C420 - 5 * C425 + C445 + 12 / 13 * (4 * C425 - 5 * C430 + C450 + 12 / 13 * (4 * C430 - 5 * C435 + C455))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .142996048056393 * (4 * C - 5 * C5 + C25 + 6 / 7 * (4 * C5 - 5 * C10 + C30 + 6 / 7 * (4 * C10 - 5 * C15 + C35 + 6 / 7 * (4 * C15 - 5 * C20 + C40 + 6 / 7 * (4 * C20 - 5 * C25 + C45 + 6 / 7 * (4 * C25 - 5 * C30 + C50 + 6 / 7 * (4 * C30 - 5 * C35 + C55 + 6 / 7 * (4 * C35 - 5 * C40 + C60 + 6 / 7 * (4 * C40 - 5 * C45 + C65 + 6 / 7 * (4 * C45 - 5 * C50 + C70 + 6 / 7 * (4 * C50 - 5 * C55 + C75 + 6 / 7 * (4 * C55 - 5 * C60 + C80 + 6 / 7 * (4 * C60 - 5 * C65 + C85 + 6 / 7 * (4 * C65 - 5 * C70 + C90 + 6 / 7 * (4 * C70 - 5 * C75 + C95 + 6 / 7 * (4 * C75 - 5 * C80 + C100 + 6 / 7 * (4 * C80 - 5 * C85 + C105 + 6 / 7 * (4 * C85 - 5 * C90 + C110 + 6 / 7 * (4 * C90 - 5 * C95 + C115 + 6 / 7 * (4 * C95 - 5 * C100 + C120 + 6 / 7 * (4 * C100 - 5 * C105 + C125 + 6 / 7 * (4 * C105 - 5 * C110 + C130 + 6 / 7 * (4 * C110 - 5 * C115 + C135 + 6 / 7 * (4 * C115 - 5 * C120 + C140 + 6 / 7 * (4 * C120 - 5 * C125 + C145 + 6 / 7 * (4 * C125 - 5 * C130 + C150 + 6 / 7 * (4 * C130 - 5 * C135 + C155 + 6 / 7 * (4 * C135 - 5 * C140 + C160 + 6 / 7 * (4 * C140 - 5 * C145 + C165 + 6 / 7 * (4 * C145 - 5 * C150 + C170 + 6 / 7 * (4 * C150 - 5 * C155 + C175 + 6 / 7 * (4 * C155 - 5 * C160 + C180 + 6 / 7 * (4 * C160 - 5 * C165 + C185 + 6 / 7 * (4 * C165 - 5 * C170 + C190 + 6 / 7 * (4 * C170 - 5 * C175 + C195 + 6 / 7 * (4 * C175 - 5 * C180 + C200 + 6 / 7 * (4 * C180 - 5 * C185 + C205 + 6 / 7 * (4 * C185 - 5 * C190 + C210 + 6 / 7 * (4 * C190 - 5 * C195 + C215 + 6 / 7 * (4 * C195 - 5 * C200 + C220 + 6 / 7 * (4 * C200 - 5 * C205 + C225 + 6 / 7 * (4 * C205 - 5 * C210 + C230 + 6 / 7 * (4 * C210 - 5 * C215 + C235 + 6 / 7 * (4 * C215 - 5 * C220 + C240 + 6 / 7 * (4 * C220 - 5 * C225 + C245))))))))))))))))))))))))))))))))))))))))))))) AND .153991764868743 * (4 * C5 - 5 * C10 + C30 + 12 / 13 * (4 * C10 - 5 * C15 + C35 + 12 / 13 * (4 * C15 - 5 * C20 + C40 + 12 / 13 * (4 * C20 - 5 * C25 + C45 + 12 / 13 * (4 * C25 - 5 * C30 + C50 + 12 / 13 * (4 * C30 - 5 * C35 + C55 + 12 / 13 * (4 * C35 - 5 * C40 + C60 + 12 / 13 * (4 * C40 - 5 * C45 + C65 + 12 / 13 * (4 * C45 - 5 * C50 + C70 + 12 / 13 * (4 * C50 - 5 * C55 + C75 + 12 / 13 * (4 * C55 - 5 * C60 + C80 + 12 / 13 * (4 * C60 - 5 * C65 + C85 + 12 / 13 * (4 * C65 - 5 * C70 + C90 + 12 / 13 * (4 * C70 - 5 * C75 + C95 + 12 / 13 * (4 * C75 - 5 * C80 + C100 + 12 / 13 * (4 * C80 - 5 * C85 + C105 + 12 / 13 * (4 * C85 - 5 * C90 + C110 + 12 / 13 * (4 * C90 - 5 * C95 + C115 + 12 / 13 * (4 * C95 - 5 * C100 + C120 + 12 / 13 * (4 * C100 - 5 * C105 + C125 + 12 / 13 * (4 * C105 - 5 * C110 + C130 + 12 / 13 * (4 * C110 - 5 * C115 + C135 + 12 / 13 * (4 * C115 - 5 * C120 + C140 + 12 / 13 * (4 * C120 - 5 * C125 + C145 + 12 / 13 * (4 * C125 - 5 * C130 + C150 + 12 / 13 * (4 * C130 - 5 * C135 + C155 + 12 / 13 * (4 * C135 - 5 * C140 + C160 + 12 / 13 * (4 * C140 - 5 * C145 + C165 + 12 / 13 * (4 * C145 - 5 * C150 + C170 + 12 / 13 * (4 * C150 - 5 * C155 + C175 + 12 / 13 * (4 * C155 - 5 * C160 + C180 + 12 / 13 * (4 * C160 - 5 * C165 + C185 + 12 / 13 * (4 * C165 - 5 * C170 + C190 + 12 / 13 * (4 * C170 - 5 * C175 + C195 + 12 / 13 * (4 * C175 - 5 * C180 + C200 + 12 / 13 * (4 * C180 - 5 * C185 + C205 + 12 / 13 * (4 * C185 - 5 * C190 + C210 + 12 / 13 * (4 * C190 - 5 * C195 + C215 + 12 / 13 * (4 * C195 - 5 * C200 + C220 + 12 / 13 * (4 * C200 - 5 * C205 + C225 + 12 / 13 * (4 * C205 - 5 * C210 + C230 + 12 / 13 * (4 * C210 - 5 * C215 + C235 + 12 / 13 * (4 * C215 - 5 * C220 + C240 + 12 / 13 * (4 * C220 - 5 * C225 + C245 + 12 / 13 * (4 * C225 - 5 * C230 + C250 + 12 / 13 * (4 * C230 - 5 * C235 + C255 + 12 / 13 * (4 * C235 - 5 * C240 + C260 + 12 / 13 * (4 * C240 - 5 * C245 + C265 + 12 / 13 * (4 * C245 - 5 * C250 + C270 + 12 / 13 * (4 * C250 - 5 * C255 + C275 + 12 / 13 * (4 * C255 - 5 * C260 + C280 + 12 / 13 * (4 * C260 - 5 * C265 + C285 + 12 / 13 * (4 * C265 - 5 * C270 + C290 + 12 / 13 * (4 * C270 - 5 * C275 + C295 + 12 / 13 * (4 * C275 - 5 * C280 + C300 + 12 / 13 * (4 * C280 - 5 * C285 + C305 + 12 / 13 * (4 * C285 - 5 * C290 + C310 + 12 / 13 * (4 * C290 - 5 * C295 + C315 + 12 / 13 * (4 * C295 - 5 * C300 + C320 + 12 / 13 * (4 * C300 - 5 * C305 + C325 + 12 / 13 * (4 * C305 - 5 * C310 + C330 + 12 / 13 * (4 * C310 - 5 * C315 + C335 + 12 / 13 * (4 * C315 - 5 * C320 + C340 + 12 / 13 * (4 * C320 - 5 * C325 + C345 + 12 / 13 * (4 * C325 - 5 * C330 + C350 + 12 / 13 * (4 * C330 - 5 * C335 + C355 + 12 / 13 * (4 * C335 - 5 * C340 + C360 + 12 / 13 * (4 * C340 - 5 * C345 + C365 + 12 / 13 * (4 * C345 - 5 * C350 + C370 + 12 / 13 * (4 * C350 - 5 * C355 + C375 + 12 / 13 * (4 * C355 - 5 * C360 + C380 + 12 / 13 * (4 * C360 - 5 * C365 + C385 + 12 / 13 * (4 * C365 - 5 * C370 + C390 + 12 / 13 * (4 * C370 - 5 * C375 + C395 + 12 / 13 * (4 * C375 - 5 * C380 + C400 + 12 / 13 * (4 * C380 - 5 * C385 + C405 + 12 / 13 * (4 * C385 - 5 * C390 + C410 + 12 / 13 * (4 * C390 - 5 * C395 + C415 + 12 / 13 * (4 * C395 - 5 * C400 + C420 + 12 / 13 * (4 * C400 - 5 * C405 + C425 + 12 / 13 * (4 * C405 - 5 * C410 + C430 + 12 / 13 * (4 * C410 - 5 * C415 + C435 + 12 / 13 * (4 * C415 - 5 * C420 + C440 + 12 / 13 * (4 * C420 - 5 * C425 + C445 + 12 / 13 * (4 * C425 - 5 * C430 + C450 + 12 / 13 * (4 * C430 - 5 * C435 + C455 + 12 / 13 * (4 * C435 - 5 * C440 + C460))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) < .142996048056393 * (4 * C5 - 5 * C10 + C30 + 6 / 7 * (4 * C10 - 5 * C15 + C35 + 6 / 7 * (4 * C15 - 5 * C20 + C40 + 6 / 7 * (4 * C20 - 5 * C25 + C45 + 6 / 7 * (4 * C25 - 5 * C30 + C50 + 6 / 7 * (4 * C30 - 5 * C35 + C55 + 6 / 7 * (4 * C35 - 5 * C40 + C60 + 6 / 7 * (4 * C40 - 5 * C45 + C65 + 6 / 7 * (4 * C45 - 5 * C50 + C70 + 6 / 7 * (4 * C50 - 5 * C55 + C75 + 6 / 7 * (4 * C55 - 5 * C60 + C80 + 6 / 7 * (4 * C60 - 5 * C65 + C85 + 6 / 7 * (4 * C65 - 5 * C70 + C90 + 6 / 7 * (4 * C70 - 5 * C75 + C95 + 6 / 7 * (4 * C75 - 5 * C80 + C100 + 6 / 7 * (4 * C80 - 5 * C85 + C105 + 6 / 7 * (4 * C85 - 5 * C90 + C110 + 6 / 7 * (4 * C90 - 5 * C95 + C115 + 6 / 7 * (4 * C95 - 5 * C100 + C120 + 6 / 7 * (4 * C100 - 5 * C105 + C125 + 6 / 7 * (4 * C105 - 5 * C110 + C130 + 6 / 7 * (4 * C110 - 5 * C115 + C135 + 6 / 7 * (4 * C115 - 5 * C120 + C140 + 6 / 7 * (4 * C120 - 5 * C125 + C145 + 6 / 7 * (4 * C125 - 5 * C130 + C150 + 6 / 7 * (4 * C130 - 5 * C135 + C155 + 6 / 7 * (4 * C135 - 5 * C140 + C160 + 6 / 7 * (4 * C140 - 5 * C145 + C165 + 6 / 7 * (4 * C145 - 5 * C150 + C170 + 6 / 7 * (4 * C150 - 5 * C155 + C175 + 6 / 7 * (4 * C155 - 5 * C160 + C180 + 6 / 7 * (4 * C160 - 5 * C165 + C185 + 6 / 7 * (4 * C165 - 5 * C170 + C190 + 6 / 7 * (4 * C170 - 5 * C175 + C195 + 6 / 7 * (4 * C175 - 5 * C180 + C200 + 6 / 7 * (4 * C180 - 5 * C185 + C205 + 6 / 7 * (4 * C185 - 5 * C190 + C210 + 6 / 7 * (4 * C190 - 5 * C195 + C215 + 6 / 7 * (4 * C195 - 5 * C200 + C220 + 6 / 7 * (4 * C200 - 5 * C205 + C225 + 6 / 7 * (4 * C205 - 5 * C210 + C230 + 6 / 7 * (4 * C210 - 5 * C215 + C235 + 6 / 7 * (4 * C215 - 5 * C220 + C240 + 6 / 7 * (4 * C220 - 5 * C225 + C245 + 6 / 7 * (4 * C225 - 5 * C230 + C250)))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dnhoward
Posted : Tuesday, February 3, 2009 6:23:26 PM
Registered User
Joined: 1/5/2007
Posts: 21
 Thanks Bruce!  I figured it would be big one.  I'll live with the slowness (or buy a faster PC) if it bothers me.  Many thanks for the excellent support and sharing your formula wizardly skills. 

dnhoward
Back to top
Bruce_L
Posted : Wednesday, February 4, 2009 9:27:50 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 dnhoward,
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.