Re: [EquisMetaStock Group] coding request

["Chander" <chander_20001@xxxxxxxx>]

Hi,

 

For this you have to create 2 exploration, 1st is Advance und 2nd is Decline.

 

For Advance

 

Col A= CLOSE

Col B= Ref(CLOSE, -1)

Filter= CLOSE > Ref(CLOSE, -1)

 

 

For Decline

 

Col A= CLOSE

Col B= Ref(CLOSE, -1)

Filter= CLOSE < Ref(CLOSE, -1)

 

 

 

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

From: georgeabraham3

To: equismetastock@xxxxxxxxxxxxxxx

Sent: Thursday, May 08, 2008 6:47 PM

Subject: [EquisMetaStock Group] coding request

Hi,

Reg: Coding request.

The data I down load daily consists of O,H,L,C,V and open
interest. I would like to find out on a particular day how many
stocks have gone up / down compared to the previous day. In the
explorer, in column A I had entered C>REF(C,-1). This shows me all
the stocks that have gone up compared to the previous day
(represented by 1 and 0). Now, comes the real problem.

In column A there are over 1800 stocks. In this column there
are hundreds of 1s and 0s. Instead of manually counting all the 1s
and 0s, is there any way to get the total of all the 1s and 0s (that
is, the total number of stocks that have gone up / down). I have
tried using CUM() AND SUM() functions but nothing seems to work. Can
any one please help me to get the answer?

Thanks,

George

__._,_.___

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

__,_._,___