[mailto: @yahoogroups.com] On Behalf Of
p_panther_73
Sent: Friday, August 01, 2008 12:35 PM
To:
equismetastock@xxxxxxxxxxxxxxx
Subject: Re: [EquisMetaStock Group] To
count total number of securities which are above 10 days moving
average
Well actually it can be down, though time consuming
You have to write a
lot of formulas, each containing something like
this:
a1:=security("write security's name
here",c);
a2:=...................;
.;
.;
a10:=..................;
a1>mov(a1,10,s)+a2>mov(a2,10,s)+..+a10>mov(a10,10,s)
You
name this formula for e.g. "above sma10 nr1"
Then you create more and
more and finally you get the sum in a new
formula name it for e.g. "above
sma10 all" containing
fml("above sma10 nr1")+fml("above sma10
nr2)+...
But, very time consuming
Have a nice weekend
--- In equismetastock@yahoogroups.com,
"L.P. Carhartt" <lc@xxx> wrote:
>
> Hi Suresh,
>
> I don't think you can do in MetaStock as is. The way I do
similar
> calculations is to do them in Excel or other code outside of
MetaStock and
> then output the results in .csv format. Those .csv
files are
easily used
> immediately and directly in MetaStock using
the MetaStockCSV Plug-in
> available at http://www.metastockcsv.com (one of
my sites). I use
the
> plug-in regularly for my own stock analysis and
ETF work. There is
no data
> import or conversion process for .csv
datafiles.
>
> Good luck.
> Best,
>
> L. P.
Carhartt
>
>
> _____
>
> From: equismetastock@yahoogroups.com
[mailto:equismetastock@yahoogroups.com]
>
On Behalf Of Suresh Thanki
> Sent: Friday, August 01, 2008 7:00 AM
>
To: equismetastock@yahoogroups.com
>
Subject: [EquisMetaStock Group] To count total number of securities
which
> are above 10 days moving average
>
>
>
> Dear All,
>
> How to write the formula in MS to count the
total number (and/or
> percentage) of securities which are above 10 days
moving average
> within the group of securities like S & P 500 or any
other Index
> group ?
>
> I have a database of securities
traded on particular day.
>
> In simple arithmetic form, I want to
know,
>
> % = Number of scrip above 10 days moving average *100 /
> Total number of scrip traded on that day
>
> Suresh
Thanki
>