How to export stock portfolio from QMac to excel?

Question

Hi

How do I export my stock portfolio from quicken for mac to excel? Thanks!

jacobs · Answer

@atul.nyc If you click on Investing (or Brokerage or Retirement) in the left sidebar, then set the filters to Portfolio Value and By Account. When you print or export, you'll see a list of each account, with all the securities in the account. I don't think there's a way to do the opposite: list each security, subtotaled by a list of the holdings of each security by account.

You could probably create something along these lines in a spreadsheet, though, depending how many separate accounts you have. Export the "By Account" data. In a spreadsheet, duplicate the first column. Then copy down the account name for all the securities in the account, and repeat for each account. Now you can sort the spreadsheet data by security, and see the accounts holding each security. To illustrate…

Original export:

Duplicate the first column, and Copy Down the account name for all the rows for that account:

Sort by the security column to show each security with a breakdown by accounts:

Sort of a kludge, but it gets you there is this is where you want to go. ;)

atul.nyc · Answer

@jacobs Thanks jacobs.  Is there any way to create a report that breaks out the account(s) in which each security is held?  So instead of showing 10 SPY, showing me 3 in one brokerage account and 7 in the other, all in one report?

@Tom Young thanks for responding to my query!

Tom Young · Answer

@jacobs 
You are correct.  I'm getting better at filtering out the Mac questions but slip up from time to time.