Home → Investments →

Duplicate investments

• Edit

kerrychesbro

17 Jan, 2023 03:12 AM

I am following:
https://infinitekind.tenderapp.com/discussions/investments/6065-mismatched-security-download

I found these entries for a duplicate investment.
SCBP1 ^SCBP1 PLAID:ins_11 SCBP1 ** CUSIP & TICKER ARE DIFFERENT **
TOTAL MARKET EQUITY INDEX POOL ^808516702 SCBP1 CUSIP 808516702 ** CUSIP & TICKER ARE DIFFERENT **
Recently, I noticed that the transaction downloads from Schwab Charitable changed from the TOTAL MARKET EQUITY INDEX POOL investment to SCBP1. In addition, the portfolio share count on SCBP1 is negative (due to sells) while the count on TOTAL MARKET EQUITY INDEX POOL holds the share number before the sell transactions. The total is correct with the current share count in the account.

Obviously, since the new transactions are named SCBP1, that is the one to be kept when using the toolbox Merge Securities. However, this merge is not a match due to the CUSIP differences. But since SCBP1 has PLAID in the SCHEME column I don't feel good about changing the CUSIP of 808516702 to SCBP1 so the match can happen for the merge securities.

Would I be OK to change the CUSIP on TOTAL MARKET EQUITY INDEX POOL to match and then use the securities merge tool?

1. 1 Posted by Stuart Beesley ... on 17 Jan, 2023 07:24 AM

   

   Try it. Nothing bad will happen. The possible worst thing is you could get another dup security depending on what plaid is sending.

   Make a backup/test system.
   File / export backup / xxxbackup
   File / restore backup / xxxbackup, UNTICK retain sync settings

   Make the changes. Check everything. You can even try md+ download.

   Then after the test, file/open your original dataset and then reapply the same changes…

   • Edit

2. 2 Posted by kerrychesbro on 18 Jan, 2023 11:52 PM

   

   OK, I changed the CUSIP on SMALL CAP EQUITY POOL and the two investments now
   show:

   SCGS1 ^SCGS1
   PLAID:ins_11 SCGS1 ** CUSIP & TICKER ARE DIFFERENT **

   SMALL CAP EQUITY POOL ^SCGS1 SCGS1
   CUSIP SCGS1

   The merge will not show these as a possible merge, even though the current
   price and security ID are the same.

   So, I put in a CUSIP entry in SCGS1, thinking that the scheme needed to
   match.

   So now there are 2 lines in the CUSIP list for SCGS1. The merge was still
   not picked.

   SCGS1 ^SCGS1
   PLAID:ins_11 SCGS1 ** CUSIP & TICKER ARE DIFFERENT **

   SCGS1 ^SCGS1
   CUSIP SCGS1 ** CUSIP & TICKER ARE DIFFERENT **

   Rolling back to the backup.

   Any ideas?

   • Edit

3. 3 Posted by Stuart Beesley ... on 19 Jan, 2023 05:37 AM

   

   Are you sure?

   You are showing the CUSIP report and not the output from the merge duplicate securities function? As far as I can see, the merge utility asks you to select a CUSIP strategy, not to block the merge..? Please can you send the output of the merge utility showing the reason why the merge cannot run? (there should be a text report on screen)..?

   OR there's another reason why the merge is blocked...
   - Are decimal places the same? - Are the Tickers the same? - Are the IDs short and DIFFERENT? - Are the relative currency's the same - Are the Current Price(s) exactly the same? - Are the prefix/suffix the same on both securities? - Are the splits the same?

   Perhaps send screenshots of the tools/security screen - both front screen and edit for both securities... And also the toolbox decimal places report too..?

   • Edit

