[GNC] Strange display of share price

Sun Nov 10 12:56:48 EST 2024

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/20241110/330722ee/attachment-0008.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/20241110/330722ee/attachment-0009.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/20241110/330722ee/attachment-0010.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/20241110/330722ee/attachment-0011.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/20241110/330722ee/attachment-0012.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/20241110/330722ee/attachment-0013.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/20241110/330722ee/attachment-0014.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/20241110/330722ee/attachment-0015.png>