Find and replace security names

Tom Goodhart's Avatar

Tom Goodhart

12 May, 2023 05:54 PM

I ran the toolbox tool to fix investments and over 5000 dividend transactions for most of my investments were changed so that the Security now says "TOOLBOX: FIX: ....". The description of the transaction still has "Dividend: Security name...".

Since Find and Replace won't change the Security Name, any ideas on how to straighten out this mess? I've been going through each investment register, using the search box to filter by Description and changing each transaction back to the correct security.

  1. 1 Posted by Stuart Beesley ... on 12 May, 2023 09:23 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK... This probably means that you had dividend txns with no security assigned.. This is logically incorrect.. Toolbox has therefore added a dummy security to these.. Whereas before you would have had to go through 5000 txns and change None to the correct security, now it's easier to see which to do.. Of course, that doesn't help you.

    Questions:

    1. How old are these 5000 dividend txns and how did they get created? Manually? QIF import? md+ download?

    2. Are these all for the same security? If so, you can just rename the dummy security to the correct name?

    3. Are these dividends associated with a security that you manually deleted from the investment account(s) at some point?

    4. If you really don't like what toolbox has done, and if you did this today, can you not just restore the backup you would have taken?

    -- There really is no easy answer... Sorry... You had 5000 dividends with NO security attached... Toolbox has added a dummy security to make the records 'logical'. You still have 5000 txns that need addressing somehow..

    Let me know your answers to the above...?

  2. 2 Posted by Stuart Beesley ... on 12 May, 2023 09:24 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ... unless of course you really think that there was a security attached to these txns before... If so, I would like to see some further detail / clarification in case there is an issue with TB that needs addressing...

  3. 3 Posted by Stuart Beesley ... on 12 May, 2023 09:25 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    feel free to email me directly:
    ...

  4. 4 Posted by Stuart Beesley ... on 12 May, 2023 09:33 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ...PPS - This problem is often quite common with old QIF imports. I think somehow these dividends aren't linked properly.. I would like to work with you to see if there is a better way to handle these - Possible / interested?

    Once quick solution... Given I think these were not linked to any security before, why not use tools/securities and edit the DUMMY security and rename it to "Dividends(misc)"? The end result will be no different (in effect) to what you had before you started...?

  5. 5 Posted by Stuart Beesley ... on 12 May, 2023 09:35 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    It would be great if you could select 2 of these (one oldest and one newest) then right click and show transaction details, and then copy / paste the details back here..?

  6. 6 Posted by Tom G. on 12 May, 2023 09:36 PM

    Tom G.'s Avatar

    // Please reply above this line
    ==================================================

    From: Stuart Beesley (Mr Toolbox)

    OK... This probably means that you had dividend txns with no security assigned.. This is logically incorrect.. Toolbox has therefore added a dummy security to these.. Whereas before you would have had to go through 5000 txns and change None to the correct security, now it's easier to see which to do.. Of course, that doesn't help you.

    Tom G. - I agree, although these all came from Merrill Lynch on 5 different IRA accounts

    Questions:

    How old are these 5000 dividend txns and how did they get created? Manually? QIF import? md+ download?

    Tom G. - Most were from QIF import - I exported from SEE Finance - All of them had a security.
                  The rest since early this year when I started using MD & MD+ were from Merrill Lynch downloads. All have a security.

    Are these all for the same security? If so, you can just rename the dummy security to the correct name?

    Tom G. - No almost every security in all 5 IRA accounts. I wish, which is why I’m doing it manually.

    Are these dividends associated with a security that you manually deleted from the investment account(s) at some point?

    Tom G. - No.

    If you really don't like what toolbox has done, and if you did this today, can you not just restore the backup you would have taken?

    Hindsight is 20/20. No.

    Tom Goodhart

  7. 7 Posted by dtd on 12 May, 2023 09:42 PM

    dtd's Avatar

    just a user - I'm peripherally interested in your issue, but didn't Toolbox warn you incessantly to take a Backup, just in case? If not, I'm sure Stuart would be interested in knowing that. It would have been just one click for insurance.

  8. 8 Posted by Tom G. on 12 May, 2023 09:47 PM

    Tom G.'s Avatar

    Here is one of the “old” ones with Security Name of TOOLBOX (I changed the Name from "TOOLBOX: FIX: ….”.
    it would have been imported from the QIF file

    1) ==============
    0.acctid: ef2eb8fa-f922-435a-a721-99b8918437bd
    0.desc: Dividend: CITIGROUP INC COM NEW HOLDING 3.0000 PAY DAT
    0.id: e4887d26-05ed-4f57-9b62-697ccae4264d
    0.invest.splittype: inc
    0.obj_type:
    0.oldid: -1
    0.pamt: 135
    0.samt: -135
    1.acctid: 180bdde9-716f-46b5-8dfc-119e3bfd8b08
    1.desc: Dividend: CITIGROUP INC COM NEW HOLDING 3.0000 PAY DAT
    1.id: 7b1c9b47-bb10-494c-a399-bf58df85346c
    1.invest.splittype: sec
    1.obj_type:
    1.pamt: 0
    1.samt: 0
    1.stat: X
    _txnfile: tiksync/trunk
    acctid: cf1aac55-d35d-4be8-9f2e-1c4cfaa3ee6b
    chk: Div
    desc: Dividend: CITIGROUP INC COM NEW HOLDING 3.0000 PAY DAT
    dt: 20180824
    dtentered: 1535130000331
    id: a81b62e8-6544-4e9b-9360-91bc4288c5c0
    invest.txntype: div
    memo: Dividend: CITIGROUP INC COM NEW HOLDING 3.0000 PAY DAT
    obj_type: txn
    oldid: -1
    qif.orig-txn: D8/24'18
    NDiv
    YC
    C*
    T1.35
    MDividend: CITIGROUP INC COM NEW HOLDING 3.0000 PAY DAT

    qif_invst_action: Div
    qif_sn: 1672713858562
    rec_dt: 1673219511836
    reinvest: false
    stat: X
    td: 20180824
    ts: 1682720741955
    xfer_type: xfrtp_dividend
    ==============

    Here is a newer one download from Merrill Lynch
    ==========================
    0.acctid: ef2eb8fa-f922-435a-a721-99b8918437bd
    0.desc: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023
    0.id: 9615e03d-92d0-429d-a90e-db8711fd2148
    0.invest.splittype: inc
    0.obj_type:
    0.pamt: 21
    0.samt: -21
    1.acctid: 180bdde9-716f-46b5-8dfc-119e3bfd8b08
    1.desc: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023
    1.id: 6a00c711-b7c5-47a1-8621-9d121a2a28bd
    1.invest.splittype: sec
    1.obj_type:
    1.pamt: 0
    1.samt: 0
    1.stat: X
    acctid: cf1aac55-d35d-4be8-9f2e-1c4cfaa3ee6b
    chk:
    desc: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023
    dt: 20230329
    dtentered: 1680192855353
    id: a3a2cdaf-64d7-439f-ada5-150ee6e8b28a
    invest.txntype: div
    memo: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023 USD
    obj_type: txn
    ol.match-status: n
    ol.match-type: 0
    ol.orig-memo: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023 USD
    ol.orig-payee: INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023
    ol.orig-txn: {
      "amt" = "21"
      "dtinit-int" = "20230329"
      "dtpstd-int" = "20230329"
      "extra.invest_txn_subtype" = "dividend"
      "extra.invest_txn_type" = "fee"
      "extra.plaid_security_id" = "rJ6M41My0wFa7dj9zPm5H3exyOxkp7fJdMpnE"
      "extra.price" = "0.0"
      "extra.raw_amount" = "-21"
      "extra.raw_fees" = "0"
      "fi_id" = "mdplus:LedARy1J4PFe8xwoeZLYf0XmdOAzZLUdApmmw"
      "fitxnid" = "897YP5ykXjUNrBpZNJ6LiPNkjp7dYYtvMayZ4"
      "invest_txn_type" = "div"
      "invst.fees" = "0"
      "invst.numshares" = "0"
      "invst.securityid" = "69374H881"
      "invst.securityidtype" = "CUSIP"
      "invst.shareprice" = "0"
      "iso_curr" = "USD"
      "memo" = "INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023 USD"
      "name" = "INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023"
      "orig_data" = "com.plaid.client.response.InvestmentsTransactionsGetResponse$InvestmentTransaction@14a633cf"
    }

    ol_fi_id: mdplus:LedARy1J4PFe8xwoeZLYf0XmdOAzZLUdApmmw
    ol_fitid_1: 897YP5ykXjUNrBpZNJ6LiPNkjp7dYYtvMayZ4
    oldid: -1
    rec_asof: 20230331
    rec_dt: 1682611525458
    reinvest: false
    stat: X
    td: 20230329
    ts: 1682720803200
    xfer_type: xfrtp_dividend
    ==========================

    Tom Goodhart

  9. 9 Posted by dtd on 12 May, 2023 09:48 PM

    dtd's Avatar

    btw - Stuart's track record for satisfaction is like 99% and you can see he stays continuously interested in making sure it's 100%. Still, backups are so important "just in case". As you say, hindsight is 20/20....

    Do you take backups daily? If so, maybe you have a not too old backup in the backup area. If not, you should click that setting in preferences for the future, in general.

  10. 10 Posted by Tom G. on 12 May, 2023 09:49 PM

    Tom G.'s Avatar

    Yes, I did take a backup, I am a retired application programmer, but I did not realize what had happened till a few days later.
    By then I had lost track of which backup was which.

    Besides, I really want to straighten out these investment accounts.

    Tom Goodhart

  11. 11 Posted by Stuart Beesley ... on 12 May, 2023 09:52 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    “I agree, although these all came from Merrill Lynch on 5 different IRA accounts” - OK. So they were all set to None (no security before). In this respect all TB has done is change the illogical no security to a dummy security…

    “Most were from QIF import” - As suspected. I think somehow that QIF import loses the security connection.

    “The rest since early this year when I started using MD & MD+ were from Merrill Lynch downloads. All have a security.” - Please clarify? Do you mean all the newer ones from md+ have the correct security assigned; or are you saying that even newer md+ dividends have no security (now dummy) assigned?

    A script could probably help you as you have so many…. But depends if there’s any way to consistently identify the MD security from the transaction.

    • are you sure you do not have daily auto MD backups turned on? If so, we can restore one of those.

    Question: for the future
    - would you have preferred toolbox had done nothing, and left your 5000 dividend txns with a blank/empty/not assigned/security instead? I struggle to know what to do in this situation?

  12. 12 Posted by Tom G. on 12 May, 2023 09:54 PM

    Tom G.'s Avatar

    Backups - Every time I close MD and every time I run anything in Update mode in ToolBox.

    I have the MD backups going to an easily accessed folder. Next time I run the "Non-Hierarchial Fix” I will name the file to something easy to find.

    Tom Goodhart

  13. 13 Posted by dtd on 12 May, 2023 09:54 PM

    dtd's Avatar

    @TomG - got it. That makes sense. Just also doing an I/T type response.
    Take care - and you've got the best of the best working with you.
    Do note it is fairly late in the U.K. if he has to disappear for a few hours.

    And I will back out now and let the two of you work it out!

  14. 14 Posted by Tom G. on 13 May, 2023 01:11 AM

    Tom G.'s Avatar

    For 99% of the dividend transactions the Description and the Memo have something like "INCOME DIV Dividend: PACER US CASH COWS100 HOLDING 1.0000 PAY DATE 03/29/2023”.
    So it’s fairly easy replace “TOOLBOX” with the correct security name.

    I go the investment account Register.
    Type “TOOLBOX” in the search box
    Then scroll up to first one with TOOLBOX”
    The change the search to "PACER US CASH”
    Go thru all the transactions with TOOLBOX and change the security name to be correct.

    Every so often, I quit MD with an automatic backup. Then start over.

    Tom Goodhart

  15. 15 Posted by Stuart Beesley ... on 13 May, 2023 07:28 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Thx. So a genuine question for the future / others. Would you have preferred that toolbox did nothing to these 5000 dividend txns (and therefore left them with a null/empty security; or did as it did and set a dummy security?

    My thinking all along was that you would be no worse off, and the security can be renamed to “dividends (misc)” if you wanted to do nothing else; or in fact it would make it easier to find them and change them later (as you are doing now)?

    Lastly, if you get a new dividend txn downloaded by md+ going forward with a blank security; then BEFORE you touch it, can you send me the right click show record details output? It would be great to analyse it with you and understand why md+ is not setting a security. But it needs to stay blank to do this.

  16. System closed this discussion on 12 Aug, 2023 07:30 AM.

Comments are currently closed for this discussion. You can start a new one.

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

Recent Discussions

14 Jun, 2024 07:01 AM
14 Jun, 2024 06:26 AM
14 Jun, 2024 05:55 AM
14 Jun, 2024 02:01 AM
13 Jun, 2024 09:58 PM