[GNC] problem with a transaction involving 3 securities
Mattia Rizzolo
mattia at mapreri.org
Mon Jan 10 06:48:15 EST 2022
Hi,
I'm trying out something that until now I didn't try, and that's buying
a stock from a broker that handles FX itself "silently" at the time of
the transaction (normally for my USD purchases I use an account in USD).
I have liquidity account in EUR, and the stock is in USD.
So what I attempted is this (seen from the security register, that is in
USD):
A:Investments:BrokerA:USD:RUSG 2 358.28 716.56
A:Investments:BrokerA:Liquidity -634.14
Expenses:Fees:BrokerA 0.50
A:Investments:BrokerA:Liquidity -0.50
Trading:CURRENCY:EUR 634.14
Trading:CURRENCY:USD 716.56
Inbalance-USD 716.46
Trading:LSE:RUSG.L -2 358.28 716.46
I must add that the Trading:* slices were added automatically. I'm
pretty lost on how to balance this transation, after trying a variety of
alternatives.
My original approach was to add a bunch of Trading: slices (e.g. show
the EUR→USD,USD→RUSG.L in a total of 4 Trading: slices, basically
turning that Inbalance-USD into Trading:CURRENCY:USD), but it looks like
gnucash doesn't let me to have multiple Trading:CURRENCY:USD slices in
the same transaction.
The only way I found to make this work, is to add a "USD
liquidity" account, exchange the EUR for USD there, and from there to
buy the shares, but that would split the transactions in two making it
a bit less easy to follow what happened.
FTR, my broker shows it like this:
description fx rate change total
Buy 2 RUSG @ 358.28 USD $-716.56 $-716.56
Fees €-0.50 €xxxx
Withdrawal FX €-634.14 €xxxx
Credit FX 1.13 $716.56 $0.00
Do you have an idea on to best record this transaction in gnucash? :)
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220110/40d17fb9/attachment.sig>
More information about the gnucash-user
mailing list