Consolidated view or report showing all accounts holding a particular security?

:# Is there a consolidated view or report showing all accounts holding a particular security?

Best Answer

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    To be more specific, you would go to Investing > Portfolio then click on Customize. On the Securities tab, pick just the security you are interested in and on the Accounts tab click on Select all.

    Click OK to accept the customization.

    Then next to Group by select Accounts and you will see all the accounts that hold that security.
    QWin Premier subscription

Answers

  • bmciance
    bmciance SuperUser ✭✭✭✭✭
    Not a predefined one but you can either customize the Portfolio Value report to show just one security from all accounts that it is in or you can set up a customized view on the portfolio tab to do the same
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    To be more specific, you would go to Investing > Portfolio then click on Customize. On the Securities tab, pick just the security you are interested in and on the Accounts tab click on Select all.

    Click OK to accept the customization.

    Then next to Group by select Accounts and you will see all the accounts that hold that security.
    QWin Premier subscription
  • [Deleted User]
    edited April 2021
    @MrQRav - You can run a Investment Performance Report and I think it will get you the closest thing to a "Holders List" that you are looking for.  Subtotal the report by Account and you will probably need to play with the date range, depending on the activity of your securities.  This is not perfect but it gets you most of the way there.

    You can also run a Portfolio Value Report subtotaled by Account.  You can export it to Excel and resort it to get an Account list by Security.
  • Bob_L
    Bob_L SuperUser ✭✭✭✭✭
    Another way is to run the  security list using Ctl Y.  Pick the security of interest to open the security detail view.  On that page click the button Security .report in the upper right hand corner, and then group by account when it opens.

    Quicken Business & Personal Subscription, Windows 11 Home