I recently upgraded to ver 4.5. I am trying to produce a Investment Portfolio Report. But this report requires that the security be account type = stock or mutual fund. But when I try to edit the account, neither of these account types is available in the account type menu.
Just looking for a simple way to list all my securities with their shares amount, dollar amounts, with a total at the end. On Sun, Apr 11, 2021 at 6:45 PM <[email protected]> wrote: > Send gnucash-user mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Re: Trying to download Gnucash data Files (David Carlson) > 2. program won't load account file (Tom Murphy) > 3. Re: program won't load account file (Evelyn Yamanaka) > 4. Re: Trying to download Gnucash data Files (Jack Frillman) > 5. Re: Trying to download Gnucash data Files (Jose A. Lorido III) > 6. Re: program won't load account file (Michael or Penny Novack) > 7. Re: Trying to download Gnucash data Files (David Cousens) > 8. Scheduled Transactions (Gerald Ellis) > 9. Re: Scheduled Transactions (Stan Brown) > 10. Re: Scheduled Transactions (David Carlson) > 11. Re: Changing Currency in Price Data (Geoff) > 12. Re: gnucash-user Digest, Vol 217, Issue 28 (Steven Anter) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 11 Apr 2021 13:29:18 -0500 > From: David Carlson <[email protected]> > To: "Jose A. Lorido III" <[email protected]> > Cc: John Ralls <[email protected]>, GnuCash-User > <[email protected]>, "Jose A Lorido, III" > <[email protected]> > Subject: Re: [GNC] Trying to download Gnucash data Files > Message-ID: > <CADYgSbmaopq0io8NyG3hDg_Q0ZZ3_VjX5WT9L-= > [email protected]> > Content-Type: text/plain; charset="UTF-8" > > Jose, > > Don't worry about recovering those /dll files, they are part of the GnuCash > program that is freshly installed in your new SSD. > > On Sun, Apr 11, 2021 at 12:18 PM Jose A. Lorido III <[email protected]> > wrote: > > > 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 <[email protected]> wrote: > > > > > > > > > > > > On Apr 11, 2021, at 9:33 AM, Jose A. Lorido III <[email protected] > > > > > 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 > > > > > > > > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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: 2 > Date: Sun, 11 Apr 2021 12:04:07 -0700 > From: "Tom Murphy" <[email protected]> > To: <[email protected]> > Subject: [GNC] program won't load account file > Message-ID: <003a01d72f05$736ca180$5a45e480$@com> > Content-Type: text/plain; charset="us-ascii" > > After a recent Windows update when I open Gnucash I get an error message > that reads "No suitable background data was found for (my file > name.gnucash). I upgraded to version 4.5 but still couldn't load the file. > What could be the problem? > > > > Tom Murphy > > [email protected] > > 530-957-1949 > > > > > > ------------------------------ > > Message: 3 > Date: Sun, 11 Apr 2021 15:23:57 -0400 > From: Evelyn Yamanaka <[email protected]> > To: Tom Murphy <[email protected]> > Cc: Gnucash Users <[email protected]> > Subject: Re: [GNC] program won't load account file > Message-ID: > < > cacawaumhcjnpfpyfd3srbaj0ux5zblotjz1mousk1dmrtqc...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Looking at the code, there's no error message for "No suitable > background data found" > > Are you sure the error is not "No suitable backend found?" There have > been several reports of this error in the past. > > Perhaps one of these threads may be helpful: > > http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=search_page&node=1415818&query=No+suitable+backend&days=0 > > -E > > On Sun, Apr 11, 2021 at 3:04 PM Tom Murphy <[email protected]> wrote: > > > > After a recent Windows update when I open Gnucash I get an error message > > that reads "No suitable background data was found for (my file > > name.gnucash). I upgraded to version 4.5 but still couldn't load the > file. > > What could be the problem? > > > > > > > > Tom Murphy > > > > [email protected] > > > > 530-957-1949 > > > > > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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: 4 > Date: Sun, 11 Apr 2021 16:09:05 -0400 > From: Jack Frillman <[email protected]> > To: [email protected] > Subject: Re: [GNC] Trying to download Gnucash data Files > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8; format=flowed > > What OS are you using? > It makes a difference where you find them. > > For the down loading if your OS is Linux you can easily copy the files > to another computer using ssh.? That's what I do to back my data files > and config files from my Mac to my Linux laptop. > > On 4/11/21 12:33 PM, Jose A. Lorido III 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 > > [email protected] > > 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. > > -- > Old Unix programmers never die, they just mv to /dev/null > - Anonymous > > > > ------------------------------ > > Message: 5 > Date: Sun, 11 Apr 2021 16:27:01 -0400 > From: "Jose A. Lorido III" <[email protected]> > To: Jack Frillman <[email protected]> > Cc: [email protected] > Subject: Re: [GNC] Trying to download Gnucash data Files > Message-ID: > <CAFS927rBzSBg1yPc0XT+kOsWj1MpvzDe486r= > [email protected]> > Content-Type: text/plain; charset="UTF-8" > > Hi Jack, > > Thanks for your comments.....I am on Windows 10..... > > Jose > > > > On Sun, Apr 11, 2021 at 4:09 PM Jack Frillman via gnucash-user < > [email protected]> wrote: > > > What OS are you using? > > It makes a difference where you find them. > > > > For the down loading if your OS is Linux you can easily copy the files > > to another computer using ssh. That's what I do to back my data files > > and config files from my Mac to my Linux laptop. > > > > On 4/11/21 12:33 PM, Jose A. Lorido III 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 > > > [email protected] > > > 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. > > > > -- > > Old Unix programmers never die, they just mv to /dev/null > > - Anonymous > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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: 6 > Date: Sun, 11 Apr 2021 16:36:33 -0400 > From: Michael or Penny Novack <[email protected]> > To: [email protected] > Subject: Re: [GNC] program won't load account file > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8; format=flowed > > On 4/11/2021 3:04 PM, Tom Murphy wrote: > > After a recent Windows update when I open Gnucash I get an error message > > that reads "No suitable background data was found for (my file > > name.gnucash). I upgraded to version 4.5 but still couldn't load the > file. > > What could be the problem? > > > > > > > > Tom Murphy > > > > As one person has already suggested, are you sure you aren't slightly > misreporting the "error" message? And what exactly did you mean by a > "Windows update"? One of the minor updates MS sends out every so often? > Or change of Windows version? > > Windows (or some other OS) that allows us to open an object of type file > by clicking on it depends on an association between file type and > application. Now MS will have these set by default to its own > applications for known file types (file extensions). If you want to use > another application (say you are using LibreOffice instead of the MS > Office suite) it is up to you to change those associations for each file > type (each? file extension). Or with some other application that uses > its own type << as gnucash does >>? When an application is installed, it > might during that process create the association, but that can be lost > in an OS upgrade*. > > What version of Windows are you using? For example, if Windows 10, > settings => apps => Default apps => Choose default apps by file type??? > Go down this list and see what app is specified for file type .gnucash > << you have to make that gnucash in order for you to be able to open a > .gnucash file by clicking on it. > > But first ---- try opening gnucash and using file => open see what > happens when you select this file to open << done this way, no > association of file type with app is necessary >> > > > Michael D Novack > > * My suspicion is that MS is sometimes clearing those associations in > upgrades, substituting THEIR applications as defaults. They want you to > use THEIR products. But of course they have none for .gnucash. > > > > > ------------------------------ > > Message: 7 > Date: Sun, 11 Apr 2021 16:20:40 -0500 (CDT) > From: David Cousens <[email protected]> > To: [email protected] > Subject: Re: [GNC] Trying to download Gnucash data Files > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Jose, > > The gnucash data files are xml text files (except if you are using a > database backend). You just open the media they are on with File Explorer > and copy the required file to the desired location on your laptop hard > drive > or SSD as appropriate. If you are unable to recover the main data file > "<yourfilename>.gnucash" you can also recover from the backup files and > you have recovered backup files with the format > "yourfilename>.gnucash.<datetimestamp>.gnucash" where <datetimestamp> has > the format "yyyymmddhhmmss". If you rename the most recent of these to > "<yourfilename>.gnucash" ( make sure to keep a backup copy of it) it will > then work as the main data file. You will unfortunately lose any > transactions entered between the time of the backup file and when your hard > disk crashed. If there are any log files which have a more recent date time > stamp than the backup file you use, these can be imported into GnuCash to > recover the data but it will not necessarily be complete unless you have > all > the log files created. > > if you use both a laptop and a desktop you can either use a cloud server > like Dropbox, Google Drive, One DRive etc. which is accessible from both > machines and is automatically synced. Be careful about having the program > running on both machines at the same time. If they are networked on a LAN, > you can also use a program like Unison to keep the copies on different > machines in sync. If you do use Unison be careful not to sync any cloud > server synced folders like Dropbox etc folders which are synced externally > over the internet. Unison can be used to sync files remotely but you need a > remotely accessible URL. > > I would suggest keeping all your GnuCash data files in their own > folder/directory with a separate sub folder /directory in turn for each set > of books you maintain. That way you can backup and/or sync the complete > folder and not worry about backing up individual files. > > > > ----- > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > > ------------------------------ > > Message: 8 > Date: Sun, 11 Apr 2021 16:45:33 -0500 > From: Gerald Ellis <[email protected]> > To: [email protected] > Subject: [GNC] Scheduled Transactions > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="Windows-1252" > > I have a scheduled transaction for my weekly contribution to the > church. I make this contribution by check each week. I can not find a > way to get the scheduler to add the next available check number so I > have been adding it manually after the transaction posts. The problem > is that the system does not recognize the addition of the check number > and when I enter another check the next number is always the number of > the last check entered by the scheduler and needs to be "stepped up" to > the correct number manually. Is there some way to get the scheduler to > enter the correct check number with the transaction or to get the > number entered manually to be remembered? > > > > > ------------------------------ > > Message: 9 > Date: Sun, 11 Apr 2021 16:14:35 -0700 > From: Stan Brown <[email protected]> > To: GnuCash User List <[email protected]> > Cc: Gerald Ellis <[email protected]> > Subject: Re: [GNC] Scheduled Transactions > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > > On 2021-04-11 14:45, Gerald Ellis wrote: > > I have a scheduled transaction for my weekly contribution to the > > church. I make this contribution by check each week. I can not find a > > way to get the scheduler to add the next available check number so I > > have been adding it manually after the transaction posts. The problem > > is that the system does not recognize the addition of the check number > > and when I enter another check the next number is always the number of > > the last check entered by the scheduler and needs to be "stepped up" to > > the correct number manually. Is there some way to get the scheduler to > > enter the correct check number with the transaction or to get the > > number entered manually to be remembered? > > You can tick the "notify me when created" box in the scheduled > transaction editor. Then when the transaction fires, simply enter the > check number at that time. Remember to press the Enter key to commit the > edited transaction. > > It's not fully automated, but I think it's faster than editing the > scheduled transaction every week in the scheduled transactions editor. > > -- > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > https://OakRoadSystems.com > > > ------------------------------ > > Message: 10 > Date: Sun, 11 Apr 2021 18:48:15 -0500 > From: David Carlson <[email protected]> > To: Stan Brown <[email protected]> > Cc: GnuCash User List <[email protected]>, Gerald Ellis > <[email protected]> > Subject: Re: [GNC] Scheduled Transactions > Message-ID: > <CADYgSb=7aHa_SBiGmJ0GsU=Q7exuEt9Sw3p= > [email protected]> > Content-Type: text/plain; charset="UTF-8" > > The system check number incrementation feature may only work correctly if > the focus is in the checking account register when the number is entered. > Thus it may or may not recognize numbers that are added from the Since Last > Run assistant. I know it does not recognize numbers in the check register > if they are added from expense registers or from other asset or liability > account registers for a particular transaction. > > I frequently use the trick to include an alpha character in the number when > I want to prevent the check number from incrementing. That is the opposite > of what you want. > > If you are not in the US you may call it cheque number. That wouldn't > trick a spell checker into changing it to cheek number. > > On Sun, Apr 11, 2021 at 6:15 PM Stan Brown <[email protected]> > wrote: > > > > > On 2021-04-11 14:45, Gerald Ellis wrote: > > > I have a scheduled transaction for my weekly contribution to the > > > church. I make this contribution by check each week. I can not find a > > > way to get the scheduler to add the next available check number so I > > > have been adding it manually after the transaction posts. The problem > > > is that the system does not recognize the addition of the check number > > > and when I enter another check the next number is always the number of > > > the last check entered by the scheduler and needs to be "stepped up" to > > > the correct number manually. Is there some way to get the scheduler to > > > enter the correct check number with the transaction or to get the > > > number entered manually to be remembered? > > > > You can tick the "notify me when created" box in the scheduled > > transaction editor. Then when the transaction fires, simply enter the > > check number at that time. Remember to press the Enter key to commit the > > edited transaction. > > > > It's not fully automated, but I think it's faster than editing the > > scheduled transaction every week in the scheduled transactions editor. > > > > -- > > Stan Brown > > Tehachapi, CA, USA > > https://BrownMath.com > > https://OakRoadSystems.com > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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: 11 > Date: Mon, 12 Apr 2021 11:30:19 +1000 > From: Geoff <[email protected]> > To: David Carlson <[email protected]>, John Ralls > <[email protected]> > Cc: Gnucash Users <[email protected]>, Ingo Planz > <[email protected]> > Subject: Re: [GNC] Changing Currency in Price Data > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8; format=flowed > > Here's my 20 cents on this topic (and I am not an accountant): > > If the security changed currency, it should be treated as a corporate > event, and set up as a new security. The balance of the original > security should be set to zero, and you can twiddle the exchange rates > to record any gains or losses. It might be helpful to think of it as a > take over or buy out. > > If an underlying security is listed on multiple exchanges, or listed in > multiple currencies, again you should treat them as separate securities, > with separate price feeds. It might be helpful to think of each them as > separate derivatives (eg options etc). You can bet your bottom > dollar/euro/yen that there will be market makers sitting in front of > each of them taking a clip. > > Regards > > Geoff > ===== > > On 12/04/2021 2:57 am, David Carlson wrote: > > 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 <[email protected]> wrote: > > > >> > >> > >>> On Apr 10, 2021, at 6:25 AM, Ingo Planz <[email protected]> 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 > >> [email protected] > >> 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: 12 > Date: Sun, 11 Apr 2021 18:43:26 -0700 > From: Steven Anter <[email protected]> > To: [email protected] > Subject: Re: [GNC] gnucash-user Digest, Vol 217, Issue 28 > Message-ID: > < > cajgcfwyptiuvrixgj1kkv-rcwx82h0qogyg1nfjzbf4cgyn...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > 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 <[email protected]> wrote: > > > Send gnucash-user mailing list submissions to > > [email protected] > > > > 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 > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > 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 <[email protected]> > > To: Ingo Planz <[email protected]> > > Cc: [email protected] > > Subject: Re: [GNC] Changing Currency in Price Data > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset=us-ascii > > > > > > > > > On Apr 10, 2021, at 6:25 AM, Ingo Planz <[email protected]> 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" <[email protected]> > > To: [email protected] > > Cc: "Jose A. Lorido III" <[email protected]>, "Jose A Lorido, III" > > <[email protected]> > > Subject: [GNC] Trying to download Gnucash data Files > > Message-ID: > > < > > cafs927rap0hgzdxp2dsb+zei7yop1lu21om9qhnjmtaxwr0...@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 <[email protected]> > > To: Andrea Borgia <[email protected]> > > Cc: Gnucash <[email protected]> > > Subject: Re: [GNC] asset discrepancy in change of year > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset=us-ascii > > > > > > > > > On Apr 11, 2021, at 5:01 AM, Andrea Borgia <[email protected]> > 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 <[email protected]> > > To: John Ralls <[email protected]> > > Cc: Ingo Planz <[email protected]>, Gnucash Users > > <[email protected]> > > Subject: Re: [GNC] Changing Currency in Price Data > > Message-ID: > > <CADYgSbnJm-J4fxjhN3B9OD23kN4SndToku_nGerDD5h= > > [email protected]> > > 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 <[email protected]> wrote: > > > > > > > > > > > > On Apr 10, 2021, at 6:25 AM, Ingo Planz <[email protected]> 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 > > > [email protected] > > > 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 <[email protected]> > > To: "Jose A. Lorido III" <[email protected]> > > Cc: [email protected], "Jose A. Lorido III" > > <[email protected]>, "Jose A Lorido, III" <[email protected]> > > Subject: Re: [GNC] Trying to download Gnucash data Files > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset=utf-8 > > > > > On 11 Apr 2021, at 17:33, Jose A. Lorido III <[email protected]> > > 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 <[email protected]> > > To: "Jose A. Lorido III" <[email protected]> > > Cc: [email protected], "Jose A. Lorido III" > > <[email protected]>, "Jose A Lorido, III" <[email protected]> > > Subject: Re: [GNC] Trying to download Gnucash data Files > > Message-ID: > > < > > > sj0pr19mb444558e0d18e42c348c05f488f...@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 <[email protected] > > > > 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 > > > [email protected] > > > 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" <[email protected]> > > To: John Ralls <[email protected]> > > Cc: GnuCash-User <[email protected]>, "Jose A Lorido, > > III" <[email protected]> > > Subject: Re: [GNC] Trying to download Gnucash data Files > > Message-ID: > > <CAFS927oLK6TSd4a9p0RJ5XRk+6bC3wccfk6ZTqV9D= > > [email protected]> > > 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 <[email protected]> wrote: > > > > > > > > > > > > On Apr 11, 2021, at 9:33 AM, Jose A. Lorido III <[email protected] > > > > > 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 > > [email protected] > > 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> > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > > gnucash-user mailing list > [email protected] > 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 29 > ********************************************* > <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> _______________________________________________ gnucash-user mailing list [email protected] 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.
