Best Way To See Which Accounts Hold Specific Stock

Geobrick

What's the best way to quickly see which accounts hold a specific stock without having to look at the holdings of each account.

An example would be, if I'm looking to sell XOM and want to know where my shares are being held at a glance, what's a good way to do that?

The best way I've been able to find is create a portfolio value report and customize it by removing all stocks except the specific one I'm looking for then sort it by account. It's not very quick and I can't seem to prevent it from listing accounts without shares of XOM that display some meaningless cash value, but it gets the job done because I can see which accounts hold XOM.

Is there a better way that I'm missing?   

Rocket J Squirrel

You can run a Security Report and subtotal by Account.

Security Report is kind of hidden. You can get to it by right-clicking a security in the Security List or by clicking the Security Report button in a Security Detail View.

Geobrick

Rocket J Squirrel said:

You can run a Security Report and subtotal by Account.

Security Report is kind of hidden. You can get to it by right-clicking a security in the Security List or by clicking the Security Report button in a Security Detail View.

Thanks. That is hidden.
But it seems to just show transactions in a set period vs listing what's currently being held in each account (unless I'm doing it wrong). 

Chris_QPW

Geobrick said:

What's the best way to quickly see which accounts hold a specific stock without having to look at the holdings of each account.

I would use the portfolio view on the Investment tab for that, with a view grouped by account.

Rocket J Squirrel

Yeah, looking more closely, I'm surprised it doesn't at least give you the total number of shares in each account. That's what I expect "subtotal by" to do.

You can submit an "Idea" to the forum specifying what you'd like to see and how you'd like to get there.

Geobrick

Chris_QPW said:

Geobrick said:

What's the best way to quickly see which accounts hold a specific stock without having to look at the holdings of each account.

I would use the portfolio view on the Investment tab for that, with a view grouped by account.

Thanks. That seems to be the best option available.  

Ps56k2

Geobrick said:  Thanks. That seems to be the best option available.  

whatever way you use to review your holdings - ...
Do you have any Quicken Accounts that are "Separate or Hidden" as these will of course not be included in the display.

Ps56k2

Geobrick said:  An example would be, if I'm looking to sell XOM and want to know where my shares are being held at a glance, what's a good way to do that?

Also, a quick brute force way - just to see what accts are holding the security - not how many shares per each acct -
Bring up the Security Detail View and browse thru the Transaction History at the top.