some good queries to find good stocks for buying
1.finding stocks whose are closing in green from last n days
@COMMENT Returns No of days stock 's closing price is greater than opening price
#NoofDaysStockIsInGreen:barsince{close[0] < open[0] }
select symbol,close[0],volume[0],NoofDaysStockIsInGreen from table sortby NoofDaysStockIsInGreen
This query Returns No of days stock 's closing price is less than opening price
#NoofDaysStockIsInRed:barsince{close[0] > open[0] }
select symbol,close[0],volume[0],NoofDaysStockIsInRed from table sortby NoofDaysStockIsInRed
Returns No of days stock 's today's voume is greater than yesterday's volume
#NoofDaysVolumeIsUp:barsince{volume[0] < volume[-1] }
select symbol,close[0],volume[0],NoofDaysVolumeIsUp from table