Unable to Match the Same Securities that report CUSIP and SEDOLs respectively
Please see the discussion in the investments form. (https://infinitekind.tenderapp.com/discussions/investments/9650-cant-match-security)
As dtd noted: "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."
Huge issue for me:
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.
Even if I were to merge, when I update the account - it won't match because I converted all of securities to SEDOL or CUSIP. MD needs to know that both securities are the same (they have the same ticker).
I'm not aware of a work around. So every month, I get a huge number of deltas and spend hours reconciling.
Showing page 2 out of 2. View the first page
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
30 Posted by sth on 24 Sep, 2025 12:48 PM
Glad you found a solution. It is odd that Plaid is showing only a ticker symbol of KIM and CUSIP and SEDOL of NULL yet it seems that MD is filling in those fields with some data? Not sure what "SecurityId -> oJ9Y46Y.." is. Maybe some internal Plaid identification? I can't find any reference to that string in the description of the security.
This should not create a new security but match the one with the same TICKER.
-Scott
31 Posted by sth on 24 Sep, 2025 01:16 PM
Actually this just happened to me today and I looked into it as well. It seems odd that toolbox tells me that the CUSIP and TICKER are different.
Vanguard ESG U.S. Stock ETF ^ESGV SEDOL ESGV ** CUSIP & TICKER ARE DIFFERENT ** id: a1e667be-5d1b-4063-aab7-3d68e0cdeba5
Vanguard ESG US Stock ETF ^921910733 ESGV SEDOL BF5J5D4 ** CUSIP & TICKER ARE DIFFERENT ** id: 1f947307-91f5-4284-ae20-bce5cf149e2e
Vanguard ESG US Stock ETF ^921910733 ESGV CUSIP 921910733 ** CUSIP & TICKER ARE DIFFERENT ** id: 1f947307-91f5-4284-ae20-bce5cf149e2e
The top one is the newly created security that should be the same as the one below. It has a new name (U.S. vs US) but it ends up with a blank TICKER and uses the ^ESGV as the Security ID and for some reason puts the TICKER in the SEDOL.
The other two are the the same md security ID but one line is listing the SEDOL and the other the CUSIP. However, they all have that weird caret (^) in front of the ID. Why is toolbox telling me that the CUSIP and TICKER are different? That is the correct CUSIP. CUSIP is a 9 alphanumeric code unlike a TICKER and they should NOT Match. (@Stuart B, care to comment).