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

Avergae Daily Range Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
winwon
Posted : Friday, April 10, 2009 5:05:59 AM
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.
Bruce_L
Posted : Friday, April 10, 2009 7:19:07 AM


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
winwon
Posted : Friday, April 10, 2009 2:08:52 PM
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
Bruce_L
Posted : Friday, April 10, 2009 3:17:59 PM


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