Chorlton,
This should be able to get the result you
are looking for.
V>Mov(V,30,S)*3
Regards,
Tim Hyder
-------------------------------------------------------
A successful man is one
who can build a firm foundation with the bricks that others throw at him.
David Brinkley
-------------------------------------------------------
From:
equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx] On Behalf Of chorlton_c_hardy
Sent: Sunday, 2 October 2005 02:45
To: equismetastock@xxxxxxxxxxxxxxx
Subject: [EquisMetaStock Group]
Trying to find stocks which have shown a High Volume Spike
Hi All,
I'm trying to write a simple exploration that
identifies stocks
which have seen a high volume spike.
Ideally, I want to be able to select only those
stocks which have
seen a volume spike which equates to at least 3
times the average
volume for the last 30 days.
I've already written a simple formula (see below)
but when i run it
about 80-85% of my stocks are selected regardless
of whether they
satisfy the formula :-(
V*0.3 > LastValue(Sum(V,30)/30)
Can anyone suggest a different formula that would
only select the
stocks which I'm after??
Any Help much appreciated
YAHOO! GROUPS LINKS