Error in the calculation of investment account balance
I've been importing 20-years worth of Quicken data into Moneydance and, so far, it has done a GREAT job. After reading many posts from users who had problems with importing a QIF file from Quicken, mine has gone very well with just a handful of transactions that needed tweaking before almost everything balanced.
I've been carefully checking my investment accounts to ensure that the right number of shares for the correct stocks appear in the expected accounts. That's all OK - everything matches exactly. I've also been checking that Moneydance downloads the correct current prices for each stock and that the price matches the ones downloaded into Quicken at the same time. Again, everything matches.
I then started to look at the investment account totals as a final check, but found that they don't match the Quicken results.
In other words, the share numbers are right, the prices are right, but the maths in Moneydance appears to be wrong.
Let me quote a specific example:-
In one particular account I hold 1306 shares in BP.L. The most recent price downloaded for this share in Quicken and Moneydance is £5.2875
Quicken correctly reports the current value of this stock in that account as £6905.48
Moneydance reports the value on the homepage as £6843.44
Apologies if I am being stupid here, but it looks like Moneydance is mis-calculating the current value of the stock.
This is repeated on every stock that I've checked.
As far as I can see, the documentation doesn't specify how the value of individual stocks listed in the investment accounts on the homepage are calculated, but one would assume that it would be 'number of shares' x 'most recently downloaded price'.
This doesn't seem to be what it's doing!
Can someone explain this?
By the way, I'm using Moneydance 2008r2 (617)
Thanks,
Mike
I've been carefully checking my investment accounts to ensure that the right number of shares for the correct stocks appear in the expected accounts. That's all OK - everything matches exactly. I've also been checking that Moneydance downloads the correct current prices for each stock and that the price matches the ones downloaded into Quicken at the same time. Again, everything matches.
I then started to look at the investment account totals as a final check, but found that they don't match the Quicken results.
In other words, the share numbers are right, the prices are right, but the maths in Moneydance appears to be wrong.
Let me quote a specific example:-
In one particular account I hold 1306 shares in BP.L. The most recent price downloaded for this share in Quicken and Moneydance is £5.2875
Quicken correctly reports the current value of this stock in that account as £6905.48
Moneydance reports the value on the homepage as £6843.44
Apologies if I am being stupid here, but it looks like Moneydance is mis-calculating the current value of the stock.
This is repeated on every stock that I've checked.
As far as I can see, the documentation doesn't specify how the value of individual stocks listed in the investment accounts on the homepage are calculated, but one would assume that it would be 'number of shares' x 'most recently downloaded price'.
This doesn't seem to be what it's doing!
Can someone explain this?
By the way, I'm using Moneydance 2008r2 (617)
Thanks,
Mike
2
people have this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?OK, I've figured it out for myself. I think I see what's happening now.
It's using the 'current price' that's displayed on the 'stock prices' list on the homepage, which is the same as the 'current price' that's shown near the top of the security price history form.
Presumably that's the price (or the 20-minute delayed price) at the time of running the download from Yahoo, whereas the most recent price in the pricing history is usually the last trading day's closing price.
I was expecting it to always use closing prices, but at least I understand what's happening now.
Sorry to have raised the problem prematurely!
I'd still be grateful if someone would confirm that my above assumptions are correct, though.
Thanks,
Mike
I’m happier than I was!
1 person says
this solves the problem
-
Inappropriate?It's a more pervasive bug than that. When showing stock prices on the home page, MD is using the last price that was entered (which might easily have been a historical price) instead of using the price as at the current date. This is a serious bug.
I’m astonished that such a bad bug exists
Loading Profile...


