Re: [EquisMetaStock Group] To count total number of securities which are above 10 days moving average

["p_panther_73" <mchantzi@xxxxxxxxx>]

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@xxxxxxxxxxxxxxx, "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@xxxxxxxxxxxxxxx 
[mailto:equismetastock@xxxxxxxxxxxxxxx]
> On Behalf Of Suresh Thanki
> Sent: Friday, August 01, 2008 7:00 AM
> To: equismetastock@xxxxxxxxxxxxxxx
> 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
>



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/