Security name & CUSIP change - Symbol the same - HOW TO FIX?

Marketing Guru
Marketing Guru Quicken Windows Subscription Member ✭✭
OK I don't know how to recover from this. PCY (Powershares Emerging Markets Bond Fond) has become Invesco EMBF. Along with the name change the CUSIP ID changed as well but the symbol (PCY) stayed the same. I didn't realize this and accepted all downloaded transactions for the past year in my brokerage account. This essentially created TWO securities with the new histories. The brokerage also issued a transaction called Mandatory name change which removed securities under the old name and replaced it with the new one. Now I have double the number of shares under the old name and a negative balance under the new CUSIP ID. How do I fix this? And how do I make it all work going forward? I have 4 accounts affected by this.

Comments

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    edited June 2019
    Normally, to change a security's name all we need to do is edit the security's name on the Edit Security Details window.  There is a wizard that will do this for us and will add a reminder of the event in a register.   And, normally, to reset a CUSIP number associated with a security, we uncheck Matched with online security on the Edit Security Details window and the next time Quicken attempt to match an unassigned CUSIP number, the security will be available to be selected.

    Now, I suggest you delete the Removed and Added transactions that were introduced as part of the Mandatory name changechange all of the transactions using the new security to use the original security, delete the new security, change the name and uncheck Matched with online security on the Edit Security Details window of the original security.  You'll also want to remove any of the placeholder transactions you may have accepted.  Note:  Before making any significant changes to your data file, always save a data file backup (press Ctrl + B).
  • Marketing Guru
    Marketing Guru Quicken Windows Subscription Member ✭✭
    It looks like what happened was Quicken did the name and CUSIP change on all the already accepted items in the register but didn't know what to do with the downloaded ones that I hadn't accepted for 9 months. It's a mess. I'm going to have to manually change the downloaded ones to = the new name CUSIP. I wish Find & Replace worked on Investments.
  • Marketing Guru
    Marketing Guru Quicken Windows Subscription Member ✭✭
    Tried again on a different account where the downloads had not been accepted for awhile. Quicken prompted with the old CUSIP is this a new security or does this match a current one. OK dummy, it matches PCY with the new CUSIP. Click ok and it pulls ALL the downloaded ones in as Unidentified Security instead of matching it. Argggggh!
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    If you have a backup from just before this, you can restore that and try again. 

    You shold follow the steps recommended by @Sherlock above.
    QWin Premier subscription
  • Marketing Guru
    Marketing Guru Quicken Windows Subscription Member ✭✭
    > @Jim_Harman said:
    > If you have a backup from just before this, you can restore that and try again. 
    >
    > You shold follow the steps recommended by @Sherlock above.

    Was easier just to manually change them all. No guarantee that a backup and re-do would have worked.
This discussion has been closed.