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 |

unusual price & volume for pcf formula? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rchen
Posted : Friday, March 17, 2006 1:51:07 PM
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.
Craig_S
Posted : Friday, March 17, 2006 2:16:48 PM


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!
absorrel4
Posted : Friday, March 17, 2006 7:49:24 PM
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?
rchen
Posted : Saturday, March 18, 2006 3:28:18 PM
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.
Craig_S
Posted : Saturday, March 18, 2006 3:31:47 PM


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!
absorrel4
Posted : Saturday, March 18, 2006 8:19:00 PM
Registered User
Joined: 10/9/2005
Posts: 13
Craig...any suggestions for my question...should I post it by itself?
Craig_S
Posted : Saturday, March 18, 2006 8:24:36 PM


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!
rchen
Posted : Monday, March 20, 2006 9:37:23 AM
Registered User
Joined: 10/7/2004
Posts: 87
sorry, i mean the price that move up or down sharply with the high volume.
Craig_S
Posted : Monday, March 20, 2006 9:42:03 AM


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!
rchen
Posted : Monday, March 20, 2006 10:22:04 AM
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?
Craig_S
Posted : Monday, March 20, 2006 10:25:43 AM


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!
bustermu
Posted : Monday, March 20, 2006 9:01:28 PM
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

rchen
Posted : Tuesday, March 21, 2006 10:00:23 AM
Registered User
Joined: 10/7/2004
Posts: 87
thanks craig.
and thank you jim.
manpreetsanghera
Posted : Thursday, August 14, 2008 4:01:02 AM
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
Bruce_L
Posted : Thursday, August 14, 2008 8:48:01 AM


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