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
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Try this:
AVG((H-L)/C,20) >.045
|
Gold Customer
Joined: 3/13/2015 Posts: 14
|
Thanks!
|