Nothing wrong with AB rounding off.

 

You highlighted:

1.   1.635 1.63      The 1.635 might be rounded off from a number between
1.6345000000001 and 1.634999999999 (or whatever the accuracy)

2.  1.545  1.55     The 1.545 might be rounded off from a number between
1.54500000000001 and 1.545499999999 (or whatever the accuracy)

 

 

From: [email protected] [mailto:[email protected]] On Behalf
Of Ilhan Ketrez
Sent: Friday, March 13, 2009 3:35 PM
To: [email protected]
Subject: [amibroker] Incorrect rounding in Amibroker

 

Dear friends,

 

Amibroker seems to be rounding the results different than it should be.
Below is a piece of the results. 

The prices have two digits after dot. (h+l)/2 sometimes has 2 digits,
sometimes 3 after dot.

 

Amibroker sometimes rounds the result up, sometimes down.

 

        
         

Ticker

Date/Time

H

L

(h+l)/2
Excel Calc.

(h+l)/2
Amibroker Calc.


YKBNK

23.02.2009

1.67

1.63

1.65

1.65


YKBNK

24.02.2009

1.64

1.58

1.61

1.61


YKBNK

25.02.2009

1.69

1.65

1.67

1.67


YKBNK

26.02.2009

1.70

1.65

1.675

1.67


YKBNK

27.02.2009

1.66

1.61

1.635

1.63


YKBNK

02.03.2009

1.63

1.58

1.605

1.61


YKBNK

03.03.2009

1.62

1.59

1.605

1.61


YKBNK

04.03.2009

1.64

1.60

1.62

1.62


YKBNK

05.03.2009

1.62

1.53

1.575

1.58


YKBNK

06.03.2009

1.57

1.52

1.545

1.55


YKBNK

09.03.2009

1.59

1.49

1.54

1.54


YKBNK

10.03.2009

1.55

1.50

1.525

1.52


YKBNK

11.03.2009

1.56

1.51

1.535

1.53


YKBNK

12.03.2009

1.55

1.46

1.505

1.5


YKBNK

13.03.2009

1.60

1.54

1.57

1.57

 

 

I may also send you the complete data if needed. You may also see easily
with your own data with the following code:

 

MP= (H+L)/2;

Filter=1;

AddColumn

(H,"H"); 

AddColumn

(L,"L"); 

AddColumn

(mp,"mp"); 

 

Thanks in advance for your help.

Ilhan



Reply via email to