Looking for a way to get an investment report summarized by account

Paresh Buch

I have many accounts, each account has many securities (they are funds). My home screen for investments allows me to customize the view - perfect for me. I wish to export this home screen into excel BUT I do not see where I can export that into excel. So, looking for ideas - is there a way to get an investment report that shows cost basis and performance BUT summarized by account (details hidden) that can be sorted at the account level rather than security level.

bmciance

On the view you referred to did you try hitting Alt-P Ctrl-P?  Then there is a choice to export to Excel rather than print
(edited)

Bob_L

Have you tried going to investments tab, portfolio?  That is probably your best bet.  Also try going to reports menu, investing to see various reports that might also help.

If export to excel is required then reports will work the best.

Paresh Buch

Already tried what is available. Doesn't provide what I am looking for.

bmciance

On the view you referred to did you try hitting Alt-P Ctrl-P?  Then there is a choice to export to Excel rather than print
(edited)

Paresh Buch

That is brilliant - did not know that trick, Many thanks. Just what I need.

bmciance

Glad it helped.  I just realized I gave you the wrong button - but I guess you figured it out.  To set the record straight for anyone reading this post later, it is CTRL-P (not ALT-P!).

(edited above by q.lurker)