|
PureBytes Links
Trading Reference Links
|
This is what I came up with but it doesn't perform as I wanted
whichDay = 1; // Sunday = 0, Monday = 1, ..., Saturday = 6
whichYear = 2005;
days = DayOfWeek() == whichDay AND Year() == whichYear;
totalDays = LastValue(Cum(Days));
upDays = DayOfWeek() == whichDay AND Year() == whichYear AND Close >
Open;
totalUpDays = LastValue(Cum(upDays));
Monday = 100 * (totalUpDays / totalDays);
f2=Close>20;
f3=Close<200;
Buy= Monday>70 AND f2 AND f3;
Filter= Buy;
AddColumn(Monday,"Monday");
When I run this exploration it puts-
an arrow on every single bar of every stock
the price column is missing in the exploration results
Can someone correct this, please?
--- In amibroker@xxxxxxxxxxxxxxx, "danclark_public" <dan_public@xxxx>
wrote:
>
> You can use one of several types of ATC symbols depending on
exactly
> what you want to see. So the first issue is to clarify this. Do
you
> want to see:
>
> 1) For an index created from all of the stocks in your database,
> what percent of Mondays had the stocks close higher than the open
in
> the last <xxx> periods?
>
> Or...
>
> 2) For all of the stocks in your database, what is the percentage
of
> stocks that were up on all mondays in the last last <xxx> periods.
>
> Or...
>
> 3) For all stocks in your database, what percentage of mondays had
> the the Advance/Decline net count > 0?
>
> I think that you want #1, but it's a little unclear.
>
> Assuming that it is, create an index ATC symbol of the stocks in
> your database and then run Graham's code against it.
>
> Regards,
>
> Dan.
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "thorstef2003"
<thorstef2003@xxxx>
> wrote:
> >
> > I found an exploration that used "addcolumn" and modified it, but
> it
> > doesn't do what I want.
> > Basically I need the exploration to give me a read out, like in
> the
> > Guru commentary "xx% of Mondays that were up" on all the stocks
> in
> > my database as a whole.
> > Whether the individual stock percentages on Mondays are there or
> not
> > doesn't matter. I want a readout of the Monday percentages on the
> > whole basket in my database. Hope this is clearer than my earlier
> > post.
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "thorstef2003"
> <thorstef2003@xxxx>
> > wrote:
> > >
> > > Thanks Graham. Will do.
> > > --- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxxx>
> wrote:
> > > >
> > > > you will need to use Filter and addcolumn
> > > > See AB help - tutorial - Amibroker Formula Language - How to
> > create
> > > > your own exploration
> > > >
> > > > On 11/2/05, thorstef2003 <thorstef2003@xxxx> wrote:
> > > > > This was posted 2 years ago here on this group. It is code
> to
> > be
> > > used
> > > > > in the Guru Commentary window.
> > > > >
> > > > > whichDay = 1; // Sunday = 0, Monday = 1, ..., Saturday = 6
> > > > > whichYear = 2005;
> > > > > days = DayOfWeek() == whichDay AND Year() == whichYear;
> > > > > totalDays = LastValue(Cum(Days));
> > > > > upDays = DayOfWeek() == whichDay AND Year() == whichYear
AND
> C
> > >
> > > O;
> > > > > totalUpDays = LastValue(Cum(upDays));
> > > > > upDaysPercent = 100 * (totalUpDays / totalDays);
> > > > > "% of Mondays that were up = " + WriteVal(upDaysPercent);
> > > > >
> > > > > This calculates the number of up Mondays for ONLY the stock
> > being
> > > > > displayed.
> > > > > How can I use this in the Auto Analyser window to show me
the
> > > > > percentage of up Mondays for ALL the stocks in my database?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Please note that this group is for discussion between users
> > only.
> > > > >
> > > > > To get support from AmiBroker please send an e-mail
directly
> to
> > > > > SUPPORT {at} amibroker.com
> > > > >
> > > > > For other support material please check also:
> > > > > http://www.amibroker.com/support.html
> > > > >
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Cheers
> > > > Graham
> > > > AB-Write >< Professional AFL Writing Service
> > > > Yes, I write AFL code to your requirements
> > > > http://e-wire.net.au/~eb_kavan/ab_write.htm
> > > >
> > >
> >
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|