New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

How to find stocks with an average daily range over 4.5%? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
PradeepS
Posted : Sunday, November 04, 2018 5:12:55 PM
Registered User
Joined: 3/13/2015
Posts: 5
How to find stocks with an average daily range over 4.5%(intraday high minus intraday low). The average should be taken over at least 20 days.?I have the below PCF. Is this correct? Can somebody please help me?
 
((H21-L21)+(H20-L20)+(H19-L19)+(H18-L18)+(H17-L17)+(H16-L16)+(H15-L15)+(H14-L14)+(H13-L13)+(H12-L12)+(H11-L11)+(H10-L10)+(H9-L9)+(H8-L8)+(H7-L7)+(H6-L6)+(H5-L5)+(H4-L4)+(H3-L3)+(H2-L2)+(H1-L1))/20) > 4.5
 
Thanks,
Pradeep
StockGuy
Posted : Monday, November 05, 2018 8:45:31 AM

Administration

Joined: 9/30/2004
Posts: 9,129

Try this:

AVG((H-L)/C,20) >.045

PradeepS
Posted : Monday, November 05, 2018 9:11:53 PM
Registered User
Joined: 3/13/2015
Posts: 5

Thanks!

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.