PureBytes Links
Trading Reference Links
|
<SPAN
class=009222716-06052003>Jayson,
<SPAN
class=009222716-06052003>
you´re
darn rite. The mistake was on my part. Do you have an idea why Ron specified in
his indexing filter "OR Group index equad yes"? I thought the exclusion of
symbols containing "!" has already done the same ?
<SPAN
class=009222716-06052003>
I´m
trying to build an addtocomposite from exactly the same symbols as Ron does in
AB.
<SPAN
class=009222716-06052003>
Can´t
be THAT difficult!!!
<SPAN
class=009222716-06052003>
<SPAN
class=009222716-06052003>Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Tuesday, May 06, 2003 6:41 PM
Subject: RE: [amibroker] JAYSON: Creating
IM200 indices
<SPAN
class=009222716-06052003>Markus,
They
will not be similar unless your composites are being built on the same
information. If you are creating them using the "All stocks" filter than you
are probably also including all the indexes in your data base in the
calculations. As you point out Ron uses an index filter. Try going to qp2 and
applying just that filter. Now save the list via export. Bring this list into
AB via the import routine. Now build your composites using the same stocks
that Ron does. You could alternatively use the routine that TJ shared with you
assuming all of Ron's filter criteria can be duplicated. Also please note the
code you used below uses "I" to calculate the count list not "V" therefore
part of your problem is that you are dividing closing data by volume when you
really want to divide closing data by the open interest "I"
field...... x=c/i not c/v
<FONT
face="Courier New" color=#6600aa> <FONT
color=#0000ff>
sym="~"+IndustryID(1<FONT face="Courier New"
color=#6600aa>);
<FONT
size=2>
AddToComposite(<FONT
color=#000000>C<FONT
color=#6600aa>,sym,"C"<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New" color=#0000ff>
AddToComposite(<FONT
color=#000000>O<FONT
color=#6600aa>,sym,"O"<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New" color=#0000ff>
AddToComposite(<FONT
color=#000000>H<FONT
color=#6600aa>,sym,"H"<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New" color=#0000ff>
AddToComposite(<FONT
color=#000000>L<FONT
color=#6600aa>,sym,"L"<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New" color=#0000ff>
AddToComposite(<FONT
color=#000000>V<FONT
color=#6600aa>,sym,"V"<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New"><FONT
face=Arial>
AddToComposite(1,sym,"I"<FONT
face=Arial>);<SPAN
class=009222716-06052003> this is
your counter
Regards,
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Tuesday, May 06, 2003 12:11
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker]
JAYSON: Creating IM200 indices
Jayson,
I did what you suggested (see attached). The
green line chanrt is the original IM200 Banking West Chart and the red line
chart is the addtocomposite index, smoothed by volume.
There seem to be remarkable differences that may
or may not be attributed to the fact that Ron filters with his indexing filter
which you know.
Still, the unsmoothed bar chart built from
addtocomposite (see my initial post) looks much more familiar when compared to
the respective IM200 bar chart.
Any clue?
Would you mind sharing your code for creating the
"original" IM200 indexes by addtocomposite?
Thanks
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, May 05, 2003 3:57
PM
Subject: RE: [amibroker] JAYSON:
Creating IM200 indices
<SPAN
class=834112113-05052003>Markus,
<SPAN
class=834112113-05052003>
<SPAN
class=834112113-05052003>The filter you have added is not added to your
composite. To do so simply explore your data base with the filter than use
the results of that exploration to create a watchlist. When you run the scan
to create your composites use this newly created watchlist. A different
method is to apply all your criteria in QP2 then simply export the results
of this filter as a QP list file. AB allows you to import QP list files as a
watchlist.......
<SPAN
class=834112113-05052003>
<SPAN
class=834112113-05052003>Different values..... Some one (sorry I do not
recall who) on this list suggested a short time ago that the only way to
construct an index was to utilize a method of adding and subtracting the sum
of the individual components Rate of Change to the components as opposed to
simply summing the value of each stock. The theory (I believe) was that this
mitigated the moves of larger stocks versus their smaller brethren. I spent
a fair amount of time comparing the two methods and found that much as you
see here that the primary difference appeared (to me) to be differences in
scale. QP apparently uses a similar algorithm as the one described earlier
on this BB. For my use the curve is what I need, if you are trying to match
values with QP you will need a different approach.
<SPAN
class=834112113-05052003>
<SPAN
class=834112113-05052003>When you compare the smoothed version (line chart)
are you finding the curve to be dramatically different then the QP chart?
Try this by commenting out your bar chart then comparing the line to a line
chart of the QP index....... I think your curve will be
similar..
Regards,
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Monday, May 05, 2003 8:44
AMTo: Amibroker (Yahoo-Forum)Subject: Fw: [amibroker]
JAYSON: Creating IM200 indices
Oops,
forgot the attachment
Markus
----- Original Message -----
From: <A
title=funnybiz@xxxxxx href="">IVA GmbH
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, May 05, 2003 2:40 PM
Subject: Re: [amibroker] JAYSON: Creating IM200
indices
Jayson,
there is one thing you may have noticed that I
can´t explain to myself:
I created to addtocomposites as suggested by
you as
Filter<FONT face="Courier New"
color=#6600aa>=Minimum=<FONT face="Courier New"
color=#0000ff>MA<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>Volume<FONT face="Courier New"
color=#6600aa>,50<FONT
face="Courier New" color=#6600aa>)>=<FONT face="Courier New"
color=#ff00ff>20000;
sym="~"<FONT
face="Courier New" color=#6600aa>+<FONT face="Courier New"
color=#0000ff>IndustryID<FONT face="Courier New"
color=#6600aa>(1<FONT
face="Courier New" color=#6600aa>); <FONT face="Courier New"
color=#0000ff>
AddToComposite<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>C<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"C"<FONT face="Courier New"
color=#6600aa>);
AddToComposite<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>O<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"O"<FONT face="Courier New"
color=#6600aa>);
AddToComposite<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>H<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"H"<FONT face="Courier New"
color=#6600aa>);
AddToComposite<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>L<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"L"<FONT face="Courier New"
color=#6600aa>);
AddToComposite<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#000000>V<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"V");
AddToComposite(<FONT
face="Courier New" color=#ff00ff>1<FONT face="Courier New"
color=#6600aa>,sym,<FONT face="Courier New"
color=#ff00ff>"I"<FONT face="Courier New"
color=#6600aa>);
Buy=<FONT
face="Courier New" color=#ff00ff>0<FONT face="Courier New"
color=#6600aa>;
plotted them as line chart in the pice window
(see attachment) where I smoothed the values as discussed:<FONT
face=Arial size=2>
sym="~"<FONT
face="Courier New" color=#6600aa>+<FONT face="Courier New"
color=#0000ff>IndustryID<FONT face="Courier New"
color=#6600aa>(1<FONT
face="Courier New" color=#6600aa>);<FONT face="Courier New"
color=#000000>
C=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"C"<FONT face="Courier New"
color=#6600aa>);
O=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"o"<FONT face="Courier New"
color=#6600aa>);
H=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"h"<FONT face="Courier New"
color=#6600aa>);
L=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"l"<FONT face="Courier New"
color=#6600aa>);
V=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"V");
x=C<FONT
face="Courier New" color=#6600aa>/<FONT face="Courier New"
color=#000000>V;
PlotForeign(<FONT
face="Courier New" color=#ff00ff>"x"<FONT face="Courier New"
color=#6600aa>,<FONT face="Courier New"
color=#ff00ff>"sym"<FONT face="Courier New"
color=#6600aa>,colorbrightYellow,<FONT face="Courier New"
color=#000000>styleLine|
<FONT face="Courier New"
color=#000000>styleOwnScale<FONT face="Courier New"
color=#6600aa>);
Now, when you compare QP2´s IM200 and the ones created by addtocomposite
(I´m not sure if the filter used by me took effect (see above), you´ll
realize that the SHAPE of the unsmoothed addtocomposites looks much more
similar to the IM200 indices than the "smothed" equivalent (line chart).
Though the values between addtocomposite bar chart and IM200 bar chart
differ remarkably.
Do you know what might have caused that? Maybe you could provide your
code soe that I could rebuild the Im200 indices thru addtocomposite
properly?
Thanks for your assistance again!
Markus
2./ Is it possible to plot the name of the
corresponding group index rather than just "Group Index"? Plot(c,"sym",
stylebar) doesn´t do that
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Sunday, May 04, 2003 4:58
PM
Subject: RE: [amibroker] JAYSON:
Creating IM200 indices
<SPAN
class=804274505-04052003>Markus,
<SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>See between lines..
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: <A
href="">funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Saturday, May 03, 2003 9:06
PMTo: <A
href="">amibroker@xxxxxxxxxxxxxxxSubject:
[amibroker] JAYSON: Creating IM200 indices
Jayson,
regarding your kind aswer a while ago, I´d
still like to use your expertise.
A few things still aren´t clear to
me:
1./don´t I have to divide the
composite values of open, high, low and close (each) thru the number of
symbols computed to get an AVERAGE price? Otherwhise, the price of
all securities maybe just summed up but no AVERAGE price would be
computed, right? Can´t I specify this in addtocomposite directly
instead of having to create a separate indicator???????<FONT
color=#0000ff><SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>How would you do that? Since the composite does
not know the total number of stocks until the scan is complete.
This is why we use addtocomposite(1,"V") to store the count
to Volume
2./ You mentioned data holes and
recommended to smoothem by dividing by "V". Isnt´that exactly what I´m
asking at 1./ above?Insn´t there another flaw that we include stocks to
our composites that have differing lastvalue(cum(1)) values?? <FONT
color=#0000ff><SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>See my answer above. W e take an average to
smooth out jumps in price, a big gap on earnings etc. Yes there is a flaw
when we find holes and now that flaw is addressed with Tomasz's new
Database Purify tool
Take for instance two stocks one of which has 200 bars
and the other has 400 bars of which the composite index is to be
created.
Wouldn´t we then get weird data since the stock with
only 200 bars would impact on the chart after 200 (actually
199) days??<SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>
You
are talking about new issues? Interesting..... yes a new issue would
impact the data as our new closing data will be added...... But would it
be accurate to not include those new tickers TODAY. Because today
they do in fact contribute to the composites move. This new data being
added is also being mitigated by an increase in the count when the ticker
is added.
<SPAN
class=804274505-04052003>
If
you wanted to strip the new issues from the composite you could check for
bars as a filter using barsindex()= "Your minimum number" but I
question if that would be wise. Would you want to strip CSCO simply based
on when it was originally issued? It is too important today to simply
ignore the stock. I guess the real question is what are you doing with the
data? Trading today or yesterday? If you want to only include all stocks
if they all existed at a given date then you must first create a watchlist
of stocks with a minimum number of bars. You could initially explore the
universe for Barindex() then sort the results to see which stocks to
include in your watchlist, or alternatively to see at which point in
history you wish to begin using the composite
data.....
<SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>
Shouldn´t we thus check that all the stocks included in
our composite tickers have the SAME # of bars, i.e. ALL contribute to the
index EVERY day on the chart? Otherwhise the index chart could jump around
and create wrong impression similar to what you referred to as data holes,
right?
How could I specify that in my
addtocomposite()?
3./ How could I admit only stocks to my indices
with an MA(vol,50)>20,000? By putting that in a filter IN
FRONT of the addtocomposite function or by using and IIF
statement WITHIN the addtocomposite statement ITSELF??<FONT
color=#0000ff><SPAN
class=804274505-04052003>
<SPAN
class=804274505-04052003>
Again
I would do it at the point of watchlist creation. Filter for the criteria
and only add those stocks meeting the criteria to your Master
watchlist
4./ I put the following code in a separate indicator
window. Note that I used PlotOHLC since I wanted bar charts<FONT
face="Courier New" color=#6600aa>. The weird thing is that I get bar
charts but in the tool tip windwo, I get only the bars closing price!!!
Why is that??? <SPAN
class=804274505-04052003>
<FONT face=Arial
color=#0000ff><SPAN
class=804274505-04052003>
<FONT face=Arial
color=#0000ff>Since you have renamed OHLC
and volume you can simply Plot the data there is no need to use
plotOHLC...try
<FONT face=Arial
color=#0000ff><SPAN
class=804274505-04052003>
<FONT face=Arial
color=#0000ff>plot(c,"Group Index",
colorwhite,64);
<FONT face=Arial
color=#0000ff><SPAN
class=804274505-04052003>
<FONT face=Arial
color=#0000ff><FONT
face=Arial><FONT face="Courier New"
color=#6600aa><SPAN
class=804274505-04052003>jayson<FONT
size=2>
sym="~"<FONT
face="Courier New" color=#6600aa>+<FONT face="Courier New"
color=#0000ff>IndustryID<FONT face="Courier New"
color=#6600aa>(1<FONT
face="Courier New" color=#6600aa>);<FONT
face="Courier New" color=#000000>
C=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"C"<FONT face="Courier New"
color=#6600aa>);<FONT face="Courier New"
color=#000000>
O=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"o"<FONT face="Courier New"
color=#6600aa>);<FONT face="Courier New"
color=#000000>
H=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"h"<FONT face="Courier New"
color=#6600aa>);<FONT face="Courier New"
color=#000000>
L=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"l"<FONT face="Courier New"
color=#6600aa>);<FONT face="Courier New"
color=#000000>
V=<FONT
face="Courier New" color=#0000ff>Foreign<FONT face="Courier New"
color=#6600aa>(sym,<FONT face="Courier New"
color=#ff00ff>"V"<FONT face="Courier New"
color=#6600aa>);
PlotOHLC(<FONT
face="Courier New" color=#000000>O<FONT face="Courier New"
color=#6600aa>,<FONT face="Courier New"
color=#000000>H<FONT face="Courier New"
color=#6600aa>,<FONT face="Courier New"
color=#000000>L<FONT face="Courier New"
color=#6600aa>,<FONT face="Courier New"
color=#000000>C<FONT face="Courier New"
color=#6600aa>,"Group
index",<FONT
face="Courier New" color=#000000>colorWhite<FONT
size=2>,<FONT
face="Courier New" color=#000000>styleBar<FONT
face="Courier New" color=#6600aa>);
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Thursday, April 24, 2003 4:04
PM
Subject: RE: [amibroker] Creating
IM200 indices - JAYSON
<FONT face=Arial
size=2>
<SPAN
class=678142113-24042003>Markus,
<SPAN
class=678142113-24042003>see answers below...
<SPAN
class=678142113-24042003>
Hello Jayson,
don´t ya worry!
You´ve already helped me a great
deal in understanding the "basix" of
Addtocomposite.
1./ somehow my indices have been
stored in -->markets-->market253 AND group
253. While I understand the latter, I don´t understand the former.
Is this a MUST?<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>I think markets 253 is equivalent to All your
stocks and tickers. I am not sure what you are doing but I tend to break
that group into watch lists for testing and explorations. For instance
you could create a watch list of Nas 100 stocks. This watchlist would
contain stocks that reside in the new list AND market
253........
2./ I used the "x" option for the
field code, figuring that would enable me to make a bar chart from it
(since OHLC are updated). But this is NOT the case. I get only. No way
to produce a bar chart as in HGS/QP2 from it?? I thought of generating 4
ATC´s (one for Open, one for High etc.) but how to bring those together
in one index bar for each trading day :-((((<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>Yes you may plot candles but think about what
you were trying to do....
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003><FONT
face=Arial> AddToComposite<FONT
color=#282828>(C<FONT
face=Arial>,sym,<FONT
color=#ff00ff>"X"); would not this
populate closing value through out all the fields? try......<FONT
color=#0000ff>
<SPAN
class=678142113-24042003>
<FONT
color=#0000ff><FONT face=Arial color=#000000
size=2>
AddToComposite(<FONT
color=#000000>C<FONT
size=2>,sym,<FONT
color=#ff00ff>"C");<FONT
color=#0000ff>
AddToComposite(<FONT
color=#000000>O<FONT
size=2>,sym,<FONT
color=#ff00ff>"O");<FONT
color=#0000ff>
AddToComposite(<FONT
color=#000000>H<FONT
size=2>,sym,<FONT
color=#ff00ff>"H");<FONT
color=#0000ff>
AddToComposite(<FONT
color=#000000>L<FONT
size=2>,sym,<FONT
color=#ff00ff>"L");<FONT
color=#0000ff>
AddToComposite(<FONT
color=#ff00ff>1,sym,<FONT
color=#ff00ff>"V"<FONT
face=Arial size=2>);<FONT
color=#0000ff>
<SPAN
class=678142113-24042003>
Plotting
your ticker now will show the appropriate OHLC data. Unfortunately
if you have any holes in your data they may cause misleading candles. By
dividing the values by the number of calculations in each composite you
can smooth these errors. To plot this create a custom
indicator
<SPAN
class=678142113-24042003>
<FONT face=Arial color=#000000
size=2>
C=<SPAN
class=678142113-24042003> c /V<FONT
color=#282828><FONT
color=#0000ff>;<FONT
size=2>
O=<SPAN
class=678142113-24042003> o /V<FONT
color=#282828><FONT face=Arial
color=#0000ff>;
H=<SPAN
class=678142113-24042003> h /V<FONT
color=#282828><FONT
color=#0000ff>;<FONT
size=2>
L=<SPAN
class=678142113-24042003> L /V<FONT
color=#282828><FONT face=Arial color=#0000ff
size=2>;
<FONT face=Arial color=#000000
size=2>
Plot(<FONT
color=#000000>C<FONT
face=Arial>,"Sector
Index",<FONT
color=#000000>colorWhite<FONT
face=Arial>,<FONT
color=#000000>styleCandle<FONT
color=#282828>);
<FONT face=Arial color=#000000
size=2>
or better
yet..If you want to plot your index in the same chart as a component
stock try........
<FONT
face=Arial>
sym="~"+SectorID(1<FONT
face=Arial color=#0000ff>);<FONT
face=Arial>
C=Foreign(sym,"C")/V<FONT
face=Arial color=#0000ff>;<FONT
color=#000000><FONT
face=Arial>
O=Foreign(sym,"o")/V<FONT
color=#282828>;<FONT
color=#000000><FONT
size=2>
H=Foreign(sym,"h")/V<FONT
face=Arial color=#0000ff>;<FONT
color=#000000><FONT
face=Arial>
L=Foreign(sym,"l")/V<FONT
color=#282828><FONT face=Arial color=#0000ff
size=2>;
<FONT
face=Arial>
Plot(<FONT
color=#000000>C<FONT
face=Arial>,"Sector
Index",<FONT
color=#000000>colorWhite<FONT
face=Arial>,<FONT
color=#000000>styleCandle<FONT
color=#282828>);<SPAN
class=678142113-24042003> For separate window or add
|styleownscale for the same
window
AB will
determine what sector (or industry in your case) the stock belongs to
then automatically plot the index for that stock. I use this approach
daily to compare the stocks RSI and the sectors or the stocks momentum
and the sectors or to measure the stocks correlation to the sectors
etc
<SPAN
class=678142113-24042003>
<IMG alt=""
hspace=0 src="gif00291.gif" align=baseline
border=0>
<SPAN
class=678142113-24042003>
3./ It makes me wonder that the
newly created indices (in our case the IM200´s) have to be updated EVERY
day MANULY(running the scan). Is there no workaround for this (i.e.
store the calculated day somewhere and onl update the LAST session as
with regular stock data??).<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>The calculations needed require a look at your
whole universe. Just save your scan and run it... think of it as part 2
of your daily update. It take but a moment. IMO this feature alone
is worth the price of admission to AB. I used to do all this work as a
QP scan then export to excel, sort, calculate and import to metastock.
If I missed a day I had to rewrite the scan to get yesterdays data etc,
etc. With AB the composite is re-created each day so if I miss a day, no
problem. If QP makes an adjustment, no
problem.
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>I have one scan that creates all my sector
composites, all my industry composites, and several market breadth
composites. It takes my old P600 system about 2 minutes to do the work
then AB even sends them to the appropriate watch list for further
analysis. Super feature........
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>Regards,
<SPAN
class=678142113-24042003>
<SPAN
class=678142113-24042003>jayson
Highly appreciate your
help!!!!
Thanx
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Thursday, April 24, 2003
6:38 AM
Subject: RE: [amibroker] Creating
IM200 indices - JAYSON
<SPAN
class=855470704-24042003>JMarkus,
<SPAN
class=855470704-24042003>
<SPAN
class=855470704-24042003>I have been gone most of the afternoon. Sorry
to leave you hanging. Answers below......
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: <A
href="">funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Wednesday, April 23, 2003
5:26 PMTo: <A
href="">amibroker@xxxxxxxxxxxxxxxSubject:
Re: [amibroker] Creating IM200 indices - JAYSON
Anthony,thanks for stepping in here.If I
may:1./ does Jayson´s SYM variable refer to the array part of
the addtocompositefunction. If so, why is it not put in
parenthesis (though this results in anerror).<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT
size=2>The line
<FONT
size=2>
<FONT
size=2>sym="~"+sectorid(1)
<FONT
size=2>
<FONT
size=2>looks at each stock you scan and places "~" +
the sector ID for that stock in its place. If,
for instance the stock resides in the Utilities Sector then AB notes
this and returns sym= "~Utilities". Addtocomposite grabs this
shorthand and Therefore the next line <FONT
face=Arial>
AddToComposite(<FONT
color=#000000>C<FONT
face=Arial>,sym ,<FONT
color=#ff00ff>"C"); <FONT
color=#0000ff> becomes
addtocomposite(c,"~utilities","C");
<FONT
color=#0000ff>This is repeated for each
stock scanned. addtocomposite then simply looks to the stocks sectorid
and places the data in the appropriate
ticker
2./ sym="~"+SectorID(1);// this does sectors for industry
groups useindustryid(0)I don´t understand Jayson´s remark
here: WHICH stocks does that include? Iwant to include all stocks
belonging to the same of the 200 industry groups.<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial
color=#0000ff>Sectorid(1) returns the 12 sectors (Capital goods,
utilities, financials etc) If you want industry groups then replace
that line with
<FONT face=Arial
color=#0000ff>sym="~"+industryID(1);
<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial
color=#0000ff>Ab will look at all the stocks in your scan. All the
stocks with with the same industryID will be counted in the
appropriate composite
Ticker. 3./ if I wanted to
create an index for all the 200 used industry groups(Quotes Plus
Two), would I have to write this code 200 times??<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>No... See above... AB does all the grunt work for
you... 4./ would I have to run the scan
EVEREY day to bring my Addtocomposites upto date?<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT
size=2>Yes. the scan will create/update all 200
industry groups and store them in group 253 (the default location for
your Composites. You may also create watch lists of these
tickers to separate them. For instance I have
a watchlist with just the 12 sectors, a second for the industry group
tickers etc.... 5./ I added
"flag=16" which gave me an error. How do I have to specify if
Iwant to use addtocomposite in exploration mode?<SPAN
class=855470704-24042003><FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>flag=16 is a description.... just add comma
16
AddToComposite(<FONT
color=#000000>C,sym ,<FONT
color=#ff00ff>"C"<SPAN
class=855470704-24042003> <FONT
face="Courier New" color=#ff00ff>,16 );
Many thanks for your
help!Markus----- Original Message -----From:
"Anthony Faragasso" <ajf1111@xxxxxxxx>To:
<amibroker@xxxxxxxxxxxxxxx>Sent: Wednesday, April 23, 2003
8:37 PMSubject: Re: [amibroker] Creating IM200 indices -
JAYSON> Also...do not forget to add this dummy
line...which is needed forscanning.>>
Buy=0;>>>> Send BUG REPORTS to
bugs@xxxxxxxxxxxxx> Send SUGGESTIONS to
suggest@xxxxxxxxxxxxx>
-----------------------------------------> Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx>
(Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)>
--------------------------------------------> Check group FAQ
at:<A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html>>
Your use of Yahoo! Groups is subject to <A
href="">http://docs.yahoo.com/info/terms/>>Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS
to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend
SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Attachment:
Description: ""
|