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 |

Profile: usmansajid
About
User Name: usmansajid
Groups: Gold User, Member, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, March 17, 2016
Last Visit: Monday, June 18, 2018 6:01:43 AM
Number of Posts: 48
[0.02% of all post / 0.02 posts per day]
Avatar
Last 10 Posts
Topic: Uptrending Stocks - Scan Ideas
Posted: Monday, March 27, 2017 3:16:41 AM

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.

Topic: Unable to receive alerts
Posted: Friday, March 10, 2017 7:03:54 PM

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.

Topic: price easy scan question
Posted: Tuesday, February 7, 2017 10:19:33 AM

Set timeframe to daily

C > C1

Topic: Version 17 - X Bars Ago as an indicator (Feature Request)
Posted: Tuesday, February 7, 2017 7:10:35 AM

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. 

 

 

 

Topic: Version 17 - X Bars Ago as an indicator (Feature Request)
Posted: Monday, February 6, 2017 5:10:40 PM

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&#39;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? 
 
Topic: Moving Linear Regression scan crossing Price
Posted: Thursday, February 2, 2017 6:17:08 PM

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.

Topic: PCF For Williams Vix Fix - Finds Market Bottoms
Posted: Thursday, February 2, 2017 3:14:16 PM

Wow this is amazing, the reduction in length of formulas in V17 is mind boggling.

 

 

Thanks Bruce

Topic: PCF For Williams Vix Fix - Finds Market Bottoms
Posted: Thursday, February 2, 2017 1:35:51 PM

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

Topic: PCF For Williams Vix Fix - Finds Market Bottoms
Posted: Thursday, February 2, 2017 1:21:56 PM

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

Topic: Pre market data
Posted: Wednesday, February 1, 2017 9:05:57 AM

+1 to bryceln