Investment reporting

phil's Avatar

phil

18 Apr, 2015 05:12 PM

I have discovered how to attach custom sub-types to securities in each investment account, although it seems that I need to enter the sub-type for the same security which appears in more than one account.

I would like to use the sub-type and create a report showing totals by sub-type in each account and ideally for a group of specified accounts. I can't yet see how to do this.

Also, I hold the same security in a number of different investment accounts and would like to see the total position for each security across all of these accounts. At the moment I can just see the total for each within each account. Is there a way to do this?

PS: I realise that there is a bug with (some) ROI calculations - is this likely to be fixed - I really like to see this and have been misguided so many times by just looking at the column!

Thanks

Showing page 2 out of 2. View the first page

  1. 31 Posted by phil on 23 Jun, 2015 12:12 PM

    phil's Avatar

    It was indeed the Portfolio report - let me check the investment report

    *Philip Ladds*

    *[email blocked] <[email blocked]>+44 01420 564079+44 07836 511411*

  2. 32 Posted by phil on 23 Jun, 2015 01:06 PM

    phil's Avatar

    OK - just checked my previous results against the Investment Performance
    report:

       - Same answers except:
          - VWRL now shows change as -5.68 and IRR 128.08
          - EAT now shows change as -3.64 and ROI -20.01

    Interestingly, if I change the date to today's date one of the securities
    changes dramatically:

       - EURR (1650) - change becomes 1.10 and IRR 109.98

    Perhaps this is of some use and provides some pointers....all tantalisingly
    close!

    *Philip Ladds*

    *[email blocked] <[email blocked]>+44 01420 564079+44 07836 511411*

  3. 33 Posted by Ian L on 01 Jul, 2015 03:23 PM

    Ian L's Avatar

    Hi Phil,

    I've fixed a few more bugs in the investment performance report, based on the spreadsheet you sent. That was very helpful! Can you try build 1245 of Moneydance and let me know if you continue to see any errors?

    http://infinitekind.com/preview

    Ian
    Infinite Kind Support

  4. 34 Posted by phil on 01 Jul, 2015 03:35 PM

    phil's Avatar

    Will do when I get home

  5. 35 Posted by phil on 01 Jul, 2015 08:00 PM

    phil's Avatar

    Well I don't know how to say this.....but all computations look sensible
    and correct - well done indeed and thanks!

    *Philip Ladds*

    *[email blocked] <[email blocked]>+44 01420 564079+44 07836 511411*

  6. 36 Posted by Ian L on 03 Jul, 2015 11:33 AM

    Ian L's Avatar

    Great! I'm happy to hear that the reports are correct now. Thanks very much to everyone here for your assistance in troubleshooting this one.

    Please let me know if I can be of any further assistance, and thanks for using Moneydance.

    Ian
    Infinite Kind Support

  7. Ian L closed this discussion on 03 Jul, 2015 11:33 AM.

  8. System closed this discussion on 19 Mar, 2016 04:57 AM.

Comments are currently closed for this discussion. You can start a new one.

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