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 4, 2018 5:12:55 PM
Gold Customer Gold Customer

Joined: 3/13/2015
Posts: 14
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 5, 2018 8:45:31 AM

Administration

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

Try this:

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

PradeepS
Posted : Monday, November 5, 2018 9:11:53 PM
Gold Customer Gold Customer

Joined: 3/13/2015
Posts: 14

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.