[GNC] Strange display of share price

Mon Nov 11 04:27:15 EST 2024

Hi Inma.
I've now tried setting things up like you were explaining to: a "Trading"
account as account type "Trading" - but here the first hurdle appears.
There's no account type = "trading". I only got these to choose from:
[image: image.png]
Or maybe I didn't understand your sentence correctly *"The USD and VT
account should be accounts that need to appear under a category called
Trading under the Type Trading."*
What were you intending with that sentence?

I think John has finally explained what the root cause of my issues is: the
fact that my parent account is denominated in CHF. Therefore I will
probably have to set up some placeholder accounts denominated in different
currencies to be able to put the non-currency accounts under the USD
placeholder, together with the "USD Cash" account...

F.

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

Am So., 10. Nov. 2024 um 18:57 Uhr schrieb Maria Inmaculada de la Torre <
learning at 9999ways.com>:

> Hello Flavio,
>
> If Mutual funds accounts work as stock ones the entries you need to
> prepare are similar to the ones I have sent in the screenshots before. The
> USD and VT account should be accounts that need to appear under a category
> called Trading under the Type Trading. VT should appear under All
> non-currency and USD under the CURRENCY one. When you set up the Mutual
> Fund it asked you for a currency/security and you have that in the setup of
> the Mutual Fund. I am not sure if the parent account IBKR having a CHF
> currency might affect the issue. It might be a good idea that the parent
> account used for both the investment account and the mutual account is also
> USD. I have a few shares myself in USD but the ultimate parent account is
> in EUR (a placeholder without transactions). Just check moving them to a
> USD parent account and try to make a test transaction
> [image: image.png]
> [image: image.png]
>
> I hope this helps
> Thanking you.
>
> Regards,
>
>
> Maria Inmaculada de la Torre Ruiz
>
>
> On Sun, 10 Nov 2024 at 16: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.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am So., 10. Nov. 2024 um 15:25 Uhr schrieb Maria Inmaculada de la Torre <
>> learning at 9999ways.com>:
>>
>>> Hello Flavio,
>>>
>>> I saw the transactions in the Price Database screenshot you sent in one
>>> of your previous emails. All the transac appear in CHF. Only the ones
>>> retrieve from Finance Quote (and those will only be used for valuation
>>> purposes) appear in USD.
>>> [image: image.png]
>>> Your splits look incorrect; it is like you are not correctly using
>>> trading accounts. I am not so sure about the treatment of Mutual Funds in
>>> GnuCash but if they are similar to the treatment of Stocks you should have
>>> at least four lines in your splits, something similar to the screenshot
>>> below. So maybe you do not have the currency accounts properly set up and
>>> Gnucash is rebalancing somehow. I'd say one of the places to look as well,
>>> would be the USD Cash account with Debits and Credits leading to a nil
>>> balance. Also check if the prices are correct once you manage to sort out
>>> the first entry (once you get the first one right you should start seeing a
>>> decreasing balance in the USD Cash account). Be careful to separate the
>>> Bank account in USD from the USD account the program uses under Trading and
>>> to calculate F/X transactions)
>>>
>>> [image: image.png]
>>> I am open to corrections about the above suggested entry.
>>>
>>> I hope this helps.
>>>
>>> Regards,
>>>
>>>
>>> Inma de la Torre
>>>
>>>
>>> On Sun, 10 Nov 2024 at 14:01, Boniforti Flavio <boniforti.f at gmail.com>
>>> wrote:
>>>
>>>> Hi Inma, thanks for your reply.
>>>> In fact I've found an "Imbalance-CHF" account, but it is empty:
>>>> [image: image.png]
>>>> [image: image.png]
>>>> Where did you exactly see that I bought VT stocks in CHF?
>>>> Let me show you the split of one of my VT purchase transactions:
>>>> [image: image.png]
>>>> I don't see any reference to a CHF account - instead, as you can see, I
>>>> "took the money" from my "USD Cash" account, which I already showed to be a
>>>> bank type account in USD.
>>>> But in fact, I do have empty transaction for the above VT purchase when
>>>> I look at the "USD Cash" account:
>>>> [image: image.png]
>>>>
>>>> Thanks for helping me understand and find the issue.
>>>> F.
>>>>
>>>> https://www.instagram.com/boniforti_music
>>>> https://soundcloud.com/boniforti_music
>>>> https://bonny-j.bandcamp.com
>>>>
>>>>
>>>> Am So., 10. Nov. 2024 um 14:48 Uhr schrieb Maria Inmaculada de la Torre
>>>> <learning at 9999ways.com>:
>>>>
>>>>> Hello Flavio,
>>>>>
>>>>> In the screenshots sent I can see prices for the VT fund in CHF when
>>>>> you made transactions, but when FinanceQuote retrieves the info the prices
>>>>> appear in USD. You have been buying units in VT in CHF not in USD, that's
>>>>> why the balance in the USD account is not being affected by the
>>>>> transactions but you seem to have a blank line inserted in the original
>>>>> transactions split indicating that you were trying to enter the transaction
>>>>> in USD. So either the balance is being reduced in an account with a
>>>>> currency of CHF or the imbalance is ending up in a balancing account called
>>>>> either "Orphan-CHF" or "Imbalance-CHF" (check if you have some new account
>>>>> like that in your Chart of Accounts). Regardless, you need to open the
>>>>> splits of those transactions to see how they are rebalancing either via
>>>>> an orphan entry in CHF currency, same figures in debit and credit leading a
>>>>> nil balance in USD or to some other account in CHF currency. Select the
>>>>> transaction and click Show Splits to see what is going on there
>>>>>
>>>>> Once thing is for sure, the purchases took place in CHF not in USD as
>>>>> the prices appear in CHF in the Price register for the transactions you
>>>>> have entered manually with balances.
>>>>>
>>>>> I hope this helps
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>> Inma de la Torre
>>>>>
>>>>>
>>>>> On Sun, 10 Nov 2024 at 10:38, Boniforti Flavio <boniforti.f at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Here you go:
>>>>>> [image: image.png]
>>>>>> F.
>>>>>>
>>>>>> https://www.instagram.com/boniforti_music
>>>>>> https://soundcloud.com/boniforti_music
>>>>>> https://bonny-j.bandcamp.com
>>>>>>
>>>>>>
>>>>>> ---------- Forwarded message ---------
>>>>>> Von: Murugan Mariappan <m.muruganandam at hotmail.com>
>>>>>> Date: So., 10. Nov. 2024 um 01:41 Uhr
>>>>>> Subject: Re: [GNC] Strange display of share price
>>>>>> To: Boniforti Flavio <boniforti.f at gmail.com>
>>>>>>
>>>>>>
>>>>>> Can you please send the USD Cash account details
>>>>>>
>>>>>>
>>>>>>
>>>>>> Saludos Cordiales
>>>>>>
>>>>>>
>>>>>> Murugan
>>>>>> ------------------------------
>>>>>> *From:* Boniforti Flavio <boniforti.f at gmail.com>
>>>>>> *Sent:* 09 November 2024 13:38
>>>>>> *To:* Murugan Mariappan <m.muruganandam at hotmail.com>
>>>>>> *Cc:* GnuCash users group <gnucash-user at gnucash.org>
>>>>>> *Subject:* Re: [GNC] Strange display of share price
>>>>>>
>>>>>> Hi Murugan and thanks for your reply.
>>>>>> This is my "IBKR" account:
>>>>>> [image: image.png]
>>>>>> I moved the "USD Cash" account to "Assets:Current Assets:USD Cash" but
>>>>>> nothing changed there. I also added another "simulation" of a
>>>>>> purchase of 1
>>>>>> VT and the "USD Cash" account does not decrease.
>>>>>> What can be the cause of this?
>>>>>> A bug?
>>>>>>
>>>>>> F.
>>>>>>
>>>>>> https://www.instagram.com/boniforti_music
>>>>>> https://soundcloud.com/boniforti_music
>>>>>> https://bonny-j.bandcamp.com
>>>>>>
>>>>>>
>>>>>> Am Sa., 9. Nov. 2024 um 15:49 Uhr schrieb Murugan Mariappan <
>>>>>> m.muruganandam at hotmail.com>:
>>>>>>
>>>>>>
>>>>>>
>>>>>> To analyse send the IBKR account type as well.
>>>>>>
>>>>>> Also try to move the USD Cash account parent account to Assets and
>>>>>> see if
>>>>>> it is working
>>>>>>
>>>>>>
>>>>>>
>>>>>> Saludos Cordiales
>>>>>>
>>>>>>
>>>>>> Murugan
>>>>>> ------------------------------
>>>>>> *From:* Boniforti Flavio <boniforti.f at gmail.com>
>>>>>> *Sent:* 09 November 2024 10:59
>>>>>> *To:* Murugan Mariappan <m.muruganandam at hotmail.com>
>>>>>> *Cc:* GnuCash users group <gnucash-user at gnucash.org>
>>>>>> *Subject:* Re: [GNC] Strange display of share price
>>>>>>
>>>>>> Hi again.
>>>>>> I got an update: if I enter a transaction of 1 VT purchase and then I
>>>>>> take
>>>>>> the account "Assets:Current Assets:Checking Account" (which is in
>>>>>> CHF, type
>>>>>> "Bank"), I do see a decrease of the amount in my checking account. I
>>>>>> also
>>>>>> simulated the same transaction with my "EUR checking account" and
>>>>>> here it
>>>>>> worked correctly as well.
>>>>>> Why is this not working with the "Assets:Investments:IBKR:USD Cash"
>>>>>> account
>>>>>> (which is in USD, type "Bank")?
>>>>>>
>>>>>> F.
>>>>>>
>>>>>> https://www.instagram.com/boniforti_music
>>>>>> https://soundcloud.com/boniforti_music
>>>>>> https://bonny-j.bandcamp.com
>>>>>>
>>>>>>
>>>>>> Am Sa., 9. Nov. 2024 um 14:41 Uhr schrieb Boniforti Flavio <
>>>>>> boniforti.f at gmail.com>:
>>>>>>
>>>>>> Hi Murugan.
>>>>>> I've apparently followed the steps indicated there.
>>>>>> This is my "VT" account:
>>>>>> [image: image.png]
>>>>>>
>>>>>> I understand that "Stock" or "Mutual Fund" doesn't make a difference.
>>>>>> When I purchased VT stocks, I took the money from my
>>>>>> "Assets:Investments:IBKR:USD Cash" account, but the amount there did
>>>>>> not
>>>>>> decrease (as shown in the second picture in my initial message to the
>>>>>> list).
>>>>>>
>>>>>> Where do you think the error is?
>>>>>>
>>>>>> Thanks,
>>>>>> F.
>>>>>>
>>>>>> https://www.instagram.com/boniforti_music
>>>>>> https://soundcloud.com/boniforti_music
>>>>>> https://bonny-j.bandcamp.com
>>>>>>
>>>>>>
>>>>>> Am Mo., 4. Nov. 2024 um 20:37 Uhr schrieb Murugan Mariappan <
>>>>>> m.muruganandam at hotmail.com>:
>>>>>>
>>>>>> Please read through the user guide for setting up portfolio and adding
>>>>>> transactions
>>>>>>
>>>>>> https://gnucash.org/docs/v5/C/gnucash-guide/invest-setup1.html
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Saludos Cordiales
>>>>>>
>>>>>>
>>>>>> Murugan
>>>>>> ------------------------------
>>>>>> *From:* Boniforti Flavio <boniforti.f at gmail.com>
>>>>>> *Sent:* 04 November 2024 13:09
>>>>>> *To:* Murugan Mariappan <m.muruganandam at hotmail.com>
>>>>>> *Cc:* GnuCash users group <gnucash-user at gnucash.org>
>>>>>> *Subject:* Re: [GNC] Strange display of share price
>>>>>>
>>>>>> Hi Murugan,
>>>>>> thanks for the quick reply.
>>>>>>
>>>>>> What do you exactly mean by "are you using securities functionality"?
>>>>>> I
>>>>>> have so far just added the Finance::Quote tool and have this setup in
>>>>>> GnuCash:
>>>>>> [image: image.png]
>>>>>>
>>>>>> Thanks for your help,
>>>>>> Flavio.
>>>>>>
>>>>>> https://www.instagram.com/boniforti_music
>>>>>> https://soundcloud.com/boniforti_music
>>>>>> https://bonny-j.bandcamp.com
>>>>>>
>>>>>>
>>>>>> Am Mo., 4. Nov. 2024 um 16:47 Uhr schrieb Murugan Mariappan <
>>>>>> m.muruganandam at hotmail.com>:
>>>>>>
>>>>>> The display as fraction is for rounding and will not affect you.
>>>>>>
>>>>>> On your second query,  are you using securities functionality if so
>>>>>> send
>>>>>> more details
>>>>>>
>>>>>>
>>>>>>
>>>>>> Saludos Cordiales
>>>>>>
>>>>>>
>>>>>> Murugan
>>>>>> ------------------------------
>>>>>> *From:* gnucash-user <gnucash-user-bounces+m.muruganandam=
>>>>>> hotmail.com at gnucash.org> on behalf of Boniforti Flavio <
>>>>>> boniforti.f at gmail.com>
>>>>>> *Sent:* 04 November 2024 12:20
>>>>>> *To:* GnuCash users group <gnucash-user at gnucash.org>
>>>>>> *Subject:* [GNC] Strange display of share price
>>>>>>
>>>>>> Hi there.
>>>>>> I've been adding transactions for my VT share purchases, when
>>>>>> suddenly the
>>>>>> display of the share price changed to something like this:
>>>>>> [image: image.png]
>>>>>> What's the reason for this type of display? The first row should be
>>>>>> 116,9395, whereas the second should be 119,1200.
>>>>>> I do have some other lines above these two, and there I see the price
>>>>>> in
>>>>>> the format "116,1435".
>>>>>>
>>>>>> Then another question: I'm taking the money from my "IBKR:USD Cash"
>>>>>> account (as you can see in the first column). Now, shouldn't the
>>>>>> "IBKR:USD
>>>>>> Cash" account decrease, or am I missing something? Because the
>>>>>> corresponding line for the transactions in my "VT" account, are just
>>>>>> lines
>>>>>> with neither deposit, nor withdrawal values -->
>>>>>> [image: image.png]
>>>>>>
>>>>>> Thanks for helping me understand.
>>>>>> F.
>>>>>>
>>>>>>
>>>>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C6f8bab58f70f46fc896308dcfce47982%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638663305443814482%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=%2Bddz1LMtf6VJZjdDVVGtTsr1TMFyChWXAZEoD3SmDCQ%3D&reserved=0
>>>>>> <https://www.instagram.com/boniforti_music>
>>>>>>
>>>>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C6f8bab58f70f46fc896308dcfce47982%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638663305443839081%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=93FVaniKtnjioR9eBh9EgUxF2d8nKXDhQm%2F9DCq9hHg%3D&reserved=0
>>>>>> <https://soundcloud.com/boniforti_music>
>>>>>>
>>>>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C6f8bab58f70f46fc896308dcfce47982%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638663305443861811%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=MG4p9bqNjIlO%2B2P3VLq7y%2BzhhcrCsHOcZc%2B8svZH6Js%3D&reserved=0
>>>>>> <https://bonny-j.bandcamp.com/>
>>>>>> _______________________________________________
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> To update your subscription preferences or to unsubscribe:
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>> -----
>>>>>> Please remember to CC this list on all your replies.
>>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>>>
>>>>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 12626 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 63530 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 43149 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 41309 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 185195 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 35835 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0014.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 4226 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0015.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 92525 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0016.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 115150 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20241111/0bec8862/attachment-0017.png>