Find and replace security names
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.
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
1 Posted by Stuart Beesley ... on 12 May, 2023 09:23 PM
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:
How old are these 5000 dividend txns and how did they get created? Manually? QIF import? md+ download?
Are these all for the same security? If so, you can just rename the dummy security to the correct name?
Are these dividends associated with a security that you manually deleted from the investment account(s) at some point?
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 Posted by Stuart Beesley ... on 12 May, 2023 09:24 PM
... 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 Posted by Stuart Beesley ... on 12 May, 2023 09:25 PM
feel free to email me directly:
...
4 Posted by Stuart Beesley ... on 12 May, 2023 09:33 PM
...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 Posted by Stuart Beesley ... on 12 May, 2023 09:35 PM
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 Posted by Tom G. on 12 May, 2023 09:36 PM
// 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 Posted by dtd on 12 May, 2023 09:42 PM
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 Posted by Tom G. on 12 May, 2023 09:47 PM
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 Posted by dtd on 12 May, 2023 09:48 PM
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 Posted by Tom G. on 12 May, 2023 09:49 PM
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 Posted by Stuart Beesley ... on 12 May, 2023 09:52 PM
“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.
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 Posted by Tom G. on 12 May, 2023 09:54 PM
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 Posted by dtd on 12 May, 2023 09:54 PM
@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 Posted by Tom G. on 13 May, 2023 01:11 AM
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 Posted by Stuart Beesley ... on 13 May, 2023 07:28 AM
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.
System closed this discussion on 12 Aug, 2023 07:30 AM.