Wrong CUSIP-ID for a couple of Vanguard funds
I have two Vanguard Mutual funds with the wrong CUSIP-IDs in Quicken:
VSBSX – CUSPID #92206C300
VSGBX – CUSPID #922031604
When viewing the Quicken Security List, the securities and their corresponding CUSIP-IDs are presented.
The VSBSX has no CUSPID ID listed; VSGBX has the wrong CUSPID – it is the CUSPID of VSBSX.
The edit function of the Security List will not allow edit of the CUSPID or even deleting of a security.
I contacted Quicken support – “Chat”; after spending more than an hour, including direct phone conversation, it was their conclusion that there is no remedy
Comments
-
This can be sorted out with a little work. I'm assuming the transactions associated with the Symbols are correct but that only the CUSIPs associated with the symbols are wrong.
Transactions are associated with the Symbol. Here are the steps if I understand correctly. Create a Windows copy of the file first so you can revert back easily if needed.
- Open Tools>Security List. Edit the Names and Symbols of the 2 problem MFs by putting OLD and OLD1 in front of the names and replace the V with a Z in the symbol. Check that the register transactions reflect the new names.
- Open Tools>Security List and use the Add Security button process to create 2 new securities that reflect the correct names and symbols for the MFs. You should see that the CUSIPS for the new securities are correct now.
- You will need to do this step in each register where you have transactions for the 2 MFs.
- Sort the register by Security Name by clicking Name column.
- Scroll down to the first group of "OLD" MF and change each transaction to the corresponding New security.
- Do the same for the "OLD1" group.
- Change sort back to Date.
- Open Security Details for the OLD & OLD1 MFs to verify no transactions are associated with them, then delete them.
2 -
Thank you - I will give it a try and let you know.
0 -
That one Quicken security has no CUSIP means that security is not "Matched" with a brokerage security - one they attempt to download. information for.
That one Quicken is the wrong CUSIP association means that the wrong brokerage identified security is matched to that Quicken security.
I see no need to create new securities. You simply need to correct the matchups. If transaction are currently assigned to the wrong security, that too will need to be corrected, but I have the impression you are already making those corrections.
To correct the matchups —
- For the security with the mis-applied CUSIP, Edit the Security Details and uncheck the box "Matched with online security"
- Tools / Online Center — Select Financial Institution, Holdings Tab — Compare to Portfolio button.
- You should be presented with both securities one at a time to match the brokerage version of the security with one of your Quicken securities. It may well offer to match up as before. Just make sure you make the correct association and not accept the 'offer' too quickly.
I believe that is all you need to do to correct future downloads. Again, if current transactions are incorrect, those will need to be manually edited to make the corrections. Hope this helps
1 -
it's interesting that the CUSIP is not displayed for any holding on the Edit Security menu -
only displays in the Security ListI have VSBSX and my entries are correct -
0 -
it's interesting that the CUSIP is not displayed for any holding on the Edit Security menu -
only displays in the Security ListIt shows with the Other Info page when viewing Edit Security Details.
I would think the Security Details box of the Security Detail View should include both Ticker symbol (now shown in the window header) and the CUSIP along with the current Type and Asset Class.
[Odd behavior - when Type = Mutual Fund, or Stock, Ticker is shown in that box. User created non-standard types do not show Ticker. Why the difference? ]
2 -
FWIW, I chose the route to add securities and rename the old ones so that it was less confusing when trying to re-assign the correct security to the appropriate transactions. If you do not rename the old ones, it could get very confusing keeping track of which transaction gets assigned to which security.
It's literally only a couple of extra steps but could save a lot of time if you start mixing up transaction reassignment.
1 -
I think the one of the things to be careful about is losing or messing up price history. If you do create new securities, I think you would also need to reload price history? Otherwise, depending how long you've had the securities, you might lose price history.
If you change fund IDs to correct the issue, I think you are asked what you want to do with price history - copy over to new, or ignore. Even then it can get confusing, and prices can get easily messed up.
Whatever method you use to correct this issue, should downloading and saving price history for the securities before you change anything be one of the steps?
0 -
Whatever method you use to correct this issue, should downloading and saving price history for the securities before you change anything be one of the steps?
Maybe. It depends - to equivocate on the question. Like, what download processes are used and how frequently? What cross-checking has already been done?
First, is to recognize in this context that prices come from two different sources - the brokerage and Quicken’s sources.
The brokerage prices are tied to the Matching status so if that is matched wrong, the Quicken security will have the wrong price for that date.
The Quicken-source prices are tied to the ticker symbol. If the Quicken security has the right ticker, it will get the right prices.
Now to look at the hierarchy of prices, those from the Quicken sources take precedence over ( override) those from the brokerage. So it seems to me in many cases, each properly tickered Quicken will come away with the proper price history data.
But it always a good idea to check.
0 -
@q_lurker you said “The brokerage prices are tied to the Matching status so if that is matched wrong, the Quicken security will have the wrong price for that date.” Is that referring only to the source of the prices or does it mean any price history obtained from your brokerage would be lost if you unmatched the security?
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
If you don't save the prices before you set up the new securities, I think you will lose historical prices for those securities because Quicken has limited historical prices available for the "Get Historical Prices" function.
Quicken downloads daily prices of the selected securities for the most recent month, weekly prices for the 11 months prior to that, and monthly prices thereafter, up to 5 years.
0 -
No, the price history from the brokerage is NOT lost when unmatching the security. The brokerage’s price is entered into the price-history records upon the download.
The IF at that point is the existence of prices from Quicken’s sources. If Q-source prices already exist for that date, the brokerage price will not be entered; the Q-source data takes precedence. If Q-source data is later downloaded for that date, the brokerage price will be overridden and ‘lost’.
1 -
I wasn’t specifically addressing the new security approach because, frankly, I doubt I would use it. And I agree with your comment about the availability of historical prices.
In the step 1 from @markus1957 he suggested changing the ticker on the existing Quicken securities from V____ to Z____. When making that type of ticker change, Quicken prompts with two independent options (as you also suggested earlier):
- Copy old ticker prices to the new ticker - defaults to yes and usually the better choice, and
- Delete the prices for the old ticker -defaults to Don’t (No) and in my opinion appropriate choice depends on the circumstances.
In this case for the second option, I suggest the appropriate choice is the default, don’t, No option. That leaves the prior price history data for V____ in place for when the new security is created with that ticker.
Still good to check.
1
