|
PureBytes Links
Trading Reference Links
|
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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Help tsunami villages rebuild at GlobalGiving. The real work starts now.
http://us.click.yahoo.com/njNroD/KbOLAA/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/
|