Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF for Stocks Trading $2 per Share or More Each Day Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bw5trades
Posted : Monday, March 6, 2006 9:16:54 PM
Registered User
Joined: 4/11/2005
Posts: 24
Craig,

Can you help me with a PCF that finds stocks trading (up or down) $2 per share or more each day. It would help if the Range Selector could be used instead of True/Flase results.

Thanks for the assistance.

bobw
Craig_S
Posted : Monday, March 6, 2006 9:21:58 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Over how many days?

This will return the average net range for the past year:

AVGH250-AVGL250

- Craig
Here to Help!
diceman
Posted : Monday, March 6, 2006 11:56:14 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
bw5trades

If your not concerned about price direction. ( UP or DOWN )

You could try:

ABS(C-C1)

Set the range selector for approximately 2 or higher.

Hope that helps

Good Luck
Stmjd74
Posted : Tuesday, March 7, 2006 12:55:43 AM
Registered User
Joined: 12/18/2004
Posts: 180
Here's a pretty cool idea you might want to try. It returns the percentage of days of the last 20 days that a stock's absolute distance from the previous day's closing price was $2 or greater. At the time I posted this, you should be getting 100% for GOOG, and 50% for AAPL. You could use the copy and past and delete functions to adjust it to whatever length you like.

( - 100) * ((H >= C1 + 2 OR L<=C1-2) + (H1 >= C2 + 2 OR L1<=C2-2) +(H2 >= C3 + 2 OR L2<=C3-2) + (H3 >= C4 + 2 OR L3<=C4-2) + (H4 >= C5 + 2 OR L4<=C5-2) + (H5>= C6 + 2 OR L5<=C6-2)+ (H6 >= C7 + 2 OR L6<=C7-2) + (H7 >= C8 + 2 OR L7<=C8-2) +(H8 >= C9 + 2 OR L8<=C9-2) + (H9 >= C10 + 2 OR L9<=C10-2) + (H10 >= C11 + 2 OR L10<=C11-2)+ (H11 >= C12 + 2 OR L11<=C12-2) + (H12 >= C13 + 2 OR L12<=C13-2) + (H13 >= C14 + 2 OR L13<=C14-2) +(H14 >= C15 + 2 OR L14<=C15-2) + (H15 >= C16 + 2 OR L15<=C16-2) + (H16 >= C17 + 2 OR L16<=C17-2)+(H17 >= C18 + 2 OR L17<=C18-2) + (H18 >= C19 + 2 OR L18<=C19-2)+(H19 >= C20 + 2 OR L19<=C20-2)) / 20
Stmjd74
Posted : Tuesday, March 7, 2006 4:43:53 AM
Registered User
Joined: 12/18/2004
Posts: 180
Here's another way you write that:

(-100) *(((H-L+ABS(H+L-2*C1))/2>=2) +((H1-L1+ABS(H1+L1-2*C2))/2>=2) +((H2-L2+ABS(H2+L2-2*C3))/2>=2) +((H3-L3+ABS(H3+L3-2*C4))/2>=2) +((H4-L4+ABS(H4+L4-2*C5))/2>=2) +((H5-L5+ABS(H5+L5-2*C6))/2>=2) +((H6-L6+ABS(H6+L6-2*C7))/2>=2) +((H7-L7+ABS(H7+L7-2*C8))/2>=2) +((H8-L8+ABS(H8+L8-2*C9))/2>=2) +((H9-L9+ABS(H9+L9-2*C10))/2>=2) +((H10-L10+ABS(H10+L10-2*C11))/2>=2) +((H11-L11+ABS(H11+L11-2*C12))/2>=2) +((H12-L12+ABS(H12+L12-2*C13))/2>=2) +((H13-L13+ABS(H13+L13-2*C14))/2>=2) +((H14-L14+ABS(H14+L14-2*C15))/2>=2) +((H15-L15+ABS(H15+L15-2*C16))/2>=2) +((H16-L16+ABS(H16+L16-2*C17))/2>=2) +((H17-L17+ABS(H17+L17-2*C18))/2>=2) +((H18-L18+ABS(H18+L18-2*C19))/2>=2) +((H19-L19+ABS(H19+L19-2*C20))/2>=2))/20

Credit bustermu. It should return the same result (again, you could adjust it for more or less than 20 days).
bw5trades
Posted : Tuesday, March 7, 2006 10:09:49 AM
Registered User
Joined: 4/11/2005
Posts: 24
Thanks to all for such a range of solutions.

Initially, I thought I wanted to wee results over one trading month ... now I,m going to explore a number of other options.

Appreciate the assistance and quick response.

bobw
Stmjd74
Posted : Wednesday, March 8, 2006 2:03:08 AM
Registered User
Joined: 12/18/2004
Posts: 180
bw,

I should have just posted that last one as:

(-100) *((H-L+ABS(H+L-2*C1)>=4) +(H1-L1+ABS(H1+L1-2*C2)>=4) +(H2-L2+ABS(H2+L2-2*C3)>=4) +(H3-L3+ABS(H3+L3-2*C4)>=4) +(H4-L4+ABS(H4+L4-2*C5)>=4) +(H5-L5+ABS(H5+L5-2*C6)>=4) +(H6-L6+ABS(H6+L6-2*C7)>=4) +(H7-L7+ABS(H7+L7-2*C8)>=4) +(H8-L8+ABS(H8+L8-2*C9)>=4) +(H9-L9+ABS(H9+L9-2*C10)>=4) +(H10-L10+ABS(H10+L10-2*C11)>=4) +(H11-L11+ABS(H11+L11-2*C12)>=4) +(H12-L12+ABS(H12+L12-2*C13)>=4) +(H13-L13+ABS(H13+L13-2*C14)>=4) +(H14-L14+ABS(H14+L14-2*C15)>=4) +(H15-L15+ABS(H15+L15-2*C16)>=4) +(H16-L16+ABS(H16+L16-2*C17)>=4) +(H17-L17+ABS(H17+L17-2*C18)>=4) +(H18-L18+ABS(H18+L18-2*C19)>=4) +(H19-L19+ABS(H19+L19-2*C20)>=4))/20

and skipped all the "/2" crap. It should still give the same result. Sorry.
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.