|
PureBytes Links
Trading Reference Links
|
Just to put this in perspective, writing a plug-in for MetaStock to generate
recent composite / breadth data on the fly is relatively easy. The problem
for longer periods is the massive amount of data that must be crunched. To
generate historical composite / breadth data on the 30 indexes and 111 ETFs
on our compilation list means calculating data on over 4000 issues and then
combining that together for the last 20 years (or start date of the index or
ETF) into the appropriate indexes and ETFs. Maintaining accurate
constituent lists is a daily task. They change frequently and there is no
notification mechanism provided by the index / ETF sponsors. Certainly,
there is a whole list of required maintenance tasks. When I started this
project five years ago, I had no idea how much was involved to provide good,
accurate and timely composite / breadth data.
Lets take an index such as the S&P 500 Index. To generate that historical
data outside of MetaStock takes a good 5 minutes on a very fast computer
(and that is only one index). Data begins at 1990. When doing historical
testing, the longer the history the better. If you are only worried about
recent data, doing it on the fly is OK. But to do any serious analysis,
historical data is needed. Someday, computers will be fast enough to
generate the needed historical data on demand. But as fast as they are
today, they are not nearly fast enough.
Best
L.P. Carhartt
http://www.masterdatacompositeplugin.com
________________________________
From: equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx]
On Behalf Of Colin Manahan
Sent: Thursday, May 08, 2008 10:55 AM
To: equismetastock@xxxxxxxxxxxxxxx
Cc: equismetastock@xxxxxxxxxxxxxxx
Subject: Re: RE: [EquisMetaStock Group] coding request
Adaptick has an add-on called Fire that calculates a vareity of broad market
measures and you can define what the markets are. I have been using this
for a couple of years and it works wonderful.
----- Original Message -----
From: "L.P. Carhartt" <lc@xxxxxxxxxxxxxx>
Date: Thursday, May 8, 2008 11:15
Subject: RE: [EquisMetaStock Group] coding request
To: equismetastock@xxxxxxxxxxxxxxx
>
> 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/
|