Re: [amibroker] Incorrect rounding in Amibroker

["Tomasz Janeczko" <groups@xxxxxxxxxxxxx>]

 

Read the manual first http://www.amibroker.com/guide/h_exploration.html

Rounding is correct and user-definable. If you want 3 decimal digits - just tell AB this way:

 

AddColumn(mp,"mp", 1.3 );

Best regards,
Tomasz Janeczko
amibroker.com

----- Original Message -----

From: İlhan Ketrez

To: amibroker@xxxxxxxxxxxxxxx

Sent: Friday, March 13, 2009 9:35 PM

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

__,_._,___