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

["Suresh Thanki" <bilipatra@xxxxxxxxx>]

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/