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.


  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


? 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