[EquisMetaStock Group] coding request

["georgeabraham3" <georgeabraham3@xxxxxxxxxxx>]

  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


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

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/