Is there a way to display a master portfolio?

TRudolph's Avatar

TRudolph

11 Mar, 2020 08:24 PM

I would like to be able to display all holdings in a single aggregate portfolio without it being segregated by account (I have some positions that are held in more than one account).

I've looked but cannot find a way to do this. Is it possible?

Thanks in advance!

  1. Support Staff 1 Posted by Maddy on 12 Mar, 2020 11:52 AM

    Maddy's Avatar

    Hi,
    Thank you for contacting Moneydance support.

    Which version and build of Moneydance are you using?
    To check, open Moneydance and select Help --> About Moneydance (or Moneydance --> About Moneydance on a Mac) where the version and build number will be displayed.

    Can you let me know which operating system you're running on your computer/s?

    If it's easier, you can send me a screenshot of what you're seeing. You can read instructions for taking a screenshot here - https://www.take-a-screenshot.org/

    Thank you

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by TRudolph on 12 Mar, 2020 11:57 AM

    TRudolph's Avatar

    MacOS 10.14.6
    See screenshot.

    Thanks.

  3. Support Staff 3 Posted by Maddy on 12 Mar, 2020 12:09 PM

    Maddy's Avatar

    Sorry for the confusion, what I meant was: please navigate to Tool->Graph and Reports->Portfolio and send us a screenshot of the settings used.

    Thank you

    --
    Maddy, Infinite Kind Support

  4. 4 Posted by TRudolph on 12 Mar, 2020 12:42 PM

    TRudolph's Avatar

    I see. They are individual pull down menus, so cannot get each setting/setup in a single screenshot.

    Select:All
    Type: All Security (also tried All Investment and All Investment + All Security)
    Show: By Individual (Security is checked) <- but I’ve tried all combinations here, too.

    Each combination of settings possible always results in displaying everything grouped by investment account.

    I even tried relaunching Moneydance.

    What combination of settings do you suggest I try again to make sure?

    Thanks!

  5. 5 Posted by Clive Gilroy on 15 Mar, 2020 02:08 PM

    Clive Gilroy's Avatar

    Good Afternoon,

    I note that you have asked the same question posed by me on 5th March 2020 under “Investment Performance & Portfolio Views” ---- but with admirable brevity compared with my “ramble”!
    In the absence of a response from the Infinite Support Team I had assumed that shares cannot be displayed separately & aggregated outwith the individual accounts in the various graph investment options and, yes, I also have tried the various edit options without success

    Clive

  6. 6 Posted by TRudolph on 15 Mar, 2020 06:54 PM

    TRudolph's Avatar

    Thanks for your input, Clive. I am a bit surprised there isn't a default report for this as I have always needed an option to display all positions in a single portfolio (a long-standing standard feature of Quicken Mac). I do hope Infinite sees the benefit of such an option as, though I am not a programmer, I cannot believe it would take much to accomplish.

  7. Support Staff 7 Posted by Maddy on 16 Mar, 2020 01:28 PM

    Maddy's Avatar

    Please accept my sincere apologies for the delay in responding to your query.

    Thank you both for the suggestion for improving Moneydance! I've filed a ticket in our ticketing system with your suggestion, so the developers will be looking into it.

    Please let us know if we can be of further assistance!

    --
    Maddy, Infinite Kind Support

  8. 8 Posted by TRudolph on 17 Mar, 2020 04:19 PM

    TRudolph's Avatar

    Thanks, Maddy. It would be a most welcome feature as I am confident most investors probably have more than one account, if not deal with multiple brokerage houses. Be nice to see where you stand without having to do 'math'. Looking forward to seeing it come to fruition.

  9. 9 Posted by Clive Gilroy on 28 Mar, 2020 05:31 PM

    Clive Gilroy's Avatar

    Hi Maddy,

    On 16/3/20 you commented “Thank you both for the suggestion for improving Moneydance! I've filed a ticket in our ticketing system with your suggestion, so the developers will be looking into it.”

    However, I see that back in 2016 when the same issue was raised under Investments and “Report by Total Shareholding” on 22/8/16, Tom Freeman of Infinite Kind support replied on 29/8/16 saying “We have a feature request ticket in for reports by security. I have attached it to this thread”
    I am wondering therefore if the issue is now closer to being addressed ?

  10. Support Staff 10 Posted by Maddy on 29 Mar, 2020 09:48 AM

    Maddy's Avatar

    Hi Clive,

    I can confirm that the ticket is currently open and that generally means that the issue is being addressed and our development team are working on it.

    Unfortunately, I cannot speculate on the ETF but stay reassured that it has been taken into consideration.

    --
    Maddy, Infinite Kind Support

  11. 11 Posted by PaulF on 18 Jun, 2020 07:09 AM

    PaulF's Avatar

    HI -is there any progress on this? When can we expect this or is it already in a preview?
    Many thanks Paul

  12. 12 Posted by dwg on 18 Jun, 2020 08:43 AM

    dwg's Avatar

    As far as I am aware the only "report" that I think can aggregates share holdings from different accounts is the Extra Investment Reports extension

  13. 13 Posted by PaulF on 18 Jun, 2020 09:12 AM

    PaulF's Avatar

    Thanks dwg - I had forgotten about this extension! I have been using the Portfolio Tracker extension but had hoped (from the Support comment above) for this to have been actioned into MD by now and was looking for an update from IK. Can somebody from Support give an update please?

  14. Support Staff 14 Posted by Ethan on 18 Jun, 2020 07:23 PM

    Ethan's Avatar

    Hello,

    Unfortunately we cannot provide timelines for when new features will be implemented. All I can say is that a ticket has been filed in our tracking system, which will allow our developers to consider it for inclusion in a future release. I apologise if previous replies suggested this would be implemented relatively soon.

    Ethan
    Infinite Kind Support

  15. System closed this discussion on 17 Sep, 2020 07:30 PM.

  16. TRudolph re-opened this discussion on 26 Feb, 2021 03:38 PM

  17. 15 Posted by TRudolph on 26 Feb, 2021 03:38 PM

    TRudolph's Avatar

    Hello - any word on the inclusion of a master portfolio? Really would be so helpful to see all your accounts combined to get a better feel for your holdings. Currently must manually enter them in a separate application in order to accomplish this. Hoping to hear this function is imminent. Thanks!

  18. 16 Posted by Stuart Beesley ... on 26 Feb, 2021 03:45 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    This may or may not give you something close to what you are after. I have an extension called StockGlance2020 which gives a neat/simple overview... You can find it on my site: [https://yogi1967.github.io/MoneydancePythonScripts/]

    Instructions on same page.

    You need to be on MD2021 build 2012+ for the extension to load.

    However, if you are not on MD2021, then you can run the same program as a script.

    Once you run the script, select StockGlance 2020...

    (not support, just a fellow user)

  19. 17 Posted by Jim on 04 Apr, 2021 02:18 AM

    Jim's Avatar

    Just throwing my vote for this as a new feature. Last year I migrated a lot of investing stuff over to MD and ended up abandoning it because there wasn't a way to look at a security across account. I need to track cost basis for a security across multiple accounts which I couldn't find a way to do.
    I think this is a pretty difficult as given the account/securities model MD uses to track securities?

  20. 18 Posted by Stuart Beesley ... on 04 Apr, 2021 06:32 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @jim. Did you look at my extract data (stock glance option) extension which displays a consolidated stock portfolio on screen?

  21. 19 Posted by Jim on 04 Apr, 2021 01:05 PM

    Jim's Avatar

    @Stuart. I have not. I currently dummy have any investment data in MD. I did notice you’re pretty active here and did find your Git repo. Been meaning to take a look at all you great work but haven’t had time yet.

    My needs are mostly for tracking cost basis and capital gain for a security regardless of the account. Is that something your extension can help with?
    I was even just considering using only one investment account in MD for multiple real accounts and maybe use a tag (?) to note the real account for a transaction. I think that would meet my relatively simple need?

  22. 20 Posted by Jim on 04 Apr, 2021 01:10 PM

    Jim's Avatar

    One thing that may need clarification is that I’m in Canada where lot matching isn’t a thing. Gains/losses must be calculated on the adjusted cost basis for a security as a whole and not within a single account.

  23. 21 Posted by Stuart Beesley ... on 04 Apr, 2021 01:13 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    Yup. You need the preview build of MD - currently 3062 and the latest (unsigned from my site). Download extract_data. Choose option StockGlance.
    https://yogi1967.github.io/MoneydancePythonScripts/

    It will give you a nice master portfolio on screen.

    As for cost basis. It simply uses whatever MD calculates as cost basis.

    When you rerun it’s an easy 2 clicks.

    Try it!!! Let me know your thoughts.

  24. 22 Posted by TRudolph on 05 Apr, 2021 06:14 PM

    TRudolph's Avatar

    @Stuart - Thanks for your earlier response. I am just now getting back around to trying to address this. Must admit to some intimidation regarding the nomenclature used by MD for identification (versions, builds, updates, upgrades, etc. - mostly the use of "builds" of course). Used to just seeing an incremental decimal increase with updates and version number changes with upgrades.
    The latest "version" of MD available for download from Infinite Kind's website is 2021/2006. Can't locate build 2012. I assume that is a beta version?
    I take it your extension will not run on 2021/2006?
    Was wondering, is there anyway I could coax you into uploading an example of the report (redacted of course)?
    Appreciate all you efforts to augment MD as I plan (hope) to be able to keep using it for the duration (have started over with new financial software 4 times now in 30+ years - always time consuming). My first, Dollars and $ense, was a real gem. Hated to see it go.

    Cheers! - Tom

  25. 23 Posted by Stuart Beesley ... on 05 Apr, 2021 06:45 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    First answer. Sorry, you need to be on a preview build. You can get MD2021.1 preview 3064 from here:
    https://infinitekind.com/preview

    This will very soon probably become the next stable release version (just my view). Anyway, it should be ok to use.

    More later.

  26. 24 Posted by Stuart Beesley ... on 05 Apr, 2021 07:24 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    StockGlance view:
    SS1 - the parameter screen
    SS2 - a dummy example portfolio (I just imported a lot of random numbers)
    SS2 - the matching MD Home Screen showing the exact same number.

  27. 25 Posted by TRudolph on 05 Apr, 2021 10:38 PM

    TRudolph's Avatar

    Perfect! Thank you very much. I'll download the preview build and give it a whirl. Really appreciate the extra effort. I think others will be interested as well if the happen upon this discussion.

    Cheers. - Tom

  28. 26 Posted by TRudolph on 04 Jun, 2021 10:39 PM

    TRudolph's Avatar

    Stuart - my apologies for the delay in reporting back. I knew I was getting a new MBP so I waited until I migrated to it to investigate. I had to load MD ver 2021.1 (3068) on it and added your Extract Data extension. This is perfect! I also appreciate the option to export data for the aggregate holdings and transactions for further manipulation in a spreadsheet.

    Thank you very much for putting the time and expertise into making this available!

    Cheers. - Tom

  29. 27 Posted by Stuart Beesley ... on 05 Jun, 2021 05:58 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    Thanks for the feedback @TRudolph... FYI - MD2021.1(3069) is now officially release as the 'stable' version and extract_data is also available from the Manage Extensions menu now....

    extract_data +1 😃

Reply to this discussion

Internal reply

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

Attaching KB article:

»

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