| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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!
|
|
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
|
|
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
|
|
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).
|
|
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
|
|
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.
|
|
|
Guest-1 |