Shares Report

MangoMan

I am looking for a report that will show an alphabetical listing of all my stocks owned, overall cost per share, etc. and then a breakdown underneath - subtotal by account (E-trade, Ameritrade, Fidelity, etc.) the number of shares held, cost per share, ROI, etc. I have tried to generate one but # of shares, and avg cost are not available column headings. Is there a similar canned report or way to create this?

Jim_Harman

Sorry, that particular report is not available in Quicken.

You could set up an Investing > Portfolio view with the desired columns grouped by account, then export to Excel and manipulate the data there.

To export a portfolio view, set it up with the desired columns then select File > Print portfolio or hit Ctrl-P. Select Export to and .PRN. Give the file a CSV extension and you will have file you can open directly in Excel.

MangoMan

For example:
Name Sym Total Shares Avg Cost Per Share Price ROI Total Value
Ford F 1200 $5.75 $6.48 1.08% $7,776.00
E-Trade 300 $6.15 5.37% $1,944.00
Fidelity 400 $4.85 33,61% $2,592.00
Ameritrade 500 $7.58 -14.51% $3,240.00

Jim_Harman

Sorry, that particular report is not available in Quicken.

You could set up an Investing > Portfolio view with the desired columns grouped by account, then export to Excel and manipulate the data there.

To export a portfolio view, set it up with the desired columns then select File > Print portfolio or hit Ctrl-P. Select Export to and .PRN. Give the file a CSV extension and you will have file you can open directly in Excel.

MangoMan

Yep -That doesn't work either. Doesn't provide number of shares. Might be time to move to a new program after 30 years of pain dealing with the vagaries of Quicken.

Jim_Harman

It provides the number of shares for each holding if you click on Customize and add the Shares column to the view.

If the primary sort and subtotal must be by security, you would have to sort the data and compute the total number of shares for each security in Excel.