[GNC] gnucash-user Digest, Vol 217, Issue 28
Steven Anter
anter.s at gmail.com
Sun Apr 11 21:43:26 EDT 2021
Version: 4.4
I just upgraded to Version: 4.4. When I create an Investment Portfolio
Report some of my securities no longer appear. How do I get all my
securities to appear in Investment Portfolio?
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Sun, Apr 11, 2021 at 10:20 AM <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Changing Currency in Price Data (John Ralls)
> 2. Trying to download Gnucash data Files (Jose A. Lorido III)
> 3. Re: asset discrepancy in change of year (John Ralls)
> 4. Re: Changing Currency in Price Data (David Carlson)
> 5. Re: Trying to download Gnucash data Files (Michael Hendry)
> 6. Re: Trying to download Gnucash data Files (Glenn Fowler)
> 7. Re: Trying to download Gnucash data Files (Jose A. Lorido III)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 11 Apr 2021 09:09:12 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Ingo Planz <planz at pantherrey.de>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Changing Currency in Price Data
> Message-ID: <C5BD4892-B9AD-4B33-B419-DB823803E9B6 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>
> > On Apr 10, 2021, at 6:25 AM, Ingo Planz <planz at pantherrey.de> wrote:
> >
> > Hi everyone,
> >
> > in my price data, the currency for one of the stocks has changed. It
> used to be in EUR, which is also the default currency and reporting
> currency. Since recently that stock price is stored in JPY.
> > I also do have the corresponding exchange rate in the price database as
> well.
> >
> > However, both the values computed for both the Accounts tab as well as
> reports (method: nearest in time) ignore the newer JPY prices and use the
> final EUR price.
> >
> > If I do delete all the EUR prices, it works as expected and computes
> values by converting the JPY prices with the exchange rate.
> >
> > Am I missing something or am I doing it wrong? Can I change the currency
> in the stock price data like this?
>
> GnuCash understands the currency in which the stock is priced to be the
> currency of the stock account's immediate parent, so you would create a
> parent account of type ASSET denominated in JPY and make that new account
> the stock account's parent.
>
> But why exactly did the stock's quote currency change? That's not a common
> occurrence.
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 11 Apr 2021 12:33:42 -0400
> From: "Jose A. Lorido III" <fhcatares at gmail.com>
> To: gnucash-user at lists.gnucash.org
> Cc: "Jose A. Lorido III" <ciscosupply at aol.com>, "Jose A Lorido, III"
> <iepco at aol.com>
> Subject: [GNC] Trying to download Gnucash data Files
> Message-ID:
> <
> CAFS927raP0HGZdXP2dsB+zei7YOp1LU21om9qhnjmTAxwr08Uw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> To whomever may be able to help,
>
> I have been using Gnucash for my business as well as my personal accounting
> on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
> unfortunately, I had not backed up any of my data for the previous 3 years.
>
> I sent my damaged HDD to SalvageData and they were able to recover a number
> of files, some of these belonging to the Gnucash program.
>
> The question would be to anyone that may be able to help me is:
>
> 1) Which files/folders contain my data files (what would be the extensions
> I should look for)?
>
> and
>
> 2) How would I go about downloading them into my new SSD drive on my
> laptop, or I could also download them to my desktop which also contains the
> Gnucash program?
>
> Any help or guidance would be greatly appreciated,
>
> Thanks,
>
> Jose
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 11 Apr 2021 09:41:48 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Andrea Borgia <andrea at borgia.bo.it>
> Cc: Gnucash <gnucash-user at gnucash.org>
> Subject: Re: [GNC] asset discrepancy in change of year
> Message-ID: <39EE5768-E70E-4CC1-897B-B6C5AB4FE663 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>
> > On Apr 11, 2021, at 5:01 AM, Andrea Borgia <andrea at borgia.bo.it> wrote:
> >
> > Il 10/04/21 20:33, John Ralls ha scritto:
> >
> >
> >> 1) No, but that's separate from trading accounts. That's the point of
> the bug report.
> >>
> >> 2) No, the trading accounts just make it obvious that you haven't
> booked the gain/loss.
> >>
> >> 3) That's back to the discussion in the bug. When you trade securities
> in a foreign currency you have *two* sources of gains/losses: The gain or
> loss realized in the foreign currency from the sale of the security and the
> gain or loss from converting the foreign currency back into your home
> currency. Study that bug and the spreadsheets that CDB-Man has attached.
> The basic point that CDB-Man (an actual accountant licensed in Canada)
> makes is that every time you touch an asset denominated in something other
> than your home currency the change must be converted back to your home
> currency and the change in home currency value booked as a gain/loss. It's
> possible, but difficult, to do this in GnuCash. Trading Accounts don't
> really help.
> >
> > So, as an "executive summary" of sorts: I can't win and even a tie is
> out of the question ;)
> >
> >
> > I'm trying to think how to handle it as simply as possible; I'll study
> the bug report because I'd like to understand it but I'd rather avoid
> complicated manual work to be carried out each time I buy or sell funds,
> because that will happen seldom enough that I'd basically have to relearn
> the whole process each time :(
> >
> >
> > Would keeping the books open, without "trading accounts", across years
> actually help? I'd still be calculating a profit / loss by closing the
> income / expense accounts, but that's all. Somehow I think this would just
> hide the problem, though.
> >
> > Alternatively, I could keep "trading accounts" enabled, see how much
> unrealized profit / loss I have for the year and factor in that when
> calculating the initial capital for the following year. That's actually the
> situation I am in right now: the discrepancy between initial capital in
> 2021 and end capital of 2020 is precisely the amount listed by the trading
> account, for both EUR and USD.
>
> The bug report documents a significant shortcoming in GnuCash's design.
> There's no simple workaround, only the manual work described in the bug
> report.
>
> Closing your book and starting a new file every year makes for additional
> work for tracking investments as you must re-create the buy transactions in
> the new file so that you can keep track of the basis and holding period.
> Aside from that there's no difference in booking realized gains/losses.
>
> You may be confusing "recognized gains" and "realized gains". A realized
> gain (or loss) is the change in value between a buy and a sell transaction.
> In contrast an unrealized gain is the change in the value of an asset that
> you still own. If you update prices in GnuCash then you can display the
> value of your assets at the latest price on the Accounts page and in
> various reports if you select "latest" as the price source. A recognized
> gain is a realized gain that you've correctly recorded with a pair of
> splits. A balance in a trading account indicates that you have unrecognized
> realized gains.
>
> Your statement about recalculating the initial capital each year suggests
> marking to market, that is creating a transaction that recognizes the
> unrealized gain at the end of the year, changing the basis of the stocks.
> That's generally required only of banks and investment companies and it has
> substantial tax consequences. You should do so only with the advice and
> guidance of a locally-licensed accountant or tax advisor.
>
> The problem described in the bug report is that even those trading account
> balances don't tell the whole story because they don't convert your USD
> realized gains to EUR and recognize the gain/loss on converting USD->EUR.
> As long as the amounts are small enough to not concern your tax authorities
> the discrepancy is somewhat academic, but if the amounts aren't small you
> should get professional advice about how to handle it.
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 11 Apr 2021 11:57:21 -0500
> From: David Carlson <david.carlson.417 at gmail.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: Ingo Planz <planz at pantherrey.de>, Gnucash Users
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Changing Currency in Price Data
> Message-ID:
> <CADYgSbnJm-J4fxjhN3B9OD23kN4SndToku_nGerDD5h=
> H7bD9Q at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Isn't it possible that a stock can be quoted in more that one currency? If
> it is traded on more than one exchange or priced privately, possibly if it
> is not traded publicly but a private price is publicly available as a few
> securities such as XDNIX (quoted on Yahoo) in the United States. I think
> GnuCash can track such cases if the user wants to track them.
>
> On Sun, Apr 11, 2021 at 11:16 AM John Ralls <jralls at ceridwen.us> wrote:
>
> >
> >
> > > On Apr 10, 2021, at 6:25 AM, Ingo Planz <planz at pantherrey.de> wrote:
> > >
> > > Hi everyone,
> > >
> > > in my price data, the currency for one of the stocks has changed. It
> > used to be in EUR, which is also the default currency and reporting
> > currency. Since recently that stock price is stored in JPY.
> > > I also do have the corresponding exchange rate in the price database as
> > well.
> > >
> > > However, both the values computed for both the Accounts tab as well as
> > reports (method: nearest in time) ignore the newer JPY prices and use the
> > final EUR price.
> > >
> > > If I do delete all the EUR prices, it works as expected and computes
> > values by converting the JPY prices with the exchange rate.
> > >
> > > Am I missing something or am I doing it wrong? Can I change the
> currency
> > in the stock price data like this?
> >
> > GnuCash understands the currency in which the stock is priced to be the
> > currency of the stock account's immediate parent, so you would create a
> > parent account of type ASSET denominated in JPY and make that new account
> > the stock account's parent.
> >
> > But why exactly did the stock's quote currency change? That's not a
> common
> > occurrence.
> >
> > Regards,
> > John Ralls
> >
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
>
>
> ------------------------------
>
> Message: 5
> Date: Sun, 11 Apr 2021 18:03:56 +0100
> From: Michael Hendry <hendry.michael at gmail.com>
> To: "Jose A. Lorido III" <fhcatares at gmail.com>
> Cc: gnucash-user at lists.gnucash.org, "Jose A. Lorido III"
> <ciscosupply at aol.com>, "Jose A Lorido, III" <iepco at aol.com>
> Subject: Re: [GNC] Trying to download Gnucash data Files
> Message-ID: <6D4D305D-F2FC-43DF-9264-498B9F73EB31 at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> > On 11 Apr 2021, at 17:33, Jose A. Lorido III <fhcatares at gmail.com>
> wrote:
> >
> > To whomever may be able to help,
> >
> > I have been using Gnucash for my business as well as my personal
> accounting
> > on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
> > unfortunately,
>
> I feel your pain, Jose!
>
> > I had not backed up any of my data for the previous 3 years.
> >
> > I sent my damaged HDD to SalvageData and they were able to recover a
> number
> > of files, some of these belonging to the Gnucash program.
> >
> > The question would be to anyone that may be able to help me is:
> >
> > 1) Which files/folders contain my data files (what would be the
> extensions
> > I should look for)?
>
> The folder you want is the folder you chose to use when you first
> installed Gnucash.
>
> By default, this will be your Documents folder, but you may have chosen to
> put your files elsewhere.
>
> The most important files are <YourBusiness>.gnucash and <Personal>.gnucash
> - whatever you have called the books you?re working on.
>
> Gnucash also makes back-ups in files like
> <YourBusiness>.gnucash.20210407161740.gnucash and maintains logs in files
> like <YourBusiness>.gnucash.20210407160520.log, which include the date and
> time in their filenames.
>
> If you can recover the current files (<YourBusiness>.gnucash, and similar)
> then you?re in luck!
>
> >
> > and
> >
> > 2) How would I go about downloading them into my new SSD drive on my
> > laptop, or I could also download them to my desktop which also contains
> the
> > Gnucash program?
>
> I suggest you put any recovered files in Documents/Accounts
> (Documents\Accounts if you?re a Windows user), make backups!, and then open
> them with Gnucash in the normal way.
>
> Good luck!
>
> Michael Hendry
>
> PS If you have created Custom Reports and saved them, they?ll be in a file
> called ?saved-reports-2.8?, stored in a folder which depends on your
> operating system
>
> ------------------------------
>
> Message: 6
> Date: Sun, 11 Apr 2021 13:01:11 -0400
> From: Glenn Fowler <gfowler1 at outlook.com>
> To: "Jose A. Lorido III" <fhcatares at gmail.com>
> Cc: gnucash-user at lists.gnucash.org, "Jose A. Lorido III"
> <ciscosupply at aol.com>, "Jose A Lorido, III" <iepco at aol.com>
> Subject: Re: [GNC] Trying to download Gnucash data Files
> Message-ID:
> <
> SJ0PR19MB444558E0D18E42C348C05F488F719 at SJ0PR19MB4445.namprd19.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="UTF-8"
>
> Try to get the .gnucash files or the backup ones which will look like
> Example.20210411125501.gnucash
>
> On Sun, Apr 11, 2021 at 12:33 PM Jose A. Lorido III <fhcatares at gmail.com>
> wrote:
>
> > To whomever may be able to help,
> >
> > I have been using Gnucash for my business as well as my personal
> accounting
> > on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
> > unfortunately, I had not backed up any of my data for the previous 3
> years.
> >
> > I sent my damaged HDD to SalvageData and they were able to recover a
> number
> > of files, some of these belonging to the Gnucash program.
> >
> > The question would be to anyone that may be able to help me is:
> >
> > 1) Which files/folders contain my data files (what would be the
> extensions
> > I should look for)?
> >
> > and
> >
> > 2) How would I go about downloading them into my new SSD drive on my
> > laptop, or I could also download them to my desktop which also contains
> the
> > Gnucash program?
> >
> > Any help or guidance would be greatly appreciated,
> >
> > Thanks,
> >
> > Jose
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 11 Apr 2021 13:17:05 -0400
> From: "Jose A. Lorido III" <fhcatares at gmail.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: GnuCash-User <gnucash-user at lists.gnucash.org>, "Jose A Lorido,
> III" <iepco at aol.com>
> Subject: Re: [GNC] Trying to download Gnucash data Files
> Message-ID:
> <CAFS927oLK6TSd4a9p0RJ5XRk+6bC3wccfk6ZTqV9D=
> jCVWjMqQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi John,
>
> Thanks for reaching out...
>
> What I meant by Desktop was that I have, apart from my laptop, a Desktop
> Computer where the Gnucash Program is also installed.
>
> I went to the link you suggested and saw that the default for data files
> are at: MyAccounts.gnucash.20140131150812.gnucash. The Folder recovered
> contains a Gnucash Folder but I cannot see any .gnucash files.
>
> I took a snippet of the recovered files from my HDD drive that was damaged
> and have attached it, and you can see that the Gnucash folder contains 2
> .dll files. Are these my data files, or could they be inside any other
> folder that was recovered?
>
> Appreciate your help,
>
> Jose
>
>
>
> On Sun, Apr 11, 2021 at 12:51 PM John Ralls <jralls at ceridwen.us> wrote:
>
> >
> >
> > > On Apr 11, 2021, at 9:33 AM, Jose A. Lorido III <fhcatares at gmail.com>
> > wrote:
> > >
> > > To whomever may be able to help,
> > >
> > > I have been using Gnucash for my business as well as my personal
> > accounting
> > > on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
> > > unfortunately, I had not backed up any of my data for the previous 3
> > years.
> > >
> > > I sent my damaged HDD to SalvageData and they were able to recover a
> > number
> > > of files, some of these belonging to the Gnucash program.
> > >
> > > The question would be to anyone that may be able to help me is:
> > >
> > > 1) Which files/folders contain my data files (what would be the
> > extensions
> > > I should look for)?
> > >
> > > and
> > >
> > > 2) How would I go about downloading them into my new SSD drive on my
> > > laptop, or I could also download them to my desktop which also contains
> > the
> > > Gnucash program?
> > >
> > > Any help or guidance would be greatly appreciated,
> >
> > 1) See https://wiki.gnucash.org/wiki/Backup.
> >
> > Your Desktop is just a folder in your user directory on the new SSD. We
> > often get complaints about clutter from users who put their GnuCash data
> > file on the desktop so we recommend putting it in dedicated folder in
> their
> > user or documents folder. Mine is cleverly named "Accounts".
> >
> > The data recovery service should give you instructions about how to
> > transfer the recovered files to your computer.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: Screenshot 2021-04-11 130926.png
> Type: image/png
> Size: 179205 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210411/fa8e77bb/attachment.png
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 217, Issue 28
> *********************************************
>
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
More information about the gnucash-user
mailing list