Vanguard changing securities names to Vanguard Group
On a recent download from Charles Schwab, I'm being asked by MD to chose a security. This security already exists in my portfolio. When I go to chose the Security, it is not showing up in the drop down list. I've included screenshots to show that the security exists. It has a dozen existing transactions. The security is active. I'm not really sure what to do?
-
Screenshot_2025-09-04_113021.png
31 KB
-
Screenshot_2025-09-04_113256.png
28.1 KB
-
Screenshot_2025-09-04_113331.png
18.6 KB
Screenshot_2025-09-04_113021.png
Screenshot_2025-09-04_113256.png
Screenshot_2025-09-04_113331.png
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
1 Posted by Roger Rice on 04 Sep, 2025 06:41 PM
Forgot a screen shot.
2 Posted by dtd on 04 Sep, 2025 08:20 PM
The issue is that MD only supports one SEDOL or CUSIP for a security.
If you get a second SEDOL or CUSIP, the picklist only shows the securities which dont have one already.
I have asked for this to be corrected for months or more, but nothing yet.
In the meantime, its a pain, as you get doubled securities and such. i tend to fix this by hand , i.e reassign the new security back to the "real" one, but it happens again the next time the security changes.
You can try to fix the table itself with toolbox, but i dont recommend doing so, as it is easy to do wrong.
3 Posted by Roger Rice on 07 Sep, 2025 05:08 PM
Ahh....gotcha.... I have quite a mess now. More and more of these new/old securities are pouring in from Schwab. I have a dozen or so now across 7 different accounts.
I'm not really sure what to do.
POTENTIAL DUPLICATE SECURITIES:
ID: '^FNDA' Found in (3): ['Schwab Fundamental U.S. Small Company Index ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Small Company ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Small Company ETF',]
ID: '^FNDC' Found in (3): ['Schwab Fundamental Inl Small Company Index ETF ','Schwab Strategic Trust - Schwab Fundamental International Small Equity ETF','Schwab Strategic Trust - Schwab Fundamental International Small Equity ETF',]
ID: '^FNDE' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental Emerging Markets Equity ETF','Schwab Strategic Trust - Schwab Fundamental Emerging Markets Equity ETF',]
ID: '^FNDF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental International Equity ETF','Schwab Strategic Trust - Schwab Fundamental International Equity ETF',]
ID: '^FNDX' Found in (3): ['Schwab Fundamental U.S. Large Company Index ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Large Company ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Large Company ETF',]
ID: '^SCHC' Found in (2): ['Schwab Strategic Trust - Schwab International Small-Cap Equity ETF','Schwab Strategic Trust - Schwab International Small-Cap Equity ETF',]
ID: '^SCHE' Found in (2): ['Schwab Strategic Trust - Schwab Emerging Markets Equity ETF','Schwab Strategic Trust - Schwab Emerging Markets Equity ETF',]
ID: '^SCHF' Found in (2): ['Schwab Strategic Trust - Schwab International Equity ETF','Schwab Strategic Trust - Schwab International Equity ETF',]
ID: '^SCHG' Found in (2): ['Schwab Strategic Trust - Schwab U.S. Large-Cap Growth ETF','Schwab US Large Cap Growth ETF ',]
ID: '^SCHX' Found in (2): ['Schwab Strategic Trust - Schwab U.S. Large-Cap ETF','Schwab Strategic Trust - Schwab U.S. Large-Cap ETF',]
ID: '^VMBS' Found in (2): ['Vanguard Group, Inc. - Vanguard Mortgage-Backed Securities ETF','Vanguard Group, Inc. - Vanguard Mortgage-Backed Securities ETF',]
ID: '^VNQI' Found in (2): ['Vanguard Group, Inc. - Vanguard Global ex-U.S. Real Estate ETF','Vanguard Group, Inc. - Vanguard Global ex-U.S. Real Estate ETF',]
Name: 'Schwab Strategic Trust - Schwab 5-10 Year Corporate Bond ETF' Found in (2): ['Schwab Strategic Trust - Schwab 5-10 Year Corporate Bond ETF','Schwab Strategic Trust - Schwab 5-10 Year Corporate Bond ETF',]
Name: 'Schwab Strategic Trust - Schwab Emerging Markets Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab Emerging Markets Equity ETF','Schwab Strategic Trust - Schwab Emerging Markets Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab Fundamental Emerging Markets Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental Emerging Markets Equity ETF','Schwab Strategic Trust - Schwab Fundamental Emerging Markets Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab Fundamental International Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental International Equity ETF','Schwab Strategic Trust - Schwab Fundamental International Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab Fundamental International Small Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental International Small Equity ETF','Schwab Strategic Trust - Schwab Fundamental International Small Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab Fundamental U.S. Large Company ETF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental U.S. Large Company ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Large Company ETF',]
Name: 'Schwab Strategic Trust - Schwab Fundamental U.S. Small Company ETF' Found in (2): ['Schwab Strategic Trust - Schwab Fundamental U.S. Small Company ETF','Schwab Strategic Trust - Schwab Fundamental U.S. Small Company ETF',]
Name: 'Schwab Strategic Trust - Schwab International Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab International Equity ETF','Schwab Strategic Trust - Schwab International Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab International Small-Cap Equity ETF' Found in (2): ['Schwab Strategic Trust - Schwab International Small-Cap Equity ETF','Schwab Strategic Trust - Schwab International Small-Cap Equity ETF',]
Name: 'Schwab Strategic Trust - Schwab U.S. Large-Cap ETF' Found in (2): ['Schwab Strategic Trust - Schwab U.S. Large-Cap ETF','Schwab Strategic Trust - Schwab U.S. Large-Cap ETF',]
Name: 'Vanguard Group, Inc. - Vanguard Global ex-U.S. Real Estate ETF' Found in (2): ['Vanguard Group, Inc. - Vanguard Global ex-U.S. Real Estate ETF','Vanguard Group, Inc. - Vanguard Global ex-U.S. Real Estate ETF',]
Name: 'Vanguard Group, Inc. - Vanguard Mortgage-Backed Securities ETF' Found in (2): ['Vanguard Group, Inc. - Vanguard Mortgage-Backed Securities ETF','Vanguard Group, Inc. - Vanguard Mortgage-Backed Securities ETF',]
4 Posted by dtd on 07 Sep, 2025 11:53 PM
That is a mess.
you might be able to combine these using toolbox, but that will pick one sedol/cusip, and then you'll get this repeated at some point. there should be one main one that shows up versus older ones, but i doubt either of us would remember such.
i don't have as many as you do, and Ive figured out the sedol used (also in schwab) currently for some cases, but not all... i change those manually each time i see one.
@Stuart - can securities like this be combined? can the sedol/cusip table in toolbox be edited to allow more than one sedol? (i don't think so, and even if yes, i don't know if md would interpret it correctly.)
@Roger - create a brand new thread pointing out this inadequacy in moneydance. I've done it more than once, but this would help show it's an endemic problem that needs a solution.
5 Posted by mdu on 08 Sep, 2025 05:24 AM
Yes, this is an issue for me as well. I have two accounts that each have close to 300 securities. In one account when I downloaded the transactions, the security ID / SEDOL is ^ABT (Abbott Labs) and in the other it was ^002824100 (the CUSIP). I can't match them - and so have 600 securities. Also, when you first import the security it doesn't set the ticker - so I would have to do that manually. Then, using the toolbox merge tool doesn't seem to have batch merging, so I would have to use the pull down for all 300 securities.
I spend so much time reconciling MD entries with my brokerage fixing non-matching securities - that I have no time left to actually do analysis to see the performance. Then the cycle starts over the next month... :-(
6 Posted by mdu on 08 Sep, 2025 05:58 AM
Also, to clarify - if one account uses CUSIP and the other uses SEDOL for the security ID - do I keep both Securities and set the ticker to the same? Otherwise, when I download future transactions, in one account it'll not be able to match because I switched the security id from SEDOL to CUSIP?
Any smarter way to manage this until MD knows they are the same security?
7 Posted by dtd on 08 Sep, 2025 08:00 PM
It needs to be fixed and we need to state this in the forums... right now attention is being paid to the "squeaky wheels", not to this matter (though we may be starting to get attention as this becomes more noticed and mentioned bu users)
As to how to manage this for now? nothing easy, i have nothing like 300 duplicates and am fixing mine by hand, and yes it happens each time there is a dividend or something like that.
8 Posted by Roger Rice on 08 Sep, 2025 08:06 PM
Sorry, a bit confused…. Isn’t this “the forums?” Do I need to start this thread somewhere else?
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
9 Posted by dtd on 08 Sep, 2025 08:13 PM
Sometimes different forum areas get more attention. Like the Problems area might get more attention than Investments because of the type of posts that occur in them.
10 Posted by dtd on 08 Sep, 2025 08:14 PM
You can also be more specific now as to what the Problem is.....
11 Posted by mdu on 09 Sep, 2025 05:52 AM
Ok - I created the following thread in the Problem forum.
Do you know if Quote Loader supports two securities with different security IDs but same ticker? I tried yesterday but didn't see both of them - will play around more tomorrow.
12 Posted by derekkent23 on 09 Sep, 2025 08:12 AM
I am not support staff just a user.
Hi mdu
As you have found some Financial Institutions in there downloads, when the same Security exists in more than one Investment Account, indicate to which account the data should be routed by adding an extra identifier. This is not a situation I have personally faced.
You questioned if there is a work around in Quote Loader to overcome the principle set by Moneydance that for a given security there should be only be only one ticker, including any hidden identifiers, across all accounts, maybe, see the section Duplicate Securities page 12 of my PDF “Quote Loader V2 Extension Moneydance 2022-2024 V12.5” attached to post 220 at
https://infinitekind.tenderapp.com/discussions/investments/7595-quo...
This feature was introduced some year back to help a user in a similar situation to yourself. As stated this is not a situation I face so I don’t know if it is a fix that would work for you.
Perhaps restore a backup and test the solution it offers to see if it works in your case.
Hope this helps.
13 Posted by mdu on 10 Sep, 2025 05:38 AM
Thanks, derekkent23. Yes, I tried it out - on ticker : ABBV, I created a 2nd ticker called ABBV#1 and saw Quote loader source set to 'copy from primary'