[amibroker] Re: Strange response of -1.#J in explorer column - what is that ?

["gmorlosky" <gmorlosky@xxxxxxxxx>]

try SP = Foreign("^GSPC","C"); and remove RestorePriceArrays();
that works.

-- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@xxx> wrote:
>
> Turns out to be the divide by zero error.
> So what is the proper way to write this code ?
> ROCSP = ROC(MA(SetForeign("^GSPC"),13));
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> >
> > I ran this calculation to get the percentage change between the 
> symbol and a base index of the SP500, but I get this strange -1.#J 
> value in explorer.
> > 
> > ROCSP = ROC(MA(SetForeign("^GSPC"),13));
> > RestorePriceArrays();
> > MyRSC = ROC(MA(C,13)) / ROCSP;
> > AddColumn(MyRSC,"MyRSC",2.2,IIf(MyRSC >= 
> > 0 ,colorGreen,colorRed),colorDefault,50);
> >
>



------------------------------------

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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

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/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/