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