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

RE: [amibroker] Incorrect rounding in Amibroker



PureBytes Links

Trading Reference Links

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: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Ilhan Ketrez
Sent: Friday, March 13, 2009 3:35 PM
To: amibroker@xxxxxxxxxxxxxxx
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



__._,_.___


**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___