[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Metastockusers] How do I incorporate a volume filter on each period search??



PureBytes Links

Trading Reference Links

		
Exploration notes:To find stocks which fluctuated up and down in price
		on a regular cycle and so the cycle could be traded.
		What I have ended up with so far is a formula which
		demonstrates the price trend over 2,4,6,8 and 10
		periods(days) the results give +ve and -ve values and
		you will see that a high -ve value demonstrates an
		upwards trend in the price while the opposite a high  
+ve value a downwards trend in the price.	
		
Col A: Close	CLOSE	
Col B: %2Period	(((Sum(CLOSE,3)-(CLOSE))/2)/CLOSE*100)-100	
Col C: %5Period	(((Sum(CLOSE,6)-(CLOSE))/5)/CLOSE*100)-100	
Col D: %10Peri	(((Sum(CLOSE,11)-(CLOSE))/10)/CLOSE*100)-100	
Col E: %20Peri	(((Sum(CLOSE,21)-(CLOSE))/20)/CLOSE*100)-100	
Col F: %30Perio	(((Sum(CLOSE,31)-(CLOSE))/30)/CLOSE*100)-100	
Filter	CLOSE>0.5 AND CLOSE<8 AND VOLUME> 250000	
		
Filter enabled	Yes	
Periodicity	Daily	
Records required	1300	


As you can see the volume filter currently only filters the last 
period. How can I modify the formula so that the volume criteria is 
appled to each and every period. I have try two different approaches 
but no luck with either. Any help would be appreciated.
John



To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/