|
PureBytes Links
Trading Reference Links
|
http://finance.groups.yahoo.com/group/amibroker/message/86259
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "treliff" <treliff@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, September 06, 2005 6:49 PM
Subject: [amibroker] Unexpected decimals in Quotations Editor, pls Help
> As result of AddToComposite scans the Composite ticker fields contain
> unexpected values like 2.45001 (in Quotations Editor).
>
> Surprising in itself because these values are the result of the sum
> of CEIL and FLOOR function values like
>
> CEIL(x*20)/20
> FLOOR(x*20)/20
>
> that each should result in 2 decimals (2nd one a 0 or a 5)
>
> Furthermore, using " Tools--> export quotes CSV " these far-out
> decimals have disappeared (even when increasing the number of visible
> decimals in Excel, it just says 2.45).
>
> Is there an explanation for this?
>
> In any case, would an additional operation like
>
> ROUND(...*100)/100)
>
> really guarantee that there will be no more than two decimals ?
>
> Point is, these fields are used in additional analysis like
>
> " if ... is 2.45 then ... " etc.
>
> so to have the exact values in the fields is essential.
>
> TIA for your advice !!
>
> -treliff
>
>
>
>
>
> 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
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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/
|