| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 87
|
how do i write a pcf formula scan for the stock with unusual volume & price within past 30 day? thanks.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I need to get more specific....
I will assume "unusual volume" means above average volume. Do you want to find any stock that has had a day (in the past 21 market days) with volume above its average? If so, how much above? 200% the average volume? 300% the average? I also need you to decide how many days are used to average the volume. Average volume for the past 21 days, 125 days?
I have no idea what "unusual price" is. Do you mean abnormally wide trading range for the day? Abnormally high percent change from the previous day?
Answer these up for me and I will get you what you need.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/9/2005
Posts: 13
|
I have a similar question...I need a PCF to sort my Watchlist...sort by each stock's percentage gain today as compared to its average daily percentage fluctuation over a given time period...say 90 days. In essence, I am wanting to sort my Watchlist by those stocks whose current day percent gain (or loss) is high as compared to what its normal daily percentage fluctuation usually is. Any suggestions?
|
|
Registered User
Joined: 10/7/2004
Posts: 87
|
yes, i want to find the stock that has had a day with volume aboove its average in the past 21 market days,300% above average volume, used average volume for the past 200 days. thank you.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
What about the "unsual price" part?
Here is your PCF for the volume part:
V>AVGV21 AND V>(AVGV200*3)
- Craig
Here to Help!
|
|
Registered User
Joined: 10/9/2005
Posts: 13
|
Craig...any suggestions for my question...should I post it by itself?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Sorry, missed it.
What you are looking for is abnormally high price moves. Rank any WatchList by this condition and you should find them:
Abs Change as % of Avg Daily Range
100*ABS(C-C1)/(AVGH90-AVGL90)
It is not comparing the close to close changes over time but comparing the change today to the stocks average daily volatility. Do the sort, it found some nice moves.
Here is another version that incorporates volume as well... makes for another nice sort:
(ABS(C-C1)/(AVGH90-AVGL90))+(V/AVGV90)
Sort by it to see what it finds.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 87
|
sorry, i mean the price that move up or down sharply with the high volume.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
rchen,
Try sorting any WatchList by this PCF:
(ABS(C-C1)/(AVGH90-AVGL90))+(V/AVGV90)
Sort in descending order.
If you are not familiar with how to make the formula above a PCF, check out this video:
Using EasyScan to find stocks that meet your own criteria
If you are not familiar with how to sort a WatchList, check out this video:
Create your own stock rankings using WatchLists and Sort conditions
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 87
|
thanks, craig.
another question, how do i write the pcf to find the stock that has move side way (has not break out yet) between 14 day to 60 day?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Try sorting by these PCFs in ASCENDING order:
Trend/Consolidate 14-day
100*(MAXH14-MINL14)/(AVGH14-AVGL14)
Trend/Consolidate 30-day
100*(MAXH30-MINL30)/(AVGH30-AVGL30)
Trend/Consolidate 30-day
100*(MAXH60-MINL60)/(AVGH60-AVGL60)
OR you can combine them:
100*(((MAXH14-MINL14)/(AVGH14-AVGL14)) +((MAXH30-MINL30)/(AVGH30-AVGL30)) +((MAXH60-MINL60)/(AVGH60-AVGL60)))
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
rchen,
Suppose you would like to identify when unusually high volume and unusually large price change occur simultaneously. That is essentially the raison d'être of Bollinger Bands.
Please plot C-C1 and V as Custom Indicators. Now, place a BB(20,20) on each. Observe the simultaneous occurrence of C-C1 outside its bands and V above its upper band and you have what you want. Adjust the Bollinger Bands as desired.
Once you have the desired BB settings, you can obtain a PCF for the conditions.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 10/7/2004
Posts: 87
|
thanks craig.
and thank you jim.
|
|
Registered User
Joined: 5/19/2008
Posts: 1
|
Hello,
I can't seem to figure out a easyscan or pcf for the following situation:
I want to sort stocks based on the daily price fluctuation between the daily high and daily low. Say for example I want to get all stocks which have had an average daily price fluctuation of at least 10 % over the last lets say 90 days
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
manpreetsanghera,
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
Please try the following:
Percent Difference of 90-Period Average Range at least 10%:
100 * (AVGH90 / AVGL90 - 1) >= 10
90-Period Average of Range Percent Difference at least 10%:
100 * ((H / L + H1 / L1 + H2 / L2 + H3 / L3 + H4 / L4 + H5 / L5 + H6 / L6 + H7 / L7 + H8 / L8 + H9 / L9 + H10 / L10 + H11 / L11 + H12 / L12 + H13 / L13 + H14 / L14 + H15 / L15 + H16 / L16 + H17 / L17 + H18 / L18 + H19 / L19 + H20 / L20 + H21 / L21 + H22 / L22 + H23 / L23 + H24 / L24 + H25 / L25 + H26 / L26 + H27 / L27 + H28 / L28 + H29 / L29 + H30 / L30 + H31 / L31 + H32 / L32 + H33 / L33 + H34 / L34 + H35 / L35 + H36 / L36 + H37 / L37 + H38 / L38 + H39 / L39 + H40 / L40 + H41 / L41 + H42 / L42 + H43 / L43 + H44 / L44 + H45 / L45 + H46 / L46 + H47 / L47 + H48 / L48 + H49 / L49 + H50 / L50 + H51 / L51 + H52 / L52 + H53 / L53 + H54 / L54 + H55 / L55 + H56 / L56 + H57 / L57 + H58 / L58 + H59 / L59 + H60 / L60 + H61 / L61 + H62 / L62 + H63 / L63 + H64 / L64 + H65 / L65 + H66 / L66 + H67 / L67 + H68 / L68 + H69 / L69 + H70 / L70 + H71 / L71 + H72 / L72 + H73 / L73 + H74 / L74 + H75 / L75 + H76 / L76 + H77 / L77 + H78 / L78 + H79 / L79 + H80 / L80 + H81 / L81 + H82 / L82 + H83 / L83 + H84 / L84 + H85 / L85 + H86 / L86 + H87 / L87 + H88 / L88 + H89 / L89) / 90 - 1) >= 10
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |