On 2020.02.23 03:08, Thomas Baumgart wrote:
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.
Not a problem. I think I have finally cleaned up all of this mess.
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.
It is possible I did the initial import (which imports as a Dividend)
and then edited that to be a Dividend Reinvestment. I may then have
repeated the import, and manually matched the two transactions. If the
system doesn't intentionally handle matched investment transactions,
then it makes sense that is doesn't even look for them to display that
they need accepting. Just another task for the eventualy major update
to investment handling.
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.
I have successfully removed the KEYPAIR entries for that match.
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.
Two points here. First, it turns out you do not have to remove all
price pairs first. If there are any prices, when you try to delete the
security, it gives a pop-up warning that all prices for it will also be
deleted. Next, I was confused because I was right clicking on the
security, and getting no context menu. The Edit and Delete buttons are
on the side. I'll file a separate wishlist for adding the context menu
for the same actions.
I'm also going to file another wishlist: I have had several cases where
after transferring all shares of a stock from one investment account to
another, the shares were converted from Class C to Class A. I record
this by using "Remove shares" and "Add shares." However, I then get a
warning on saving (or Consistency Check) that there is no price on or
before the opening date of the Class A security. I'd like there to be
a warning pop-up whenever shares are added to an investment account if
there is no currently valid price for that security. Low priority, but
it will safe wondering later on why the Consistency check gives that
warning.
Jack
