[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] exporting to txt file modified data



PureBytes Links

Trading Reference Links

Hi Tomasz,
re: "32 bit single precision IEEE floating point is limited to 7 
significant digits accuracy."

Is Volume handled with 7 digits as well?
And could this have some serious repercusions when doing calculations with 
volume?


Eg. The volume is already 8 digits long for 13,14,17,18 etc....
AMP     (new)
AMP     21/03/2003      7.56    7.6     7.7     7.52    3585067
AMP     20/03/2003      7.64    7.79    7.81    7.56    6236905
AMP     19/03/2003      7.77    7.62    7.79    7.5     7436849 0
AMP     18/03/2003      7.58    7.55    7.62    7.44    10077051        0
AMP     17/03/2003      7.09    7.45    7.5     7.05    11003351
AMP     14/03/2003      7.25    6.95    7.33    6.85    24879902
AMP     13/03/2003      6.45    5.9     6.56    5.88    17178985
AMP     12/03/2003      6.16    6.03    6.2     5.93    7849209 0
AMP     11/03/2003      5.92    6.07    6.11    5.9     9436115 0
AMP     10/03/2003      6.3     6.49    6.51    6.28    4790695 0
AMP     7/03/2003       6.51    6.7     6.7     6.51    6175581 0
AMP     6/03/2003       6.76    6.75    6.87    6.75    3858491 0
AMP     5/03/2003       6.76    6.75    6.94    6.7     5640497 0
AMP     4/03/2003       6.9     6.68    6.93    6.62    9207506 0
AMP     3/03/2003       6.77    6.98    7.07    6.6     11691944        0
AMP     28/02/2003      7       7.32    7.41    6.96    15187823        0
AMP     27/02/2003      7.25    7.51    7.58    7.2     16848562        0
AMP     26/02/2003      7.71    7.78    7.88    7.45    12850752        0


At 10:21 AM 23/03/2003 +0100, you wrote:
>Graham,
>
>As Tradestation and Metastock, AMiBroker uses 32 bit IEEE floating point 
>representation
>for data arrays. 32 bit single precision IEEE floating point is limited to 
>7 significant digits accuracy.
>
>20030314
>is EIGHT digits therefore the last one (least significant) eighth digit 
>can not be represented accurately.
>
>This is the reason why DateNum returns YYYMMDD and not YYYYMMDD
>
>Solution for your export problem:
>Go to Windows Control panel - Regional settings and change the date format 
>to one accepted by Metastock
>and then re-run exploration
>



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Your own Online Store Selling our Overstock.
http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
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/