Hi Kong,
I may be wrong, but I don't think that you can call a stock
or another equity, that has today a higher close and/or a higher volume than
yesterday a topgainer!
What you could do is taking a longer period!
So replace the -1 by e.g. -10 or -22 or -66 or - 250.
Depending on the fact if you are a shortperiodtrader, a medium-one or a
buy&hold investor.
You can do about the same thing by a Rate of
Change.formula:ROC(C,65,%).
This is the ROC of the close in percentage of a 65 days
period.
Again you can change the 65 in whatever period you
want.
This formula is computing the period from close to
close.
Miko should use ROC (C,250,%) if he wants the Rate of change
from about a year back till now.
The ROC could also use the High or the Low, or as Miko
suggested the HHV (HighestHighValue) and the LLV (LowestLowValue) over a
certain period of time.
I hope I'm not confusing you to much, but there is another
way.
Instead of using the close, some people use a moving average
of the close. Because the results become less "choppy"then.
THe Rate of Change will be the change between a moving
average of the close and the same moving average of the close in a certain
period.
I like to use A ROC over the same period but in steps (e.g.
22 days) back. So I can see what is the change of the ROC over the last 22
days, the period from 44 days back til 22 days back, the period of 66 days
back till 44 days back andso on.
All this, what I'm trying to tell you , you can find in the
manual or the helpfile which goes by Metastock.
And Miko, for counting the number of stocks that are
fitting a certain rule, you can perhaps ask Roy Larsen.
His email is in this group and perhaps he is willing to help
you!
You and all the members a happy and healthy
2010.
Kees Takkenberg.
----- Original Message -----
Sent: Saturday, January 02, 2010 12:32
AM
Subject: RE: [EquisMetaStock Group]
Help!
Hi,
The coding to find top gainers is C - Ref(C,-1) you can put it
in column A, you may also put V on column B.
C - Ref(C,-1) means
today's closing price minus yesterday's closing price, V means
volume.
From col A after exploration, you click on col A it changes
to small/big numbers and click again changes to big/small number. The
biggest number is topgainers.
The same to col B, big number is the
higher volume.
Kong
To: equismetastock@
yahoogroups.com
From:
mikosayo@xxxxxxcom
Date: Fri, 1 Jan 2010 01:59:38 +0000
Subject:
Re: [EquisMetaStock Group] Help!
Hi Kong,
Some people are built for coding. I
guess I simply am not.
I know my inquiries may be very elementary and
it's like I'm asking to be spoon-fed but it's really tough for me cause I
don't even know anyone personally at all who knows how to do coding in
Metastock. There are hardly only a handful of people who uses Metastock here
in Manila.
With regards to my first inquiry, to get the top gainers
from a specific date, I noticed in other explorations that people use the
ROC indicator but I can't seem to figure out how to inject a specific date
into it say, top gainers from Jan 1, 2009. Should I use "Highest Since"? but
how?
With regards to my second inquiry, to get the number of stocks
in my database, which are above the 200-day moving average. How do I make
Metastock count the number of stocks that are above the 200-day MA, instead
of telling me what the value of the moving average is or instead of telling
me whether the price is above or below the moving average?
Any help
or hint would be very much appreciated.
Happy New
Year!
Regards,
Miko
--- In
equismetastock@yahoogroups.com,
Leh Kee Kong <lkkong969@x
..> wrote:
>
>
>
> Enclose is MetaStock Forumla Primer may be useful to you.
>
> Happy New Year.
>
> Kong
>
>
__________________________________________________________
>
Windows 7: Find the right PC for you. Learn more.
> http://windows.microsoft.com/shop
>
Windows 7: Find the right PC for you.
Learn more.