Home → Problems →

wrong net worth after stock split

• Edit

Peter L

15 Apr, 2009 06:08 PM

After I have entered stock splits for three european stocks, my historical net worth (before the split) gets a big boost, which looks nice, but is wrong.

I found in recent MD-blogs that this is an old issue and goes back to MD2007.

This means that in case of a stock split your historical net worth is completely unusable.

So far I consider Moneydance as one of the best financial software for mac on the market and I hope to hear when this bug is planned to be fixed.

Thanks,

Peter

1. 1 Posted by Brian Adler on 16 Apr, 2009 04:17 PM

   

   Peter, I tested this by making up a fictitious security. I entered the split, made it a 2 for 1 split and decreased the value of the imaginary security by half (as would be the case in an actual split). It all worked correctly. When I ran an account balance history report it correctly showed the previous as well as current value of the account based on the fictitious holding. Are you entering your split in the securities detail panel?

   • Edit

2. 2 Posted by Peter L on 16 Apr, 2009 06:31 PM

   

   Hi Brian, thank you for your answer.

   I am not sure whether your simulation of a stock split is able to reproduce the mentioned bug as it happens in a really portfolio, because there you have a stock history which has to be taken into calculation for the historical net worth

   Certainly, I entered my stock splits (Nestle, BASF, Eon) in the securities detail window, and everything worked correct in the portfolios, like number of stocks , average cost, total value and gain.

   The problem is with the calculation of the historical net worth report.

   Following links refer to former discussions in the Moneydance forum:

   http://getsatisfaction.com/theinfinitekind/topics/stock_split_caused_retroactive_balance_problems?from=new_topic&utm_medium=topic_search&utm_source=topic_search_theinfinitekind

   http://moneydance.com/trac/ticket/1376

   Peter

   • Edit

3. 3 Posted by Brian Adler on 16 Apr, 2009 07:21 PM

   

   Peter, I have duplicated the bug you're describing. It doesn't show up on the account balance report but it does show up on the net worth report. I didn't notice at first that I had run a different report than you did. We are looking into it now. Brian Moneydance Support

   • Edit

4. 4 Posted by Peter L on 17 Apr, 2009 01:48 PM

   

   Brian, thank you for support.

   Meantime I played a little bit to find out how things behave and ev. get a correct historical networth.

   See att. screenshot:

   Nestle (NESN.vx) had a stock split 10:1 at 30.06.2008, I adjusted all prices (only3) before that split accordingly (1:10), 520>52 etc.

   What I then get is a correct historical networth before split (small diagram), only the course chart in the stock details window which showed the split correct before, now is wrong.

   I hope this helps a bit to solve this.

   • MD1-shot.tiff 512 KB
   • Edit

5. 5 Posted by Brian Adler on 17 Apr, 2009 04:18 PM

   

   Thank you Peter. I'll let you know as soon as we have it fixed.

   • Edit

6. 6 Posted by g on 26 May, 2009 03:09 PM

   

   I raised this ticket in trac about inconsistent net worth values. I don't know if it is related to stock splits of not, but would be nice to get it fixed as well.

   • http://trac.moneydance.com/trac/ticket/1174 (1174)
   • Edit

7. 7 Posted by Brian Adler on 01 Jun, 2009 08:20 PM

   

   Thank you G. We are working on it, looking into it.

   • Edit

8. Raimund Buchholz closed this discussion on 17 Dec, 2009 12:55 AM.