Toolbox - Duplicate & Non-Hierarchical Securities Alert/Error

Gina's Avatar


31 May, 2023 11:37 PM

I'm sure this is a Stuart question. I received the following alert message when I opened Toolbox: "ALERT - Potential duplicate(d) securities found (in Tools>Securities)!" When I closed that window, there was another error message window behind it: "ERROR - NON-HIERARCHICAL SECURITY ACCT TXNS >> Run 'FIX: Non-Hierarchical Security Act Txns (& detect Orphans)'..." However, when I went into the Currency & Security Tools Menu in Toolbox, there is no 'FIX: Non-Hierarchical Security Act Txns (& detect Orphans)' Update Function. I would also like to know whether the 'FIX: Merge 'duplicate' securities (and related investment txns) into one master security record (2021.2(3089) onwards)' Update Function is what I need to use to address the potential duplicate securities alert. Thanks.

Showing page 2 out of 2. View the first page

  1. 31 Posted by Gina on 21 Jun, 2023 04:08 PM

    Gina's Avatar

    I ran 'Can I delete security' on the Apple security I thought was not being used 'Apple Inc.' in my MD account. The attached message shows, there are no holdings, but it is being used in the same account as the Apple security with the holdings 'Apple, Inc.' However, I have looked through the register for the security and searched the register by the security name 'Apple Inc.' and by security id 'DE000JQ235A4' and come up with nothing. I don't know how to access the 'script output' to see if the details will provide me more information to be able to locate the transaction(s) associated with this security so I can correct them and then delete the security.

  2. 32 Posted by Stuart Beesley ... on 21 Jun, 2023 04:48 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I would see if there are any transactions in that account for that security? One way to check is to a) tools/securities EDIT that security and call it 'APPLE Inc - LOOKFORME', then b) go to that account and see if there are any transactions? At this point, are you able to go to the securities Detail TAB, then Actions, then Remove security and select this one... Does it let you - or not? If it does, great... If not, look at the txns... Do they look OK to be merged to you? If so, then merge..

  3. 33 Posted by Gina on 21 Jun, 2023 08:32 PM

    Gina's Avatar

    I changed the security name, searched the account register for the new name–still got nothing, selected the Securities Detail tab and successfully removed the security. However, when I closed out of MD and reopened it, I got the attached message, but my Apple Inc was not in the securities dropdown list to match to match it to even though it is in the list of securities under Tools. I even renamed the security from Apple, Inc. to Apple Inc and tried it again. Still no match so I just closed the window without selecting a security. I think this is how the duplicates have been created because when the security is not in the list, I usually just click "OK" and it creates it.

  4. 34 Posted by Gina on 21 Jun, 2023 08:55 PM

    Gina's Avatar

    Here is what the downloaded transactions look like. The Quote Loader extension still isn't pulling down the price for my Apple security either.

  5. 35 Posted by Gina on 21 Jun, 2023 09:23 PM

    Gina's Avatar

    I changed a couple of parameters in the Quote Loader, and it is now pulling down the prices for the Apple security correctly, but the online transaction download still can't find the Apple security with all the holdings.

  6. 36 Posted by Gina on 21 Jun, 2023 10:31 PM

    Gina's Avatar

    I finally got the Apple security corrected. I went ahead and let the download create the duplicate, I fixed the ticker, price, and decimal places, to match, then did the merge. It seems to be correct now. That was a really long, tedious process; and unfortunately, I have a bunch more duplicates that were created the same way when, for whatever reason, the security in use is not showing up in the online download list and can, therefore, not be matched with the existing security. It's frustrating because I am far less familiar with the other duplicate securities; and, therefore less likely to be able to fix them.

  7. 37 Posted by Stuart Beesley ... on 21 Jun, 2023 11:00 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Glad you got one apple mess sorted out. Now you know the process. Just tackle one per week.


  8. 38 Posted by Stuart Beesley ... on 21 Jun, 2023 11:00 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Toolbox 🧰 +1 😃

  9. 39 Posted by Gina on 22 Jun, 2023 05:10 PM

    Gina's Avatar

    I determined that the name changed on one of my securities back in 2018 and that's why they have the same ticker symbol and are showing as a potential duplicate. Apparently, MD created the new security with the new name, but same ticker and the online transaction sold all the holdings from the old name and bought the same number of holdings in the new name. Should I just remove the ticker symbol from the old name so it won't show as a duplicate since the old name is still connected to transactions prior to 2018?

  10. 40 Posted by Stuart Beesley ... on 22 Jun, 2023 07:16 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Depends. Is it really the same security now and do you want it merged? If not, then yes, change the ticker and add ‘-something’ to the end.

  11. 41 Posted by Gina on 22 Jun, 2023 09:03 PM

    Gina's Avatar

    Yes, it is the same security. The only thing that changed was the name. I guess it wouldn't hurt to just merge it. It would keep thinks a bit cleaner.

  12. 42 Posted by Stuart Beesley ... on 22 Jun, 2023 09:28 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍 Merge.

  13. 43 Posted by Gina on 23 Jun, 2023 02:16 AM

    Gina's Avatar

    Done! I'm down to just one more duplicate in both my account and my granddaughter’s account. They are the same two securities in both accounts coming from TD AmeriTrade downloads. I had actually posted previously about these download that I have to delete to stay in balance because an agent at TDA told me those transactions through one of the securities is for internal purposes only, yet it is getting downloaded. TDA has been bought out by Charles Schwab, and the merge is beginning. Nothing is suppose to change in the short run, but who knows. Thanks for all your help Stuart! I think I can close this discussion.

  14. 44 Posted by Stuart Beesley ... on 23 Jun, 2023 06:20 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍 Toolbox 🧰 +100 😃

  15. Gina closed this discussion on 06 Jul, 2023 09:02 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

18 Jul, 2024 07:31 PM
18 Jul, 2024 05:38 PM
18 Jul, 2024 05:25 PM
18 Jul, 2024 03:39 PM
18 Jul, 2024 03:34 PM