Registered User
Joined: 12/17/2008
Posts: 25
|
I'm looking for a PCF. Which will eliminate any 4 % breakdown in my scan with a volume of 100,000. in the last 5 days or 10 days For example IF the stock had red day of 4 % today and volume exceeded 100,000. I want to eliminate the stock. Also would be interested in the similar PCF where we have 4% breakdown but the volume below the 50 day volume ma.Thanks in advance.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A Personal Criteria Formula to identify any symbol with at least a 4% breakdown on at least 100,000 shares Volume during any one of the most recent 10-Bars could be written as:
(C / C1 <= .96 AND V >= 1000) OR (C1 / C2 <= .96 AND V1 >= 1000) OR (C2 / C3 <= .96 AND V2 >= 1000) OR (C3 / C4 <= .96 AND V3 >= 1000) OR (C4 / C5 <= .96 AND V4 >= 1000) OR (C5 / C6 <= .96 AND V5 >= 1000) OR (C6 / C7 <= .96 AND V6 >= 1000) OR (C7 / C8 <= .96 AND V7 >= 1000) OR (C8 / C9 <= .96 AND V8 >= 1000) OR (C9 / C10 <= .96 AND V9 >= 1000)
You would want the reverse of this if you wanted to eliminate stocks in an EasyScan however. You could just put the entire thing inside of NOT():
NOT((C / C1 <= .96 AND V >= 1000) OR (C1 / C2 <= .96 AND V1 >= 1000) OR (C2 / C3 <= .96 AND V2 >= 1000) OR (C3 / C4 <= .96 AND V3 >= 1000) OR (C4 / C5 <= .96 AND V4 >= 1000) OR (C5 / C6 <= .96 AND V5 >= 1000) OR (C6 / C7 <= .96 AND V6 >= 1000) OR (C7 / C8 <= .96 AND V7 >= 1000) OR (C8 / C9 <= .96 AND V8 >= 1000) OR (C9 / C10 <= .96 AND V9 >= 1000))
But a shorter way to write this would be:
(C / C1 > .96 OR V < 1000) AND (C1 / C2 > .96 OR V1 < 1000) AND (C2 / C3 > .96 OR V2 < 1000) AND (C3 / C4 > .96 OR V3 < 1000) AND (C4 / C5 > .96 OR V4 < 1000) AND (C5 / C6 > .96 OR V5 < 1000) AND (C6 / C7 > .96 OR V6 < 1000) AND (C7 / C8 > .96 OR V7 < 1000) AND (C8 / C9 > .96 OR V8 < 1000) AND (C9 / C10 > .96 OR V9 < 1000)
A Personal Criteria Formula to identify any symbol with at least a 4% breakdown with Volume below the 50-Period Simple Moving Average of Volume during any one of the most recent 10-Bars could be written as:
(C / C1 <= .96 AND V < AVGV50) OR (C1 / C2 < .96 AND V1 <= AVGV50.1) OR (C2 / C3 <= .96 AND V2 < AVGV50.2) OR (C3 / C4 <= .96 AND V3 < AVGV50.3) OR (C4 / C5 <= .96 AND V4 < AVGV50.4) OR (C5 / C6 <= .96 AND V5 < AVGV50.5) OR (C6 / C7 <= .96 AND V6 < AVGV50.6) OR (C7 / C8 <= .96 AND V7 < AVGV50.7) OR (C8 / C9 <= .96 AND V8 < AVGV50.8) OR (C9 / C10 <= .96 AND V9 < AVGV50.9)
You would want the reverse of this if you wanted to eliminate stocks in an EasyScan however. You could just put the entire thing inside of NOT():
NOT((C / C1 <= .96 AND V < AVGV50) OR (C1 / C2 < .96 AND V1 <= AVGV50.1) OR (C2 / C3 <= .96 AND V2 < AVGV50.2) OR (C3 / C4 <= .96 AND V3 < AVGV50.3) OR (C4 / C5 <= .96 AND V4 < AVGV50.4) OR (C5 / C6 <= .96 AND V5 < AVGV50.5) OR (C6 / C7 <= .96 AND V6 < AVGV50.6) OR (C7 / C8 <= .96 AND V7 < AVGV50.7) OR (C8 / C9 <= .96 AND V8 < AVGV50.8) OR (C9 / C10 <= .96 AND V9 < AVGV50.9))
But a shorter way to write this would be:
(C / C1 > .96 OR V >= AVGV50) AND (C1 / C2 > .96 OR V1 > AVGV50.1) AND (C2 / C3 > .96 OR V2 >= AVGV50.2) AND (C3 / C4 > .96 OR V3 >= AVGV50.3) AND (C4 / C5 > .96 OR V4 >= AVGV50.4) AND (C5 / C6 > .96 OR V5 >= AVGV50.5) AND (C6 / C7 > .96 OR V6 >= AVGV50.6) AND (C7 / C8 > .96 OR V7 >= AVGV50.7) AND (C8 / C9 > .96 OR V8 >= AVGV50.8) AND (C9 / C10 > .96 OR V9 >= AVGV50.9)
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Awesome. Let me try and see what kind of results. I'll get. Thx u so much.
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
IF i have to do the same thing but i dont consider volume would the below PCF be correct. No 4 % breakdown in last 10 days.(C / C1 > .96) AND (C1 / C2 >= .96 ) AND (C2 / C3 > .96 ) AND (C3 / C4 > .96 ) AND (C4 / C5 > .96 ) AND (C5 / C6 > .96) AND (C6 / C7 > .96) AND (C7 / C8 > .96 ) AND (C8 / C9 > .96) AND (C9 / C10 > .96)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It looks correct to me.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
CAVM showed up on my list. it had a 4% breakdown 7th day.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In testing your formula against CAVM, I did find an error in that it has (C1 / C2 >= .96 ) instead of (C1 / C2 > .96), but this does not affect the results for CAVM.
How are you determining if the formula is True for CAVM? It does not show up in an EasyScan using your Personal Criteria Formula as the only EasyScan Condition and it does not show as being True when the PCF is used as a Sort or WatchList Column.
Using EasyScan to find stocks that meet your own criteria
Create your own stock rankings using WatchLists and Sort conditions
Customize the Information Displayed in the WatchList
Using the formula as a Custom Percent True Indicator reveals that it has not returned True for CAVM since 10/18/2010.
Visually Backtesting Specific Symbols
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Yes I'm using an easyscan Here are my creterias:
200 dma in uptrend - True
150 dma in uptrend - True
50 dma over 200 dma - True
Price above $5 - True
4% bo with volume in last 3 days 150k = C >= 1.04 * C1 AND MINV3 >= 1500 AND V > V1
* No -4% bd in last 10 d &vol below 20dma = (C / C1 >= .96 OR V >= AVGV20) AND (C1 / C2 >= .96 OR V1 > AVGV20.1) AND (C2 / C3 > .96 OR V2 >= AVGV20.2) AND (C3 / C4 > .96 OR V3 >= AVGV20.3) AND (C4 / C5 > .96 OR V4 >= AVGV20.4) AND (C5 / C6 > .96 OR V5 >= AVGV20.5) AND (C6 / C7 > .96 OR V6 >= AVGV20.6) AND (C7 / C8 > .96 OR V7 >= AVGV20.7) AND (C8 / C9 > .96 OR V8 >= AVGV20.8) AND (C9 / C10 > .96 OR V9 >= AVGV20.9)
Look at NTGR its showing up and 4% breakdown happen yesterday.
I appreciate all your help.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, NTGR had a 4% breakdown happen yesterday, but its Volume was above its 20-Period Simple Moving Average yesterday.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Oh duh. I want the volume to below 20 dma in all the 10 days too. I'm so stupid.
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Bruce dont worry about the reply. I think I would use only the N-4% breakdown in the last days without the averages and use visuals to pick the stocks.You been a great help. I didnt knew I could ask questions like that.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. I'm happy to read you found my assistance helpful.
The Volume below its average was an easy thing to miss. I stared at it for a bit before figuring it out.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Is this a correct formula for the below situations
Volume below or equal to 50 dma fro the last 5 days
(V1 <= AVGV50.1
AND
V2 <= AVGV50.2
AND
V3 <= AVGV50.3
AND
V4 <= AVGV50.4
AND
V5 <= AVGV50.5)
Also Last 5 day price between -3 % and 3%
(0.97 <=C/C1 <=1.03)
AND
(0.97 <=C1/C2 <=1.03)
AND
(0.97 <=C2/C3 <=1.03)
AND
(0.97 <=C3/C4 <=1.03)
AND
(0.97 <=C4/C5 <=1.03)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following formula does in fact check for Volume to be less than its 50-Period Simple Moving Average for the previous 5-Bars:
V1 <= AVGV50.1 AND V2 <= AVGV50.2 AND V3 <= AVGV50.3 AND V4 <= AVGV50.4 AND V5 <= AVGV50.5
Your Price Percent Change formula is missing some ANDs however:
.97 <= C / C1 AND C / C1 <= 1.03 AND .97 <= C1 / C2 AND C1 / C2 <= 1.03 AND .97 <= C2 / C3 AND C2 / C3 <= 1.03 AND .97 <= C3 / C4 AND C3 / C4 <= 1.03 AND .97 <= C4 / C5 AND C4 / C5 <= 1.03
In addition, there is some inconsistency in the use of the word last. The first formula is using last 5 days to mean the previous 5-Bars (1-Bar ago through 5-Bars Ago) while the second formula is using last 5 days to mean the most recent 5-Bars (0-Bars Ago through 4-Bars Ago).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
I'm so sorry I didnt get your point on 1 bar ago through 5 bars ago or 0 bars and 4 bars agoWhat I'm trying to do is lets say today when I run my scan EOD. last 5 days counting eod today ha less than 50 dma volume and price is between -3% and 3%
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The current Day (counting today) is 0-Bars from now. Your second formula represents this, but your first formula is currently for yesterday through 5-Days Ago instead. If you want it to be today through 4-Days Ago (the most recent 5-Days), you would want to write it as:
V <= AVGV50 AND V1 <= AVGV50.1 AND V2 <= AVGV50.2 AND V3 <= AVGV50.3 AND V4 <= AVGV50.4
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
I see what you are saying. Let me play with the scans and see what I get at EOD. Once I put my whole scan I'll share my logic what I'm trying to do and you can tell me from a logic standpoint it works or not.Thank you so much.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
This should give us 1 day go to 5 days ago right.
(0.97 <= C1 / C2 AND C1 / C2 <= 1.03)
AND
(0.97 <= C2 / C3 AND C2 / C3 <= 1.03)
AND
(0.97 <= C3 / C4 AND C3 / C4 <= 1.03)
AND
(0.97 <= C4 / C5 AND C4 / C5 <= 1.03)
AND
(0.97 <= C5 / C6 AND C5 / C6 <= 1.03)
We are getting there.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, that is a Personal Criteria Formula for 1 day ago through 5 days ago.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
200 dma in uptrend - True
150 dma in uptrend - True
50 dma over 200 dma - True
Price above $5 - True
avg vol past 50 days over 100k
Last 5 days vol below 50dma 1 day ago to 5 day ago
(V1 <= AVGV50 AND V2 <= AVGV50 AND V3 <= AVGV50 AND V4 <= AVGV50 AND V5 <= AVGV50)
Last 5 days Price -3% and 3% 1 day ago to 5 day ago
(0.97 <= C1 / C2 AND C1 / C2 <= 1.03) AND (0.97 <= C2 / C3 AND C2 / C3 <= 1.03) AND (0.97 <= C3 / C4 AND C3 / C4 <= 1.03) AND (0.97 <= C4 / C5 AND C4 / C5 <= 1.03) AND (0.97 <= C5 / C6 AND C5 / C6 <= 1.03)
Now what I want is to create another PCF for this easyscan which would give me C current price makes a moves positive move but its not a gap up and price is at least 3% move with above avg volume.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
How are you defining a Gap Up? Previous High to current Low? Previous High to current Open? Previous Close to current Low? Previous Close to current Open? Something else entirely?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
All good questions, my take it would make sense using Previous Close to current Low? If you think it doesnt make sense let me know
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I have had people request formulas using all four definitions. I really couldn't say what makes sense or not.
C >= C1 * 1.03 AND L <= C1 AND V > AVGV50
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
If i do Previous Close to current Open, I just do this.
C >= C1 * 1.03 AND O <= C1 AND V > AVGV50
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Exactly.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Bruce I'm so sorry I'm bugging you this much. But I looked at the scan
C >= C1 * 1.03 AND O or L <= C1 AND V > AVGV50
this doesnt give me what I want.
So this what I'm thinking of doing this:
Volume is higher than the prior day
and the price Closes in the top 1/3 of the day range
and the price made a move for more than 3% and not more than 10 %
C >= C1*1.03 and C <= C1*1.10
AND
V >V1
Dont know how to created price close is in 1/3 of the day range
So if you can help me with it and validate my formula that would be great
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
H - C < (H - L) / 3
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
C >= C1*1.03 and C <= C1*1.10 AND V >V1
AND
H - C < (H - L) / 3
Thank you so much for your help. Enjoy your evening.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
A thrust pattern is simply a day in which the range (High - Low) is two or more times the average range of the preceding 20 days; the volume is higher than the volume of the prior day. Would you mind creating this for me.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
H - L >= 2 * (AVGH20.1 - AVGL20.1) AND H > L AND V > V1
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/17/2008
Posts: 25
|
Is there a way to calculate and create an PCF average 50 volume/latest float *100. I cant figure out how to use latest float in PCF. If we cant use in a PCF how can we accomplish the above logic in telechart.Thanks for your help in advance.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I do not know of a way to do so using TeleChart as TeleChart's Personal Criteria Formula Language does not have syntax for referencing fundamentals.
It should probably be noted that it is possible to do so using StockFinder Platinum.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |