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

RE: Calculation error in MS



PureBytes Links

Trading Reference Links

Very interesting!! I have tried it and get the same result with MS 7.02. I
have plaid with the formula a bit trying differents variations  on it (for
instance if(perc=-2,0,if(perc>-2,1,-1))) and still get 1 as a result all the
time. I have even tried If(perc=-2,0,1) and still get 1!!! I am intrigued
too....have you tried to ask MS support about it? Has anyone got an idea
what the problem is???

Herve

-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of SR
Sent: Monday, 1 October 2001 2:26 AM
To: metastock@xxxxxxxxxxxxxxxxxx
Subject: RE: Calculation error in MS


Hello dear friends

Today I noticed the following very strange error, while back-testing with
Metastock 6.52 for windows:

Previous bar's close = 1.5
This bar's close = 1.47

All the calculations made (manually  or electronically ) will agree that the
percentage of this  change is  -2
I made an indicator for calculating the change in MS itself, which also
agrees with this percentage:

 ( C - Ref(C, -1) ) * 100 / Ref(C, -1)

The above returns -2  allright.

So far so good.
But the strange thing is, that when I tried to verify this percentage with
binary or ternary indicators, they did NOT recognize the change -2% as true!
In fact, they consider the result as >2% !
Here is a ternary indicator that I used for verification :

perc:= ( C - Ref(C, -1) ) * 100 / Ref(C, -1);
If(perc > -2, 1,
If(perc < -2, -1, 0))

The result returned in the above case was NOT zero (0) as it should be, but
one (1) which means that the change is represented by a number larger
than -2

Has anybody else experienced such a thing? Do I have a virus in my computer?
A math terrorist maybe? Has my MS crashed quietly?
Can someone repeat the above experiment and tell me the results please?

Thanks
Orea