Can I suggest a more accurate report when running a quick test?
Can I suggest a more accurate report when running a quick test?
The average rate of return is not correctly reported. This appears to be an average on the averages, but it should be the rate of return on the average beginning price and the ending price for the selection.
Try it by running a stock test on say 4 items, add up the sum of opening balances and subtract this from the sum of closing balances, and the value difference as a % of the opening balances.
Or simply take the difference between average opening and closing balances as a % of the average opening and you get a different result and I know from my testing it can give a significant difference to the current method.
Regards
Colin Carter