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

[mike milliken <mmilliken22@xxxxxxxxx>]

I would suggest to buy the FIRE Plug IN ...its worth it you want to use it to follow the breadth ...it won't give you the names but the gross number of S&P securities over their 20,50,&200 day moving average help point to the health of the market...i would ignore plug ins that pick turning point in the market - Mike

--- On Fri, 8/1/08, Pierre Tremblay <pt2000@xxxxxxxxxxxx> wrote:

From: Pierre Tremblay <pt2000@xxxxxxxxxxxx>
Subject: Re: [EquisMetaStock Group] To count total number of securities which are above 10 days moving average
To: equismetastock@xxxxxxxxxxxxxxx
Date: Friday, August 1, 2008, 4:49 PM

 

Suresh,

 

You can use the Explorer to do that.

 

In col A :

 

C <= MOV(C,10,E)

 

And in the filter :

 

col A

 

 

When you run the Exploration, you have to watch the "Percent Rejected". The last number you will see is the percentage of securities wich are above 10 days exponential moving average.

 

Pierre Tremblay

 

 

 

----- Original Message -----

From: Suresh Thanki

To: equismetastock@ yahoogroups. com

Sent: Friday, August 01, 2008 10:00 AM

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

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___