tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/6065-mismatched-security-downloadInfinite Kind: Discussion 2021-11-02T23:50:19Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-02T15:08:54Z2021-08-02T15:08:54ZMismatched security download...<div><p>I just took a peek at the internals of this.. As far as I can roughly tell the process is as follows:</p>
<p>This is all linked to the 'CUSIP' hidden data that MD stores against the Security Master records (NOTE: This will therefore be shared across all Investment accounts).</p>
<p>Within the OFX datafile you should see this data for the Security in question:<br>
UNIQUEID<br>
UNIQUEIDTYPE<br>
SECNAME<br>
TICKER</p>
<p>The popup match rules are as follows:</p>
<ul>
<li>
<p>Search all known Security Master records, checking each one for the hidden CUSIP data using 'UNIQUEIDTYPE' as the key. Return the UNIQUEID found.</p>
</li>
<li>
<p>If a UNIQUEID was found for UNIQUEIDTYPE and only if it MATCHES the UNIQUEID in the ofx download, then use this Security found and continue - No popup screen needed..</p>
</li>
<li>
<p>If there was no data found for UNIQUEIDTYPE against a Security, then add it as a candidate for user selection.</p>
</li>
<li>
<p>HOWEVER, if the search found a Security using UNIQUEIDTYPE, but the UNIQUEID was different to the one in the OFX file, then it's skipped and ignored. Hence, it will be missing from the popup list.</p>
</li>
<li>
<p>Then it sorts the candidates.</p>
</li>
<li>
<p>User selects a candidates</p>
</li>
<li>
<p>If user cancels selection, return None</p>
</li>
<li>
<p>If selected security is None (of the above)... then it creates a new Security and sets the hidden CUSIP data against that new security.</p>
</li>
</ul>
<p>Function returns the user-selected or new Security.</p>
<p>Additionally, TICKER gets put into the Security's Ticker field if it is empty.</p>
<p>Thus, if the popup match screen is not listing some securities, then those Securities must already have the hidden CUSIP using key UNIQUEIDTYPE set to a different UNIQUEID.</p>
<p>The good news is that the Toolbox extension lets you see/edit the hidden CUSIPs. Assuming you are on MD2021.1(3069), install Toolbox. Advanced Mode. Online Banking (OFX) Tools Menu. Reset/Fix/Edit/Add CUSIP Banking Link</p>
<p>I would suggest you look to see what data is set and why it's different to your OFX file. Is it possible that two different Financial Institutions are using different IDs for the same Security?</p>
<p>With more info, I could probably help further.....</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-02T15:44:17Z2021-08-02T15:44:17ZMismatched security download...<div><p>PS. I forgot to say. To see the OFX data if using direct connection:</p>
<p>Help/Console. Keep console open (do not close it)</p>
<p>Now do your download</p>
<p>Go back to console and you will see the ofx data.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-02T22:27:14Z2021-08-02T22:27:14ZMismatched security download...<div><p>Further info. I suspect what you are looking for in your OFX data is something like:</p>
<pre>
<code><SECID>
<UNIQUEID>78468R622
<UNIQUEIDTYPE>CUSIP
</SECID></code>
</pre>
<p>Hence, if you use toolbox to look at the CUSIPs, you want to see if the Security NOT appearing in the match list already has a different CUSIP number set.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T09:12:45Z2021-08-03T09:12:45ZMismatched security download...<div><p>If it helps, I have just added a simple option to list all existing stored CUSIPs to the PREVIEW version of Toolbox. In Online Banking (OFX) Tools menu.</p>
<p><a href="https://github.com/yogi1967/MoneydancePythonScripts/raw/master/toolbox.zip">https://github.com/yogi1967/MoneydancePythonScripts/raw/master/tool...</a><br>
(Unzip. Drag toolbox.mxt onto the MD left sidebar to install).</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T15:46:52Z2021-08-03T15:46:52ZMismatched security download...<div><p>I'll have time to look into this later today. QQQ was never a problem in VG downloads for years. Some time ago, Invesco changed the name to QQQQ, and then later back...noticed problems some time after this. I used to download the OFX file and import, but as MD was updated and allowed direct online import, I used that feature.</p>
<p>I do have MD2021.1(3069), so I'll try Toolbox later today.</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T18:35:49Z2021-08-03T18:35:49ZMismatched security download...<div><p>Stuart, this is a very powerful extension, congrats. As a Linux user, I'm familiar with getting in deeply and making things worse than they had to be, so please help me understand a few things. In MD > Security History > Edit > for "INVESCO QQQ ETF" the "security ID" = ^46090E103 while Toolbox shows CUSIP ID: 73935A104. Is this where the mismatch is coming from? If so, which do I change?</p>
<p>I'm reluctant to follow your comment #2 because although I get my FI data via direct download thru MD, I've already downloaded up-to-date info and might only get mismatched QQQ again. Or does everything download but just not get entered into MD if it's duplicate info? In which case it would be meaningful to my situation.</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T18:48:04Z2021-08-03T18:48:04ZMismatched security download...<div><p>A quick Google reports:</p>
<pre>
<code>Ticker Symbol: QQQ
CUSIP: 46090E103
Previous CUSIP: 73935A104</code>
</pre>
<p>So. BINGO. YES this is the issue.</p>
<p>You need to use the advanced mode, edit CUSIP feature to update the security to read<br>
46090E103</p>
<p>Please download/use the latest toolbox preview, I updated it only 30 minutes ago.</p>
<p>(Not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T19:15:04Z2021-08-03T19:15:04ZMismatched security download...<div><p>Got newest toolbox preview & installed. MD complains it is not verified. Assume it's fine and a future update from MD will installed the verified version. Right?</p>
<p>When doing the fix, got this msg: ERROR: You have old format Security record(s). Consider running 'MENU: Currency & Security tools>Diag/Fix Currencies/Securities' option first. ...not sure what I'm getting into here?</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T19:38:43Z2021-08-03T19:38:43ZMismatched security download...<div><p>Ok. Do this. All will be well! Promise!</p>
<p>Manage extensions. Installed. Toolbox. Remove (the preview).<br>
Click over to the Available extensions tab. Select Toolbox. Install (the current signed version)</p>
<p>Now….:<br>
Tools / securities<br>
Select and edit the QQQ security<br>
Change the ‘current price’ to something else. Enter. Save. Exit the window.<br>
Repeat. Change the current price back to what it was. Enter. Save. Exit the window.<br>
(I won’t bore you with why, but this fixes a hidden data issue you already have internally, nothing to do with toolbox).</p>
<p>Now run toolbox (this should be the original version you ran first time now)<br>
Select the edit CUSIP option.</p>
<p>Edit the cusip accordingly.</p>
<p>All will be well.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T21:47:50Z2021-08-03T21:49:08ZMismatched security download...<div><p>OK, followed your info...seemed to work well. However, had a MD freeze at the end...possibly too many balls in the air! Restarted from latest BU and redid the download. That also seemed to work and now there is one QQQ account with the proper shares, price etc. So that problem seems solved. Kudos to your extension and help!</p>
<p>However, the process uncovered another mismatch also at VG. This does not involve the CUSIP which are correct for both of the MMarket funds involved. VG did a recent switch from my old MM (VMXX) to a new one called VMRXX (the R for "reserve"). Now both appear in this account. Stuart I realize this is sort of a new question, but I hope you can continue with me on this. I need to move VMMXX to VMRXX. Should I simply "sell" the one and "buy" the other or might this tangle things up?</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T21:55:01Z2021-08-03T21:55:01ZMismatched security download...<div><p>Toolbox 🧰 +1 😃 (CUSIP fix)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T21:56:40Z2021-08-03T21:56:40ZMismatched security download...<div><p>It depends whether these are the same security or whether they are two different securities?</p>
<p>If the same, then the toolbox preview can merge securities for you. If the latter, then it sounds like you should do a sell/buy?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493183582021-08-03T23:41:45Z2021-08-03T23:41:45ZMismatched security download...<div><p>VG created a new MM security VMMRXX for their purposes and moved my funds from previously long held VMMXX to the new fund. So VMMXX no longer shows up as a security held by me in this account. However, I think it still does exist as a fund but it's used for other purposes. I read the info when they made the change, but in one ear out the other...just another thing FIs do probably to save a dime on their side. I'll probably have to check with VG to see which it is. In any case, you've given me the path. Thx! Everything else looks good...and I've learned how to deal with this issue.</p></div>feffer777