|
PureBytes Links
Trading Reference Links
|
I have appreciated the help...Thank you for taking the time.....
Best wishes
Anthony
Franco Fornari wrote:
> Anthony,
>
> now I understood what you want to achieve. Sorry, but if I'm not
> wrong, this
> is not possible because by loops you can iterate into any array of one
>
> symbol, but not through a database.
>
> Best regards,
>
> Franco
>
> ----- Original Message -----
> From: "Anthony Faragasso" <ajf1111@xxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Sunday, February 09, 2003 6:49 AM
> Subject: Re: [amibroker] Sorting Arrays ( help )
>
>
> > Franco,
> >
> > Thank you for the code..but I am confused as to the result
> output..why
> > the 11 columns and the only column that is sorted is the ticker
> column
> > in ascending order...it seems that this column takes precedence over
> all
> > other columns....
> >
> > If I run the exploration;
> >
> > pricechange=ROC(C,9);
> > filter=1;
> > Addcolumn(pricechange,"%change",1.2);
> >
> > The results of this explore are sorted by the Ticker column...now if
> I
> > click on the %change column the results are sorted by the %change
> > column...with the highest %change to the worst.....This is what I
> would
> > like to achieve with the first explore....maybe it is not possible.
> >
> > Thank you
> > Anthony
> >
> > Franco Fornari wrote:
> >
> > > Anthony,
> > >
> > > try this formula in VBScript; it works fine:
> > >
> > > Filter = C>0;
> > > periods=9;
> > > pricechange=ROC(C,periods);
> > > EnableScript("VBScript");
> > > <%
> > > Dim Temp
> > > Dim i, j
> > > pricechange = AFL("pricechange")
> > > For i = 0 To UBound(pricechange) - 1
> > > For j = i To UBound(pricechange)
> > > If pricechange(i) > pricechange(j) Then '// replace ">" with
> "<"
> > > for
> > > descending order
> > > Temp = pricechange(i)
> > > pricechange(i) = pricechange(j)
> > > pricechange(j) = Temp
> > > End If
> > > Next
> > > Next
> > > AFL("P") = pricechange
> > > AFL("P0") = pricechange(0)
> > > AFL("P1") = pricechange(1)
> > > AFL("P2") = pricechange(2)
> > > AFL("P3") = pricechange(3)
> > > AFL("P4") = pricechange(4)
> > > AFL("P5") = pricechange(5)
> > > AFL("P6") = pricechange(6)
> > > AFL("P7") = pricechange(7)
> > > AFL("P8") = pricechange(8)
> > > AFL("P9") = pricechange(9)
> > > %>
> > > AddColumn(P,"P",1.2);
> > > AddColumn(P0,"P0",1.2);
> > > AddColumn(P1,"P1",1.2);
> > > AddColumn(P2,"P2",1.2);
> > > AddColumn(P3,"P3",1.2);
> > > AddColumn(P4,"P4",1.2);
> > > AddColumn(P5,"P5",1.2);
> > > AddColumn(P6,"P6",1.2);
> > > AddColumn(P7,"P7",1.2);
> > > AddColumn(P8,"P8",1.2);
> > > AddColumn(P9,"P9",1.2);
> > >
> > > Best regards,
> > >
> > > Franco
> > >
> > > ----- Original Message -----
> > > From: "Anthony Faragasso" <ajf1111@xxxxxxxx>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Saturday, February 08, 2003 8:50 PM
> > > Subject: Re: [amibroker] Sorting Arrays ( help )
> > >
> > >
> > > > Is there anyone who can help with this......
> > > >
> > > > Anthony Faragasso wrote:
> > > >
> > > > > I have found this Jscript for sorting in ascending Numeric
> > > order...Is
> > > > >
> > > > > this the proper function...and ....can anyone fill in the
> > > blanks.....
> > > > >
> > > > > periods=9;
> > > > > pricechange=ROC(C,periods);
> > > > >
> > > > > EnableScript("JScript");
> > > > >
> > > > > <%
> > > > > // Sorts records in ascending
> > > > > // numeric value order
> > > > > function sNumAsc(A, b) {
> > > > > return ((+A > +b) ? 1 : ((+A < +b) ? -1 : 0));
> > > > > }
> > > > >
> > > > > %>
> > > > >
> > > > > Filter=1;
> > > > > AddColumn(pricechange,"%change",1.2);
> > > > >
> > > > >
> > > > > Thank you
> > > > > Anthony
> > > > >
> > > > >
> > > > > Yahoo! Groups Sponsor
> > > > ADVERTISEMENT
> > > >
> > > >
> > > > >
> > > > > 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.
> > > >
> > > >
> > > > 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
> > > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> > >
> > > 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.
> >
> >
> > 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
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> Yahoo! Groups Sponsor
ADVERTISEMENT
>
> 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.
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 http://docs.yahoo.com/info/terms/
|