more fun (not) and problems with equities/securities

[Thomas Baumgart]

Jack,

On Sonntag, 23. Februar 2020 00:32:11 CET Jack wrote:

> I thought I had written about this previously, but can't find that  
> message now.   Sorry if it truly is a repeat.

In that case sorry for not responding.

> 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.

Not sure, if matched transaction was ever fully implemented for investment transactions.
It seems to me it is not. Also, I have no idea how you could end up in
the above described scenario. The only thing I could think of is some
sort of import with automatic matching as the UI clearly does not support
that.

> 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?

Right now, I guess that is the only way to solve your problem. A wishlist
item should be more generic, e.g. "Support transaction matching for
investment transactions" or so.

> 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?

This is currently possible. You have to delete all investments that are
based on the security (closing is not enough), delete all prices regarding
that security and then your are allowed to delete the security.
I just verified that with a test file.


-- 

Regards

Thomas Baumgart

https://www.signal.org/       Signal, the better WhatsApp
-------------------------------------------------------------
morphir: so much confusion :S kmake, kdemake, qmake make cmake etc.
logixoul: you forgot cmakekde :)
morphir: and bakemeacake
-------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20200223/9187facc/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20200223/9187facc/attachment-0001.sig>