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

Re: [amibroker] Strange Calculations:



PureBytes Links

Trading Reference Links

Hello,

This is "by nature" of binary representation of decimals.
In the same way as 1/3 can not be represented accurately
as decimal fraction, you can not represent decimal fraction
others than powers of 1/2 in binary system.
So 2.50, 2.25, 2.125, 2.0625 and so on are 100% accurrate, but
others may not.

Enter some numbers at:
http://babbage.cs.qc.edu/courses/cs341/IEEE-754.html

and you will see that for example 22.44 (that you are using in your formula)
can not be represented accurrately in binary system. 
Accurracy in 32 bit IEEE floating point is 7 digits. 
So 22.44 becomes either 22.439999 or 22.440001

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "Michael.S.G." <OzFalcon@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Friday, December 30, 2005 2:25 AM
Subject: [amibroker] Strange Calculations:


> Can anyone explain why this is happening:
> When displaying I get the following....
>    Change = 79.8498          (Incorrect........Why am I getting .8498 
> and not just .85 ?????)
>    Value = 5079.85            (Correct)
>   
> 
> <TestCode>
> Qty = 220; BuyAt = 22.44; SellAt = 22.93; CommisionX1 = 27.95; Cash=5000;
> Change = ((Qty*SellAt)-(Qty*BuyAt))-CommisionX1; 
> Value = Cash + Change;
> 
> 
> 
> 
> 
> 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 --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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/