|
PureBytes Links
Trading Reference Links
|
Hi George,
Don't know of any way within MetaStock. MetaStock was not designed to work
with or generate composite / breadth data. The number you are looking for
is called "Advances" and is widely used in composite / breadth market
analysis. The reciprocal is "Declines" and then there are the statistics
"Advancing Volume", "Declining Volume", "New Highs", "New Lows" and many,
many others compiled on composites like indexes and ETFs or, in your case, a
basket of stocks.
The only way, I found to do what you want done is to compile the data
outside of MetaStock and then build a mechanism for letting MetaStock use
that data without import or conversion. In other words, automatically.
The result was the MasterDATA Composite Plug-in which now compiles composite
/ breadth data on 30 major stock indexes and the 111 highest trade volume
ETFs. Instead of developing your own software to do what you want to do,
you might consider simply working with existing composites (indexes and
ETFs). If you do, my plug-in and data will do the job plus some.
BTW, I have heard of other software that supposedly generates the data you
want. But the ones I looked at really don't perform for what you want or
take forever to process the data.
Good luck. Hope this helps.
L.P. Carhartt
http://www.masterdatacompositeplugin.com
________________________________
From: equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx]
On Behalf Of georgeabraham3
Sent: Thursday, May 08, 2008 6:18 AM
To: equismetastock@xxxxxxxxxxxxxxx
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
------------------------------------
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/
|