Securities duplicates

William Moran's Avatar

William Moran

26 Feb, 2021 06:29 PM

I have numerous versions of securities. I don't understand where the duplicates came from. Many can't be deleted (Error message: Can't remove currency that is being used). Any help would be much appreciated!

  1. 1 Posted by Stuart Beesley ... on 26 Feb, 2021 06:40 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Version of MD?
    OS and version?
    Do you import from QIF etc?
    Do you download / import OFX investment txns?
    When did these appear?

    (not support, just a fellow user)

  2. 2 Posted by The Morans on 26 Feb, 2021 07:40 PM

    The Morans's Avatar

    MD

  3. 3 Posted by The Morans on 26 Feb, 2021 07:42 PM

    The Morans's Avatar

    MD 2021.1 on Mac OS Big Sur. Some imports from QIF. No downloads. Not exactly sure when these appeared, have only been using MD for about a week!

  4. 4 Posted by Stuart Beesley ... on 26 Feb, 2021 10:20 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Ah. A week. Ok, so is it possible that your initial import created these duplicates? I see no other choice but to pick one of each security to be the master (rename to something like xxxx - master) and then txn by txn change the security in each account used (ie the buys/sells etc) to use the master security in each account. Once you’ve done this you can delete the non master securities.

    FYI - my toolbox extension can tell you which security is being used where before you delete. (Currency and security menu).
    https://yogi1967.github.io/MoneydancePythonScripts/

  5. 5 Posted by Stuart Beesley ... on 26 Feb, 2021 10:22 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    And... to use toolbox you will need to be on preview build 3036 on Mac
    https://infinitekind.com/preview

  6. 6 Posted by dwg on 27 Feb, 2021 12:13 AM

    dwg's Avatar

    I'm a fellow user.

    I can think of a way this could happen.

    If you were to import data from another program you have the same security in multiple investment accounts, but each security is stored not only independently but there is some differentiation between them.

  7. 7 Posted by derekkent23 on 27 Feb, 2021 08:38 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi

    Another user ended up with duplicate Securities and these are the note I provided to correct this situation. I also provided a link to a YouTube video that may also help.

    Proceed as follows:

    First do a FILE (MONEYDANCE on Mac) – EXPORT BACKUP in case you make a mistake.

    You will need to perform this process for each duplicated Security.

    Determine which of the investment accounts has the least transactions related to the subject security. Stuarts Toolbox may help in this.

    1. In the investment account SECURITY DETAIL tab use the drop down to select the subject security. Click HISTORY then EDIT and change the name of the Security to CHANGE ME.

    2. Then in the same investment account SECURITY DETAIL tab, click ADD SECURITY and add the subject security to the account.

    3. Now click on the REGISTER tab and select the transactions that contain CHANGE ME in the SECURITY field using the dropdown to select the subject security. You need to do this everywhere a transaction contains CHANGE ME.

    4. Back in the SECURITY DETAIL tab click on REMOVE SECURITY and select CHANGE ME in the dropdown. Then click OK.

    Done, now when you check under TOOLS – SECURITIES there is only one subject security and when you use Quote Loader both investment accounts are updated.

    Another user had the same issue. In his case he had the security “Vanguard Short-Term Bond Index Fund ETF Shares” duplicated under TOOLS – SECURITIES.
    I put together a YouTube video that showed the corrective action I had laid out for him. Take a look it will help you to understand the corrective process. Use this link to go to a YouTube video.
    https://youtu.be/Mulo9XkklAY

    In this case the duplicate securities was affecting the ability of the Extension Quote Loader to obtain prices and update that price for a security in each investment account, hence why the end of the video shows Quote Loader being used.

    Hope this helps.

  8. 8 Posted by The Morans on 27 Feb, 2021 01:39 PM

    The Morans's Avatar

    Thanks for the input Stuart. I’ve downloaded the toolbox extension.

  9. 9 Posted by The Morans on 27 Feb, 2021 01:44 PM

    The Morans's Avatar

    Thanks! I’ve suspected that importing multiple .QIF files was responsible. I’m working on consolidating and deleting!

  10. 10 Posted by The Morans on 27 Feb, 2021 01:55 PM

    The Morans's Avatar

    After importing .QIF files I found securities in MD investment accounts that did not belong there. After deleting these the duplicate securities disappeared. In other cases I do not own the securities and they are not in any of my accounts. I was able to delete those. After getting everything cleaned up I proceeded to import more .QIFs and the duplicates reappeared! 

  11. 11 Posted by Stuart Beesley ... on 27 Feb, 2021 02:12 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    They must be referenced in the QIF... Try searching the QIF for the security name and report back what you find?

    (not support, just a fellow user)

  12. 12 Posted by The Morans on 27 Feb, 2021 07:19 PM

    The Morans's Avatar

    Following recommendation on MD website I've imported each of my accounts separately. So I opened two of the .QIFs using BBEdit, a checking account and an investment account with only two securities and only two buy transactions. In addition to the transactions both files contain all my securities! So I guess every time I import an account, even if it’s not an investment account, I’m reimporting a list of securities and that this accounts for all the duplicates!

    Also, on my M1 MacBook Pro I cannot install toolbox.

  13. 13 Posted by dwg on 27 Feb, 2021 08:00 PM

    dwg's Avatar

    What is in a QIF file is dependent completely on the software it was exported from, some software will include various lists which could include securities, categories etc.

    If the software has an option to export transactions only I would do that.

  14. 14 Posted by The Morans on 27 Feb, 2021 10:02 PM

    The Morans's Avatar

    There is no option to limit what is exported to .QIF other than account and date range. But, I’m going to look at the .QIFs and delete the securities and see how that works.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screen_Shot_2021-02-26_at_12.26.09_PM.png 527 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? 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

10 Apr, 2021 11:30 AM
10 Apr, 2021 11:16 AM
10 Apr, 2021 11:09 AM
10 Apr, 2021 10:53 AM
10 Apr, 2021 10:23 AM