All Companies Moving Averages

#5
Excellent Query for Moving Averages.One should use both + and - percentage values to get both, closing values above the moving avg. price( eg. +5.0) and closing values below the moving avg. price( eg. -5.0 )
 
#7
Dear Friends,
Thanks for the replies.I think Manish u are right that we should use both +ve and -ve values to get the price values above and below the moving averages.
 
#8
Dear friends,
There is one more that I saw at http://www.fortunemakerindia.com/QSpecific for specific moving averages values for closing price and volume for 5,10,20,50,100 and 200 days.
I think the best way to use the queries would be, first to scan the companies near their moving averages by the first query and then use the specific one to get all the price and volume averages in a go.
 
Last edited: