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

["Ed Hoopes" <reefbreak_sd@xxxxxxxxx>]

I use other TA software(I've been flamed here for mentioning the name)
which can take the results of an Exploration and perform additional
calculations - they call it a "SCAN".

Using this I routinely track about 600 ETF's each day.  I've been
using it for several years - it works.



--- In equismetastock@xxxxxxxxxxxxxxx, "L.P. Carhartt" <lc@xxx> wrote:
>
>  
> Very enlightening.  Some of you guys never cease to amaze me.  
>  
> Best,
> 
> L. P. Carhartt 
> 
>  
> 
>   [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@ <mailto:equismetastock%40yahoogroups.com>
> yahoogroups.com, "L.P. Carhartt" <lc@> 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.metastoc <http://www.metastockcsv.com>
kcsv.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@ <mailto:equismetastock%40yahoogroups.com>
> yahoogroups.com 
> [mailto:equismetastock@ <mailto:equismetastock%40yahoogroups.com>
> yahoogroups.com]
> > On Behalf Of Suresh Thanki
> > Sent: Friday, August 01, 2008 7:00 AM
> > To: equismetastock@ <mailto:equismetastock%40yahoogroups.com>
> 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
> >
>



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

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/