|
PureBytes Links
Trading Reference Links
|
Tomasz,
Thank you, thank you, thank you..... I knew it was something simple
that I was overlooking.... Strings.....
I think I'll put a sticky note on my computer screen to remind of
that fact.
Thanks again,
Bill
--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx>
wrote:
> Bill,
>
> As I wrote you before WriteVal converts from NUMBER or ARRAY
> to STRING. That's why you can not use AddColumn() because
> it accepts the array/number and NOT string. Only AddTextColumn
accepts
> strings.
>
> In fact your formula can be simplified a lot. In *exploration* you
don't
> really need to use WriteVal at all.
> WriteVal is required ONLY in Commentary and in Indicator Builder
> (only if you want to use it in textual Title variable).
>
> Here is the code :
>
> Filter = 1;
>
> DateSpan = EndValue(BarIndex()) - BeginValue(BarIndex());
> Range = DateSpan ;
>
> PerChange = (100*(EndValue(Close)-BeginValue(Close))/BeginValue
(Close));
>
> SD = (StDev(Close,Range));
>
> SDPerCent = (StDev(((Close/Ref(Close,-1))-1)*100,Range)*((Range)/
> (Range-1))^.5);
>
> Title ="Percentage change of close
is "
> + WriteVal( PerChange ) + "%, \nStandard Deviation of actual price
change over
> the period is " + WriteVal(EndValue(SD)) + "\nDaily Std Dev of %
> Price Change over the period is " + WriteVal(EndValue(SDPerCent))
> + "\nMonthly Std Dev of % Price Change over the period is " +
> WriteVal(EndValue(SDPerCent*(21)^.5));
> /*NumColumns = 2;
>
> Column0 = PerChange;
> Column1 = SD;
> Column0Name = "% Price";
> Column1Name = "P StD";*/
>
> AddColumn(7,"7");
> AddColumn( SDPerCent, "SDPerCent" );
> AddColumn(PerChange,"% Change");
> AddColumn(SD,"SD");
>
>
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message -----
> From: <wbarack@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Thursday, February 20, 2003 5:33 PM
> Subject: [amibroker] Re: AddColumn vs NumColumn & ColumnX=
>
>
> > Tomasz,
> >
> > Once again, I have run into the limits of my knowledge.
> >
> > The following code is what precipitate my original question. The
> > addcolumn example you gave below works just fine. However, If I
try
> > to do the variable PerChange, I run into an error message that I
> > don't know how to fix. BTW, it works ok if I use
> > the "NumColumns/ColumnX=" approach.
> >
> > So my first thought was that it was the array/scalar difference
that
> > was causing the problem. But apparently not.
> >
> > Can you help me with the difference as to why addcolumn isn't
working
> > here. Its something I haven't yet figured out.
> >
> > Thanks
> >
> > Bill
> >
> > --------------------
> > Filter = 1;
> >
> > DateSpan = EndValue(BarIndex()) - BeginValue(BarIndex());
> > Range = DateSpan ;
> >
> > PerChange = WriteVal(100*(EndValue(Close)-BeginValue
> > (Close))/BeginValue(Close));
> >
> > SD = (StDev(Close,Range));
> >
> > SDPerCent = (StDev(((Close/Ref(Close,-1))-1)*100,Range)*((Range)/
> > (Range-1))^.5);
> >
> > Title ="Percentage change of close
is "
> > + PerChange + "%, \nStandard Deviation of actual price change
over
> > the period is " + WriteVal(EndValue(SD)) + "\nDaily Std Dev of
%
> > Price Change over the period is " + WriteVal(EndValue(SDPerCent))
> > + "\nMonthly Std Dev of % Price Change over the period is " +
> > WriteVal(EndValue(SDPerCent*(21)^.5));
> > /*NumColumns = 2;
> > Column0 = PerChange;
> > Column1 = SD;
> > Column0Name = "% Price";
> > Column1Name = "P StD";*/
> > AddColumn(7,"7");
> > AddColumn( SDPerCent, "SDPerCent" );
> > AddColumn(PerChange,"% Change");
> > AddColumn(SD,"SD");
> >
> > ---------------
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
<amibroker@xxxx>
> > wrote:
> > > Bill,
> > >
> > > AddColumns works both with Number and arrays.
> > > Filter=1;
> > > AddColumn( 7, "Just 7" );
> > >
> > > (please do not use numcolumns variable if you use AddColumns
> > function)
> > >
> > > Best regards,
> > > Tomasz Janeczko
> > > amibroker.com
> > > ----- Original Message -----
> > > From: <wbarack@xxxx>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Thursday, February 20, 2003 3:58 PM
> > > Subject: [amibroker] AddColumn vs NumColumn & ColumnX=
> > >
> > >
> > > > In trying the different commnands above, it seems as though
the
> > > > AddColumn commnand only works with arrays. And if I calculate
a
> > > > scalar that I want to display in my Exploration, I need to
use
> > the
> > > > NumColumns/ColumnX= approach.
> > > >
> > > > Is this a correct interpretation on my part.
> > > >
> > > > Thanks
> > > >
> > > > Bill
> > > >
> > > >
> > > > 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/
> > > >
> > > >
> > > >
> >
> >
> > 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/
> >
> >
> >
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/
|