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/
|