[GNC] Strange display of share price

[Maria Inmaculada de la Torre]

Hello Flavio,

If you still have the other transactions in CHF in the VT account it is
quite likely that that could be the reason. Create a VT1 account with
the new structure and make a dummy transaction to see if that works. Also
check that you have no transactions in CHF in the IBKR account.

I hope this helps.

Regards,


Inma de la Torre


On Mon, 11 Nov 2024 at 16:08, Boniforti Flavio <boniforti.f at gmail.com>
wrote:

> 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/a23ddfea/attachment-0001.png>