[GNC] Strange display of share price

[Boniforti Flavio]

Hi again, John.
I've now moved the "CHF Cash" account away from the "IBKR" placeholder and
put it under "Assets:Current Assets:IBKR CHF Cash" (I also renamed it).
Then I proceeded to change the "IBKR" placeholder to be using the USD
currency (I didn't change the account type, which remained "bank").
So now I do have following account structure:
[image: image.png]
I simulated buying 1 VT stock and taking the money from the "USD Cash"
account, but the transaction still wouldn't reduce the total amount of
money in the "USD Cash" account.

If it's true that a non-currency account like my "VT" is taking the
currency from the *first* parent account which has a currency set (which in
my case is "IBKR"), why is it still not working? I noticed that by creating
another VT account (let's call it "VT2") under "IBKR" and adding
transactions there, the "USD Cash" account shows the decrease. Is there a
way to have GnuCash "re-evaluate" the entered transactions, so that it
might catch up and reduce the money for each VT purchase in the "USD Cash"
account? Or do I have to manually copy everything over into "VT2" and then
get rid of VT?

TIA,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 11. Nov. 2024 um 10:28 Uhr schrieb Boniforti Flavio <
boniforti.f at gmail.com>:

> Hi John.
> Thanks - you finally identified the cause of my issue.
>
> I'll try to set up my accounts differently, so that I will have both the
> "USD Cash" and the "VT" account under a placeholder account which is
> denominated in USD.
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am So., 10. Nov. 2024 um 20:05 Uhr schrieb John Ralls <jralls at ceridwen.us
> >:
>
>> Flavio,
>>
>> Your problem is that VT’s parent is IBKR and that’s denominated in CHF.
>> GnuCash sets the currency for non-currency accounts using the first parent
>> account that’s denominated in a currency. That has a couple of
>> consequences, the most significant being that if you start a transaction in
>> the VT register it will use CHF as the transaction currency that GnuCash
>> will use to balance the transaction, so when you buy in USD you’ll have to
>> price both the USD and VT into CHF, but if you start in the USD Cash
>> account the transaction currency will be in USD and so VT will be priced in
>> USD. Those prices will be reflected in the pricedb  If you use
>> Finance::Quote GnuCash will ask it for VT prices in CHF.
>>
>> That’s not a situation GnuCash handles well. For an excruciatingly long
>> discussion see https://bugs.gnucash.org/show_bug.cgi?id=797796. One of
>> the commenters on that bug is CDB-Man, a licensed accountant in Canada. He
>> explains the formally correct way to account for investments denominated in
>> currencies other than the “book” currency.
>>
>> You’ll have less trouble if you put your non-CHF securities in sub
>> accounts denominated in the currencies they trade in, for example a
>> USD-Securities account denominated in USD for VT and recreating all of the
>> trading transactions so that they’re only in that currency. Make sure to
>> get a price for the security’s currency in CHF for the same day so you can
>> use the nearest-in-time price source to give reports the best chance of
>>  converting things to CHF correctly—note that that doesn’t mean that they
>> will. The rollup of values on the Accounts page will always be at the
>> latest prices.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>> On Nov 10, 2024, at 08:46, Boniforti Flavio <boniforti.f at gmail.com>
>> wrote:
>>
>> Hi Inma, thanks for your reply.
>> Indeed I see now where you got the "VT bought in CHF"! I now tried to buy
>> again 1 VT stock and looking at the price database, the new entry is also
>> in CHF. What does this depend on? I think this is the first thing I should
>> solve. Probably the fact that my VT purchases are registered in CHF, but
>> taken from an USD bank account, leads to them not appearing in the "USD
>> Cash" account in terms of numbers.
>>
>> Regarding the screenshot you shared with 4 entries: what accounts are
>> "USD"
>> and "VT" there? I don't have these - I do have
>> "Assets:Investments:IBKR:USD
>> Cash" and "Assets:Investments:IBKR:VT".
>>
>> Thanks again for your help,
>> F.
>>
>>
>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 125326 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/e268f995/attachment-0001.png>