Cleaning up my securities

helen's Avatar


11 Aug, 2020 01:16 PM

I have a bunch of duplicate securities due to the download processes from Fidelity and the institutions. I'd like to clean this up... but obviously I don't want to remove a security that is linked to a transaction. Is there a way I can see, by security, what account or transaction they are linked to??? Or do I have to look in the history of every account?


  1. 1 Posted by Ben on 12 Aug, 2020 11:04 AM

    Ben's Avatar

    - just another user here.
    The Investment Transactions report shows account and security for every investment transaction and you can set it to Subtotal by Security. You might need to adjust column widths but there's no need to select an Account/Category.

  2. 2 Posted by helen on 12 Aug, 2020 08:16 PM

    helen's Avatar

    OMG. This worked! Brilliant! Thank you. I downloaded it then resorted, getting rid of the subtotals, then put it in a pivot table.

  3. 3 Posted by Ben on 12 Aug, 2020 09:10 PM

    Ben's Avatar


  4. System closed this discussion on 11 Nov, 2020 09:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

15 Jan, 2021 09:00 PM
15 Jan, 2021 08:40 PM
15 Jan, 2021 08:01 PM
15 Jan, 2021 07:57 PM
15 Jan, 2021 07:52 PM