Investment Performance Report Error

Mike Bray 's Avatar

Mike Bray

20 Jul, 2018 05:05 AM

I have just run an Investment Performance Report without changing any of the selection parameters and got a wrong value. I have two investments in FP CRUX European Special Situations. One in an ISA and one in a Fund and Share account. Both entries are showing in the ISA and the ISA account entry is duplicated thus throwing off the investment report. See enclosed screen shot.

Moneydance version 2017.7.1 (1671)
OS: Windows 8.1

The Portfolio screen shows the correct values (see screen shots)

  1. 1 Posted by derekkent23 on 20 Jul, 2018 09:05 AM

    derekkent23's Avatar

    Hi Mike

    I see your issue.

    Just taken a look at my INVESTMENT PERFORMANCE report, not one I use, but it looks OK. I am running 2017.8(1688).

    I wonder if its worth clicking on EDIT – RESET in the INVESTMENT PERFORMANCE report.

    Also, I note Sean seems to have been doing bug fixes in this area may be worth trying the Preview build 2017.8(1688)

    Hope this helps

  2. 2 Posted by Mike Bray on 20 Jul, 2018 09:46 AM

    Mike Bray 's Avatar

    Hi Derek, thanks for the advice, unfortunately same result. Looks like a bug.

  3. 3 Posted by derekkent23 on 20 Jul, 2018 10:04 AM

    derekkent23's Avatar

    Hi Mike

    I hope you get a response from SUPPORT STAFF!!

  4. 4 Posted by sth on 21 Jul, 2018 04:53 PM

    sth's Avatar

    Investment reports and analysis are a weak spot in MD. There are a bunch of bugs in the reports and I think you have found one. I hope Sean/IK respond and fix this one. I still get reports where the return is a positive amount of dollars and the IRR (or ROI as they call it, is negative). Maybe MD 2019 will have some good news?

  5. 5 Posted by travelbird2 on 21 Jul, 2018 09:38 PM

    travelbird2's Avatar

    This comment was split into a new discussion: Investment Performance Report Error

    I just came across another bug. When there are split transactions in a cash portion of the account, these transactions are not included so balance way wrong.

    I tracked this down by exporting transactions and then matching them with the register and every single one that has a split is not in the exported transactions.

    The register shows a balance of $0.00 but the report shows (6,200.00). This amount is the exact amount of the split transactions.

    In this case try are transfers from another account with a category assigned, i.e. Dividend paid is transferred to the my checking account at a different brokerage firm. When entered the transaction is an Xfr with the security that paid the dividend to the account at the brokerage with a category of Dividend Income.

    I have hundreds of these kind of transactions as I transferred my data from Quicken.

  6. 6 Posted by sth on 22 Jul, 2018 12:25 AM

    sth's Avatar

    Steven, this needs to be a separate thread. If IK is to have any chance of tracking errors thread hijacking makes that impossible. It is a completely different issue and not related to the thread title. Lets not make IK's job of fixing bugs harder.

  7. 7 Posted by travelbird2 on 23 Jul, 2018 03:07 PM

    travelbird2's Avatar

    I already did that. I realized that I needed to make a separate thread right after I hit submit. Sorry.

  8. Support Staff 8 Posted by Sean Reilly on 15 Aug, 2018 10:15 PM

    Sean Reilly's Avatar

    Hi Mike,

    I just checked out the code and it looks like the transactions may have been out of order when they were grouped by account+security, which made the security that was common between those two investment accounts have extra rows in the wrong account's section. I've tweaked the transaction sorting to see if that might be the problem and build 1692 should be available on the preview site in a short while with that change. If that doesn't fix it I'll take a deeper look.

    Thanks!

    Sean Reilly
    Developer, The Infinite Kind
    http://infinitekind.com

  9. 9 Posted by Mike Bray on 21 Aug, 2018 03:18 PM

    Mike Bray 's Avatar

    Sean preview 1693 has completely broken this report. It now creates several entries of the same security and several entries for the same Investment Account. See enclosed 'performance report.jpg and compare with performance.jpg

    Mike

  10. 10 Posted by Mike Bray on 22 Aug, 2018 05:03 AM

    Mike Bray 's Avatar

    Sean, preview 1694 still the same as 1693

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • performance.jpg 390 KB
  • fund.jpg 258 KB
  • isa.jpg 254 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

23 Sep, 2018 06:38 AM
23 Sep, 2018 04:15 AM
23 Sep, 2018 02:47 AM
22 Sep, 2018 11:34 PM
22 Sep, 2018 10:07 PM