[GNC] Strange display of share price

Sun Nov 10 11:32:33 EST 2024

Sorry I've just realised I replied directly to Flavio directly without
including the rest of the list. My apologies about that

Thanking you.

Regards,

Maria Inmaculada de la Torre Ruiz

On Sun, 10 Nov 2024 at 14:25, Maria Inmaculada de la Torre <
learning at 9999ways.com> wrote:

> 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/e891e708/attachment-0006.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/e891e708/attachment-0007.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/e891e708/attachment-0008.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/e891e708/attachment-0009.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/e891e708/attachment-0010.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/e891e708/attachment-0011.png>