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.
__._,_.___
![]()
__,_._,___
|