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

[Pierre Tremblay <pt2000@xxxxxxxxxxxx>]

 

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@xxxxxxxxxxxxxxx

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

__,_._,___