|
PureBytes Links
Trading Reference Links
|
Hi Steve;
Thanks. I found the glitch but I don't understand it. It's with the
filter. I have the same formulas and addcolumns for 10 and 45 days. If
I specify a filter 5, 10 and 45 days it apparently doesn't calculate the
last date row if that date's first column number(5) has a zero. Yet if I
use filter =1, I get a result in the columns 5(0), 10(2) and 45(8) columns.
I guess the answer is to use a filter=1. I don't know why using a
specific filter as opposed to filter=1, didn't give me a zero in the
first column then continue calculating the rest of the columns.
TIA,
Dominick
Steve Dugas wrote:
> Hi,
>
> You could try breaking it down further and displaying the results to isolate
> where the strange behavior is creeping in:
>
> y = c > ref( c, -1 );
> z = v > ref( v, -1 );
> x = y and z;
> five=Sum(x,5);
> addcolumn( y, "y" 1.0);
> addcolumn( z, "z" 1.0);
> addcolumn( x, "x" 1.0);
> AddColumn(five,"5days",1);
> AddColumn((five/5)*100,"%five",1.2,IIf((five/5)*100 >=50,
> colorGreen,colorRed));
>
> Steve
>
> ----- Original Message -----
> From: "dom1_1998" <Dom2000@xxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Thursday, April 08, 2004 11:25 PM
> Subject: [amibroker] Re: Sometimes
>
>
> > I forgot to add, this happens when using the symbol DIA and !COMP.
> >
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "dom1_1998" <Dom2000@xxxx> wrote:
> > > This is strange. I have this formula:
> > >
> > > x=C >Ref(C,-1)AND V > Ref(V,-1);
> > > five=Sum(x,5);
> > > AddColumn(five,"5days",1);
> > > AddColumn((five/5)*100,"%five",1.2,IIf((five/5)*100 >=50,
> > > colorGreen,colorRed));
> > > Apply to current stock
> > > n=1
> > >
> > > It normally works fine but every so often the columns are blank. It
> > > won't calculate the numbers. I even tried n=7 and it gave me the
> > > numbers up to April 7th but won't calculate it for the 8th.
> > >
> > > Any ideas other than it may be haunted?
> > >
> > > TIA,
> > >
> > > Dominick
> >
> >
> >
> >
> > 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
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
>
>
> 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
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/SIG=12ck8b9dc/M=291630.4786521.5933964.1261774/D=egroupweb/S=1705632198:HM/EXP=1081575521/A=2072415/R=0/SIG=11thh7ako/*http://www.netflix.com/Default?mqso=60178432&partid=4786521>
>
>
> ------------------------------------------------------------------------
> 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
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
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
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/
|