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