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.
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 Stuart Beesley ... on 09 Sep, 2025 06:52 AM
+1 following.
2 Posted by dtd on 09 Sep, 2025 08:15 PM
+1 following
3 Posted by sth on 13 Sep, 2025 02:02 PM
+1 following. But you can use Toolbox (+1 toolbox) to set a "hidden" secondary id be it CUSIP or SEDOL for a security. I have used this to straighten out my downloads that kept adding some odd Montana Mining stock to my portfolio with no activity.
Toolbox can list all the securities and their primary and secondary IDs. Sometimes these get odd entries from incorrect uploads.
(NOT IK Support)
4 Posted by mdu on 13 Sep, 2025 03:23 PM
sth, where is this located? I'm looking at the currency & security tools but don't see that choice (see screenshot). Just hidden price_date and decimal. Also, is there an API that I can call in the developer console to set this value?
Right now, I'm trying to update my accounts to use duplicate securities - where I have two ticker symbols: (e.g. ABBV and ABBV#1) where one uses CUSIP and the other SEDOL for their IDs. I have now over 600 securities and now am in the process of attributing the right security to the right account as before I would manually point them to the same security each time I downloaded new transactions. However, I'd like to see if the secondary ID works before I spend more hours on this.
5 Posted by dtd on 13 Sep, 2025 06:24 PM
sth - can you set two sedols to the same security? thats my problem. i do know how to set a cusip/sedol combination with toolbox, but doing so does involve being careful in doing so.
6 Posted by sth on 13 Sep, 2025 11:51 PM
@mdu, this is a problem when there is only either a SEDOL or a CUSIP and two different securities. Pick one of them, and add the other identifier so one of them has both. Rename the other security with a "-old" suffix.
Then find all transactions with the "-old" suffix and move them to the correct one. It can be a bit tedious. This functionality is in the "Online Banking Tools" for some reason. But there is a view CUSIP/SEDOL info and then in Update Mode, there is a reset/edit/delete hidden SEDO info option.
@dtd, I don't think that there can be two different SEDOLS for the same security any more than there can be two different tickers. That would be a violation of the whole concept of SEDOL and CUSIP structure. I haven't tried to set two SEDOLS for a security (one the visible and one hidden). I don't know if MD or Toolbox stops you from making such a mistake.
7 Posted by dwg on 14 Sep, 2025 12:16 AM
FWIW I tried setting up a SEDOL ID and then tried adding a second one, it just overwrote the value.
8 Posted by dtd on 14 Sep, 2025 12:41 AM
THe issue with two sedols is the banks will sometimes change the sedol. they shouldnt, but they do. so when you get a download, you get the picklist, but you dont get to pick the correct security... you can only pick none of the above (unless you pick a wrong security with no sedol of course). so you cant, with md, even change the sedol like dwg probably did with toolbox.
so you can get two sedols, and neither being given a way to make both sedols attached to one security OR overwrite the old sedol with the new one (as once a bank switches sedols, it doesnt tend to go back to the old one).
i know what tends to cause a sedol change, but thats another topic.
9 Posted by dwg on 14 Sep, 2025 01:14 AM
@dtd
As you correctly assumed I used Toolbox for my test, I just wanted to see if you could have two SEDOLs. I know that Moneydance will not allow you to pick an existing security, it is making the assumption there that the institutions do the right thing.
However, the institutions are very good at not following even the most basic of rules with the transactions downloads, even going as far back as QIF they seemed incapable of it.
10 Posted by mdu on 14 Sep, 2025 06:51 AM
@sth thanks for pointer to online banking tools. I have a total of 916 securities. Is there an API to revise the hidden CUSIP? I can write the python code if I know the call. There are ~9 steps (1. pick online banking, 2. pick reset/fix/edit, 3. would you likely manually add a cusip, 4. fix cusip / select on of 916, 5. are you sure? 6. perform backup? 7. disclaimer: IAGREE 8. New CUSIP 9. New CUSIP ID) Otherwise, I'll be busy for quite some time manually updating so many securities.
11 Posted by Stuart Beesley ... on 14 Sep, 2025 08:22 AM
It’s a bit messy, but refer to:
CUSIPFix()
In toolbox.py
From my repo:
https://github.com/yogi1967/MoneydancePythonScripts/tree/master/sou...
It should give you the gist.
12 Posted by sth on 14 Sep, 2025 02:03 PM
I don't believe that banks can "change a SEDOL". Those are issued by the London Stock Exchange, period.
https://en.wikipedia.org/wiki/SEDOL
However, Banks may be rolling a security over to another year (CDs or other notes) and it is technically a different security that is similar but not the same. A different series, date etc. It may be convenient for you to think of it as the same security but it is technically different.
Good for MD not allowing two different IDs of the same type (CUSIP or SEDOL). Though you can have two with the same Ticker (well technically not different) since the name of the security can change sometimes arbitrarily. For example, I had a mutual fund that was in the Strong family of funds years ago and had liquidated the position for many years. Later I put some funds in a Wells Fargo fund, and when checking on my file with Toolbox (+1) it tells me that I have two funds with the same Ticker. Well they are different names and I think of them as being different investments for different purposes they do get flagged by Toolbox as a conflict (as it should).
13 Posted by dtd on 14 Sep, 2025 06:13 PM
Getting into what causes a sedol change, it is often a security name change. like Disney became Walt Disney Co at schwab, with a different sedol, but still ticker DIS for both. are you saying this is correct and i should now live with two investments for Disney ?
I dont think that's appropriate, and it is a pain to combine them each month. there are ways to fix this permanently (its not simple) but this sedol change happens fairly often, especially with moves from ofx to md+ (usually cusip to sedol) and security name changes (usually cusip/cusip or sedol/sedol) that are the same ticker and same investment.
14 Posted by sth on 14 Sep, 2025 09:32 PM
@dtd, I agree that is a pain and there shouldn't be two SEDOLs for disney. AFAICT, "The Walt Disney Company" Ticker: DIS
Security ID: 254687106
CUSIP: 254687106
ISIN: US2546871060
SEDOL: 2270726
Now that SEDOL is an End of Day for a specific exchange (I assume that is DIS:NYQ. I suppose there could be different prices as different exchanges close at different times in different currencies.
But "Disney" or "The Walt Disney Company" has always had the same Ticker and should not have varying SEDOLs even though the name changes. Are you saying that when the corporate name change happened there was a new SEDOL? And that both the old and new SEDOLs are active?
Sometimes MD will have some archived information with incorrect CUSIP and/or SEDOL. MD will think these are two different equities even though one SEDOL is completely wrong. But that is a fix internal to MD and doesn't mean that there are two SEDOLs. You can test this by making two securities with the same correct CUSIP and different (and both incorrect) SEDOLS and they will track as separate equities though they are not and MD will keep using the CUSIP reference.
15 Posted by dtd on 15 Sep, 2025 02:20 AM
usually the new sedol is the current one and the old one stops being used, i can sometimes overwrite the old sedol and that works but not always... of course i have to do that in toolbox, as the picklist showing the new sedol wont let you pick disney at all.
16 Posted by mdu on 15 Sep, 2025 09:41 PM
@stuart beesley - thanks for the pointer. reads linearly without calling functions - making it easy to find the scheme calls.
I think my brokerage has updated the IDs to using Tickers instead of CUSIP. Here are 3 separate entries for ADBE that the tool showed:
I'm not sure what 2008154 is given SEDOL for ADBE is BOYLL83. I'll sort that one out separately as that seems to be an exception and most are CUSIP and Tickers.
So if I do the following:
Set Security ID to Ticker name, set SCHEME to CUSIP, and set hidden CUSIP to CUSIP number
does anyone see an issue? I can then remove all the TICKER#1 symbols and cull the security list down.
17 Posted by sth on 15 Sep, 2025 10:00 PM
@mdu, I would:
(NOT IK Support)
18 Posted by mdu on 16 Sep, 2025 03:50 AM
Hi sth,
When I had downloaded all new transactions to the investment account, the Hidden CUSIP was the TICKER, and the security ID was ^TICKER. If I delete the ticker from the security ID and hidden id, I fear that it will want to create the investments again.
I don't see any SEDOL values being used. In fact, when you google SEDOL Adobe Systems, it says:
"While a SEDOL is issued for securities traded on the London Stock Exchange, Adobe Inc. is a U.S.-based company whose stock is primarily traded on the Nasdaq. Therefore, a Stock Exchange Daily Official List (SEDOL) value is not the standard identifier used for its common stock. For tracking Adobe's stock, you should refer to its stock ticker symbol and its International Securities Identification Number (ISIN). ISIN: US00724F1012. This is the international securities identifier for Adobe's stock.
CUSIP: 00724F101. This is the identifier used in the U.S. and Canada.
"
Or am I missing something in my assumptions?
19 Posted by sth on 16 Sep, 2025 02:59 PM
You can use ISIN, but there is a translation from SEDOL to ISIN as well. I suppose it is your choice of ISIN over SEDOL. MD does not allow more than 3 different identifiers. (TICKER, Security ID, and hidden secondary ID)
The security ID should not be ^TICKER, that is redundant and causes some of the confusion you are seeing.
I did find a SEDOL for Adobe with a little googling and used that in my example. But note that the ISIN (US00724F1012) is just the SEDOL (00724F101) with a check digit and a country identifier.
20 Posted by mdu on 17 Sep, 2025 04:07 AM
I believe the brokerage is using the TICKER for SEDOL. Nowhere do I see an actual SEDOL - just TICKER and CUSIP. Correct me if I'm wrong, if I use either the ISIN or SEDOL, it won't match.
See screenshot - you can see Abbvie says SEDOL is ABBV.
21 Posted by sth on 17 Sep, 2025 04:28 AM
I really doubt that I can tell you what your named brokerage is using as a SEDOL. Nor can I state that you don't believe that. But I would think that is a level of incompetence that I doubt that an actual brokerage would attain.
It would help if you posted the OFX transaction where the brokerage defines the SEDOL as the ticker symbol.
Actually if you use CUSIP or SEDOL, MD will match the security to either one. Or even if it just matches the Ticker without either the Security ID or the secondary security ID being defined.
22 Posted by mdu on 23 Sep, 2025 06:26 AM
@sth, I did the following experiment - In toolbox, banking, view your security's hidden CUSIP shows the following:
Notice I have the SEDOL, CUSIP and Ticker defined.I then downloaded transactions and it showed me the following question prompt unable to match security Kimco (see attached image).
Once I select None of the Above - my hidden cusip looks like the following:
Any ideas why KIM couldn't match the existing SEDOL/Ticker/CUSIP and why my transaction said SEDOL with hidden id KIM?Happy to modify the entry to what you think I should try so it can sync correctly?
23 Posted by Stuart Beesley ... on 23 Sep, 2025 06:43 AM
It looks like they are sending KIM as the ID instead of one of the numbers already saved.
24 Posted by sth on 23 Sep, 2025 02:29 PM
So the top one looks completely correct. I have no idea why there is a caret (^) in front of the ID (CUSIP). It doesn't seem to cause problems that I have seen. Those numbers look correct.
https://www.ayondo.com/en/technical-analysis/US49446R1095
The second one has a redundant CUSIP which should not hurt things
However the last one is completely wrong. It uses the TICKER as both the CUSIP and the SEDOL but not the actual ticker. It appears that you are loading this from a brokerage as an OFX file? Or Plaid? Plaid sometimes gets things very messed up. And there is no way for an enduser to get them to correct it. Possibly IK can complain since they are paying for the service.
The other thing you can do to test Stuart's idea, is to open the console log and turn on OFX and HTTPS tracking. Delete the 3rd security, clear the console log and repeat the test with the console log window open.
This should give you the complete data as sent from your brokerage and see what names are being sent. If the OFX doesn't have a ticker and uses the ticker as the SEDOL and CUSIP then complain to the brokerage. MD relies on the OFX file being accurate. If the OFX file appears accurate, post it here and IK can check why they did not parse it correctly. (blank out account numbers if they are in the file)
(NOT IK support)
25 Posted by mdu on 23 Sep, 2025 03:05 PM
I am using Plaid. Is the enable ofx/https tracking a toolbox option? I see the 'Launch Console Window' button in the toolbox.
26 Posted by sth on 23 Sep, 2025 06:06 PM
Launch the Console window. In the lower left hand corner is an option to turn on various logging.
Basically I think that is a Plaid screw up which I don't know how to fix. Maybe IK support can jump in and ask Plaid to fix it? Somehow in Plaid trying to download and translate that security is garbling the information.
(NOT IK Support)
27 Posted by mdu on 23 Sep, 2025 09:49 PM
Ok - I will check and report back.
However, I'd still like to use Moneydance (IMHO - a really nice application) but can't wait indefinitely for a resolution.
What is the API call (maybe a question for Stu) where I can replace ^KIM with ^49446R109? As I get hundreds of updates per month, I was thinking of writing a script that would update the register to the correct security.
28 Posted by sth on 23 Sep, 2025 09:54 PM
You can find and replace the security by name. So make the correct security with the correct IDs be a slightly different name. Then use find and replace to change all transactions to the correct security. If you remove all transactions with a security it seems to disappear from the list of securities (IIRC).
Would that help? Unfortunately MD is not scriptable but a python script might be possible as internal calls in the "Developer Console".
29 Posted by mdu on 24 Sep, 2025 02:50 AM
Hi sth,
API via dev console best. I can scan all transactions with security ID equals ^Ticker and replace with equivalent cusip version (otherwise leave it alone).
I enabled the Moneydance+ Plaid messages in the log.
There was this one entry (shorted the long SecurityID):
20250923-22:43:25.815 Plaid: Security: InstitutionId -> null; IsoCurrencyCode -> USD; ClosePriceAsOf -> 2025-09-23; ProxySecurityId -> null; IsCashEquivalent -> false; TickerSymbol -> KIM; ClosePrice -> 21.9; Isin -> null; Cusip -> null; Sedol -> null; SecurityId -> oJ9Y46Y...; InstitutionSecurityId -> null; UnofficialCurrencyCode -> null; Name -> Kimco Realty Corporation; Type -> equity;
I didn't find a security id of ^KIM - not sure how that was created.
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