| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/19/2004
Posts: 130
|
Worden
Is there a PCF for avergae daily range of a stock in terms of dollars?
I have been using this formula (H-L)/AVGH21 - AVGL21) * 100
It does not give the range in dollars. For instance I would like a formula
that shows stocks that have a daily range from high to low over the last
30 days of $1.00 or more. Thank you.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
With the addition of a parenthesis, your formula is designed to show the current daily range as a percentage of the average daily range over the past 21 days:
(H - L) / (AVGH21 - AVGL21) * 100
A formula for the actual dollar value of the average range over the last 30 days being at least $1 would be:
AVGH30 - AVGL30 >= 1
I'm assuming this is what you want based on the title of the post and the rest of the content, but your actual request is more ambiguous, "...a daily range from high to low over the last 30 days of $1.00 or more." If more literal interpretation would be that the daily range itself over each of the last 30 days need to be at least $1 instead of the average being at least $1. You would need to explicitely test each day to determine if this is true:
H - L >= 1 AND H1 - L1 >= 1 AND H2 - L2 >= 1 AND H3 - L3 >= 1 AND H4 - L4 >= 1 AND H5 - L5 >= 1 AND H6 - L6 >= 1 AND H7 - L7 >= 1 AND H8 - L8 >= 1 AND H9 - L9 >= 1 AND H10 - L10 >= 1 AND H11 - L11 >= 1 AND H12 - L12 >= 1 AND H13 - L13 >= 1 AND H14 - L14 >= 1 AND H15 - L15 >= 1 AND H16 - L16 >= 1 AND H17 - L17 >= 1 AND H18 - L18 >= 1 AND H19 - L19 >= 1 AND H20 - L20 >= 1 AND H21 - L21 >= 1 AND H22 - L22 >= 1 AND H23 - L23 >= 1 AND H24 - L24 >= 1 AND H25 - L25 >= 1 AND H26 - L26 >= 1 AND H27 - L27 >= 1 AND H28 - L28 >= 1 AND H29 - L29 >= 1
You way wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/19/2004
Posts: 130
|
Bruce:
I have tried both of your formulas. And both work for different scans.
This helps me a great deal.
Many thanks for your time effort and understanding.
Winwon
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welome. I'm happy to read you found them both useful. I was not sure which would best suit your needs.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |