Mismatched securities in download

Johann Beda's Avatar

Johann Beda

26 Jan, 2019 05:56 PM

I seem to have mismatched a securities download at some point in the past. I have a few investment accounts, in both CAD and USD. In the CAD account I hold some shares of VEE.TO. In the USD account I hold some shares of VWO. (These are both Vanguard "emerging markets" ETFs - the similar name is what probably made me select the wrong one when I first downloaded transactions for the USD account.

Each time I download transactions to the USD account, the VWO dividend transactions get entered as VEE dividends, which I then change to VWO and then delete the VEE entry in the USD account's list of securities. I only have a handful of these VWO transactions, but I have almost a decade of VEE transactions in more than one CAD investment account.

According to http://help.infinitekind.com/kb/archive-investments/archive-fixing-mismatched-securities-from-downloads-in-investment-accounts I might be able to fix things if I completely delete the VEE security from Moneydance and import the downloaded transactions again, but I do not want to loose my VEE transaction history (or the share price history)

The securities do have different names, different symbols, and different security ids in MoneyDance:
Ticker symbol. VWO. ISIN: US9220428588, CUSIP number. 922042858
Ticker symbol. VEE ISIN: CA92205X1078, CUSIP: 92205X107

I have been using the CUSIP for the "Security ID" - should I be using the ISIN? The .ofx files I have been downloading seem to have the CUSIP within them.

Is there some way I can break the association MD has between the download info and the "wrong" VEE security?

Thanks in advance for any insight you can offer.

 -jb

  1. System closed this discussion on 27 Apr, 2019 06:00 PM.

Comments are currently closed for this discussion. You can start a new one.

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