4. 4 Posted by kerrychesbro on 19 Jan, 2023 02:54 PM

   

   Hi Stuart,

   First, thank you so much for the toolbox extension. I gave up on merging the duplicate securities from QIF imports 2 years ago when I converted from Quicken. Now I have hope in getting it fixed.

   - Are decimal places the same? Yes after changing it on the non-master from 4 to 5.
   - Are the Tickers the same? The non-master had a ticker symbol, the master did not, so I removed the ticker on the non-master.
    - Are the IDs short and DIFFERENT? Yes
   - Are the relative currency's the same? Yes
   - Are the Current Price(s) exactly the same? Yes
   - Are the prefix/suffix the same on both securities? Yes
   - Are the splits the same? Yes

   Here are the items you requested:

   SCGS1 DPC: 5 Relative to: US Dollar Current rate: 35.9300894191 Rate dpc: 10
   SMALL CAP EQUITY POOL DPC: 4 Relative to: US Dollar Current rate: 35.9300894191 Rate dpc: 10

   I corrected the SMALL CAP EQUITY POOL to:
   SMALL CAP EQUITY POOL DPC: 5 Relative to: US Dollar Current rate: 35.9300894191 Rate dpc: 10

   Hidden CUSIP
   SMALL CAP EQUITY POOL ^808516876 SCGS1 CUSIP SCGS1
   SCGS1 ^SCGS1 PLAID:ins_11 SCGS1 ** CUSIP & TICKER ARE DIFFERENT **
   After removing the ticker:
   SMALL CAP EQUITY POOL ^808516876 CUSIP SCGS1 ** CUSIP & TICKER ARE DIFFERENT **

   The merge still does not have these two securities in the list of failed checks.
   At the bottom:
   Merge 'Duplicate' Securities (by 'ticker'): Not enough Securities / no valid duplicate Tickers found (refer report on screen for details) - NO CHANGES MADE

   • Picture3.jpg 163 KB
   • Edit

5. 5 Posted by Stuart Beesley ... on 19 Jan, 2023 03:05 PM

   

   And here is your problem…:
   “so I removed the ticker on the non-master. “

   It will only work on securities with Tickers - this is the primary key… So, set a ticker (the same) on both.. Try again..

   Let me know?

   • Edit

6. 6 Posted by kerrychesbro on 19 Jan, 2023 04:06 PM

   

   This worked now. Many thanks for being patient.
   So, in the end, I had to change:
   1. Same non-blank ticker symbol (MD/Tools/Securities/select security then Edit)
   2. Same current price (MD/Tools/Securities/select security)
   3. Same non-blank ticker symbol (MD/Tools/Securities/select security thenEdit)
   4. Same Value Suffix (MD/Tools/Securities/select security then Edit)
   5. Same hidden decimal places
       View in Toolbox/Currency and Security tools/DIAG: List ... hidden decimal places.
       Change in Toolbox/Currency and Security tools/FIX; Edit a Securities hidden decimal place.
   6. Same CUSIP
      View in Toolbox/Online Banking Tools/View Securities hidden CUSIP settings.
      Change in Toolbox/Online Banking Tools/Reset ... CUSIP Banking Link then NO to select security.

   I suggest on your next release where you have the merge requirements:
   The check / validation rules are:
   - Find potential 'duplicates' where Securities' 'Ticker' Symbols are the same; then Duplicate Security's...:
   ... ID must be short and DIFFERENT (so you can identify them in this process). Examples: use '^APPL1', '^APPL2', '^APPL3'.. to merge 3 Apple Stocks
   ....(^^Close this window and use Tools>Securities>EDIT and change the Security ID for each duplicate and then re-run this function again)
   ...'Currency' must match
   ...'Current Price' must match
   ...'Prefix' & 'Suffix' must match
   ...'Splits' data must match
   ... hidden 'Decimal Places' setting must match **
   - NOTE: Security Name is not matched, but you can select the Security to become the 'master', that has right details, as part of the process

   Add:
   Ticker symbols must match and cannot be blank.

   • Edit

7. 7 Posted by Stuart Beesley ... on 19 Jan, 2023 05:27 PM

   

   Toolbox 🧰 +1 😃

   Thanks for feedback - done!

   • Edit