Fellow Worderner's and Bruce,
I was wondering if there are any particular scans you use to find uptrending stocks. My minimal criteria of filtering stocks are as follows:
Average Day Range (20 Periods) > 3.5%
Average Volume (62 Periods) > 100000
Price between $0.2 and $30.00
Exchange: AMEX, Nasdaq and NYSE
Captilization > 40
I have a (bad) habit of trying to find the bottom, it works many times but now I invest a large amount of savings so I want to play it safe. I managed to find the bottom with the likes of CARA, HIIQ (at $3.80), CWEI (bottom at $6.65 and ran to $140, amazing homerun that was) and more. But also made some bad trades.
If you have a look at the tickers GLF, ADPT, VRX, VNCE, CXRX, CIE, TDW -- these have all downtrending. I want to invest in opposite of these stocks, these are my typical candidates when I try to find the bottom. Very risky stocks. I'm not a bear and I don't short-sell stocks.
I would like to find uptrending stocks like CWEI (ran last year from $6.5 to $100+), CARA, CGIX, AMD, IMMU, IMGN, EVRI, INAP, etc...
Please can you provide PCF for following formulas:
1) Stocks that are currently in an upward trend (like FUEL, IDRA, CGIX, PNRA)
2) Stocks that are upward trending but are currently having a pullback (like CARA some periods ago)
3) Stocks that have hit a bottom (some periods ago) and are now uptrending (look at IMGN, it shot up and moved sideways; again it shot up and now its moving sideways, I feel another spike is coming). Main thing im looking for is that the continuous 52W bottoms is over, (yes one can never be sure). Other tickers, that have bottomed and uptrending are ATNM and IDRA.
4) Find stocks that gain +/- 30% (i.e. swing) multiple times in a period of 3 months, i.e. look at NE, AGEN, CBK, KERX. These typically dont make new 52W highs or lows, but trade in some range.
Hope this helps others.
|
Hi
I've never used alerts on tc2000 and today I tried to setup an alert but it didn't fire. I sent a test message on the alert panel and I received it. However when I created an actual alert I didn't receive an email.
I have a couple of questions
Are alerts only operational during market hours?
Do I need to keep tc2000 software open to receive alerts?
My test alert didn't fire, bear in mind I tested after the markets had closed but tc2000 was open.
Alert condition
Microsoft msft price above 1.
This condition is always true as Microsoft is trading above 30 dollars.
Also, I'm a gold user.
|
Set timeframe to daily
C > C1
|
Bruce,
Long formulas are not managable and are often messy. I spent the entire weeklend last week changing my formulas from V16 to V17 shorter versions.
The ability to allow C(x) or Cx to use the value returned from a function would be great.
It'd be great if it can be implemented, it would help me and many others.
Having said that, thanks for help.
|
Bruce,
I'm trying to extend this formula further and want to use it in another column to tell me the change in % since the crossover.
this is the formula i'm using:
IIF(C <= AVGC50, -1, TrueInRow(C > AVGC50, 50))
I'm using this formula to calculate change since the crossover
((C - Cx) / Cx ) * 100
My understanding that Cx or C(x) returns the price closing price at period x.
My formula becomes becomes
((C - C(IIF(C <= AVGC50, -1, TrueInRow(C > AVGC50, 50))) / IIF(C <= AVGC50, -1, TrueInRow(C > AVGC50, 50))) * 100
However, its not working as expected, because it multiplies the price with the value returned from function, i.e.
it becomes like below for example:
(65 - 60(50) / 60(50)) * 100
Please help, i need to know the change % since the crossover, how do i do it?
|
I had the same issue in V16, it appears to be a bug.
Back in 2016, I was using Moving Linear Regression 16 periods crossing up 2 Period Simple Moving Average Linear Regression 16, it didnt work. It looks like its still not fixed.
|
Wow this is amazing, the reduction in length of formulas in V17 is mind boggling.
Thanks Bruce
|
And this
QUOTE
((100 * (1 - L / MAXC22) < 85 * (1 - L1 / MAXC22.1) OR 100 * (1 - L / MAXC22) < 85 * (1 - L2 / MAXC22.2) OR 100 * (1 - L / MAXC22) < 85 * (1 - L3 / MAXC22.3) OR 100 * (1 - L / MAXC22) < 85 * (1 - L4 / MAXC22.4) OR 100 * (1 - L / MAXC22) < 85 * (1 - L5 / MAXC22.5) OR 100 * (1 - L / MAXC22) < 85 * (1 - L6 / MAXC22.6) OR 100 * (1 - L / MAXC22) < 85 * (1 - L7 / MAXC22.7) OR 100 * (1 - L / MAXC22) < 85 * (1 - L8 / MAXC22.8) OR 100 * (1 - L / MAXC22) < 85 * (1 - L9 / MAXC22.9) OR 100 * (1 - L / MAXC22) < 85 * (1 - L10 / MAXC22.10) OR 100 * (1 - L / MAXC22) < 85 * (1 - L11 / MAXC22.11) OR 100 * (1 - L / MAXC22) < 85 * (1 - L12 / MAXC22.12) OR 100 * (1 - L / MAXC22) < 85 * (1 - L13 / MAXC22.13) OR 100 * (1 - L / MAXC22) < 85 * (1 - L14 / MAXC22.14) OR 100 * (1 - L / MAXC22) < 85 * (1 - L15 / MAXC22.15) OR 100 * (1 - L / MAXC22) < 85 * (1 - L16 / MAXC22.16) OR 100 * (1 - L / MAXC22) < 85 * (1 - L17 / MAXC22.17) OR 100 * (1 - L / MAXC22) < 85 * (1 - L18 / MAXC22.18) OR 100 * (1 - L / MAXC22) < 85 * (1 - L19 / MAXC22.19) OR 100 * (1 - L / MAXC22) < 85 * (1 - L20 / MAXC22.20) OR 100 * (1 - L / MAXC22) < 85 * (1 - L21 / MAXC22.21) OR 100 * (1 - L / MAXC22) < 85 * (1 - L22 / MAXC22.22) OR 100 * (1 - L / MAXC22) < 85 * (1 - L23 / MAXC22.23) OR 100 * (1 - L / MAXC22) < 85 * (1 - L24 / MAXC22.24) OR 100 * (1 - L / MAXC22) < 85 * (1 - L25 / MAXC22.25) OR 100 * (1 - L / MAXC22) < 85 * (1 - L26 / MAXC22.26) OR 100 * (1 - L / MAXC22) < 85 * (1 - L27 / MAXC22.27) OR 100 * (1 - L / MAXC22) < 85 * (1 - L28 / MAXC22.28) OR 100 * (1 - L / MAXC22) < 85 * (1 - L29 / MAXC22.29) OR 100 * (1 - L / MAXC22) < 85 * (1 - L30 / MAXC22.30) OR 100 * (1 - L / MAXC22) < 85 * (1 - L31 / MAXC22.31) OR 100 * (1 - L / MAXC22) < 85 * (1 - L32 / MAXC22.32) OR 100 * (1 - L / MAXC22) < 85 * (1 - L33 / MAXC22.33) OR 100 * (1 - L / MAXC22) < 85 * (1 - L34 / MAXC22.34) OR 100 * (1 - L / MAXC22) < 85 * (1 - L35 / MAXC22.35) OR 100 * (1 - L / MAXC22) < 85 * (1 - L36 / MAXC22.36) OR 100 * (1 - L / MAXC22) < 85 * (1 - L37 / MAXC22.37) OR 100 * (1 - L / MAXC22) < 85 * (1 - L38 / MAXC22.38) OR 100 * (1 - L / MAXC22) < 85 * (1 - L39 / MAXC22.39) OR 100 * (1 - L / MAXC22) < 85 * (1 - L40 / MAXC22.40) OR 100 * (1 - L / MAXC22) < 85 * (1 - L41 / MAXC22.41) OR 100 * (1 - L / MAXC22) < 85 * (1 - L42 / MAXC22.42) OR 100 * (1 - L / MAXC22) < 85 * (1 - L43 / MAXC22.43) OR 100 * (1 - L / MAXC22) < 85 * (1 - L44 / MAXC22.44) OR 100 * (1 - L / MAXC22) < 85 * (1 - L45 / MAXC22.45) OR 100 * (1 - L / MAXC22) < 85 * (1 - L46 / MAXC22.46) OR 100 * (1 - L / MAXC22) < 85 * (1 - L47 / MAXC22.47) OR 100 * (1 - L / MAXC22) < 85 * (1 - L48 / MAXC22.48) OR 100 * (1 - L / MAXC22) < 85 * (1 - L49 / MAXC22.49)) AND (1 - L / MAXC22) < (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)) AND ((100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L49 / MAXC22.49) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L50 / MAXC22.50)) OR (1 - L1 / MAXC22.1) >= (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) + 2 * SQR(ABS((1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 + (1 - L20 / MAXC22.20) ^ 2 - 20 * (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) ^ 2) / 20))
|
QUOTE (Bruce_L)
Then add another Custom PCF Indicator to the same pane and scale as the first one, but with the Plot Style set to Histogram, the color set to green and the following Formula.
100 * (1 - L / MAXC22) / ABS((100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20))
A Condition Formula to use as an EasyScan Condition to check for green bars can be written as follows.
How to create and save a Condition (PCF) Formula
How to Create an EasyScan and save it to the Library
(100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)
Bruce,
Can the two formulas above be shortened in TC2000 V17
|