Trying to filter a Symbol list into only symbols with 250k shares < SMA(volume,21) <1M shares
Author: cravens
Creation Date: 4/23/2012 12:59 PM
profile picture

cravens

#1

4/23/2012 12:59 PM

I want to take a large data set with various volumes and extract out only those symbols with the 21 day moving average of volume between 250k shares and 1M shares. The output should be printed in the debug window. The following code should do this but does not. An example that it fails to remove from the new is is ABIO.

This code is verbose but it should catch all conditions in the volume range. It also looks for price>$5.

Does anyone know why ABIO and others fail?



CODE:
Please log in to see this code.
profile picture

Eugene

#2

4/23/2012 1:37 PM

CODE:
Please log in to see this code.

If SMA > 2.5 million shares... not 250,000 ;)
profile picture

cravens

#3

4/24/2012 2:17 PM

thanks. I've been staring it too long.

Rob
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).