hello all
I am trying to accomplish the
following:--
In first column no. of securities which have fallen
continuously
for three or more days for ex
abc 3
abd 3
acd 4
def 5
xyz 6
zxz 6 to last
possible no.
In second column change in security's price from
the date it started falling to current date(ROC of 3 days if it fell
3 straight or 4 days if it fell 4 straight days etc)
In third column securities which
have risen for 3 or more straight days for ex
abc 0 0
3
abd 0 0 3
acd 0 0 4
def 0
0 5
xyz 0
0 6
zxz 0 0 7
to last possible no.
And in the fourth column change in security's
price from the date it started rising to current date(ROC of 3
days if it rose 3 straight days or 4 days if it rose 4
straight days etc)
It seems to me that this is quite difficult , but I
am also sure that nothing is impossible for the esteemed members of this
group.
I had posted a similar query few days back and
had got accurate solution from Mr Jose.
I am hoping that will get a solution for this one
also.
Safdar
Yahoo! Groups Sponsor |
ADVERTISEMENT
| |
|
Yahoo! Groups Links
|