more fun (not) and problems with equities/securities
Jack
ostroffjh at users.sourceforge.net
Sat Feb 22 23:32:11 GMT 2020
I thought I had written about this previously, but can't find that
message now. Sorry if it truly is a repeat.
I'm trying to clean up my data file, specifically looking for cases
where I created a new security instead of reusing the existing one when
creating a new equity account (for example to purchase that stock in a
different investment account.) That, plus my history of issues with
Merrill Lynch ofx imports has left me with at least one situation I
can't seem to resolve. I've written a Perl program using XML::LibXML
which finds all SECURITIES with a name containing a provided string,
then finds all stock EQUITY accounts containing those securities, and
the investment accounts which hold them.
I have a security E000387 (which actually has a misspelled fund name,
created by the original import) in equity account A000721 in investment
account A000157. If I look in the register for that investment
account, there are no transactions for that equity. If I search the
xml file directly, I find a dividend transaction T000000000000019182
with splits for A000158 (the brokerage account for A000157). A000175
(the Dividends category), and A000162 (the "corrrect" equity account
for the transaction). In that third split, there is a matched
transaction with splits for A000158 (the same brokerage account),
A000177 (the Dividends Reinvestment category) and A000721 (the mystery
equity account). I can find that transaction looking at the ledger for
category A000175, but not in the ledger for category A000177, and that
transaction does not show a matched transaction.
I'd just like to get rid of that matched transaction data - is there
any way other than by manually editing my xml file? Is there a
wishlist I should file for this?
Separately, but clearly related, is there any way to delete a Security
from the file? I would accept that a security could not be deleted if
it was the currency for any equity account. I'd prefer that any price
history was deleted along with the account, but I would accept needing
to manually delete those prices first. Is this something for another
wishlist bug?
Thanks for any suggestions.
Jack
More information about the KMyMoney-devel
mailing list