Re: [GNC] pricehist: a tool to fetch historical prices
Derek, Your point is well-taken; making changes to the datafile outside of the API is Risky. That being said, the price db operates somewhat independently of a file's transactions. Adding or removing items from the price db can be done without disruption to transactions. I find it interesting to read this announcement; a number of years back, I did a very similar project in perl, which more directly reconstructed a book's commodity prices with monthly prices for all holdings past and present. I was able to rebuild my own multi year price history for a file with over a hundred different commodities using it. Whether it's still valid and still works are legitimate questions, but Chris might find it an interesting read. For everyone else: don't use my code. https://github.com/sunfish62/NewPriceHistory David T. Original Message From: Derek Atkins Sent: Thu Jul 01 09:52:35 EDT 2021 To: ch...@chrisberkhout.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC] pricehist: a tool to fetch historical prices Hi, Just note that GnuCash (and more generally, the GnuCash team) does not support modifications of the gnucash database outside of GnuCash. Doing so may break your data file, especially as it changes over time. If you're not using the GnuCash APIs to modify your data file, you "void the warranty". YMMV. -derek On Thu, July 1, 2021 9:45 am, Chris Berkhout wrote: > Hi all, > > I've written a command-line tool to fetch daily historical prices. It > currently supports 5 sources of data and will generate output in 4 > formats, > including SQL for a GnuCash database. > > https://gitlab.com/chrisberkhout/pricehist > > Fetching prices and immediately applying them to a GnuCash database is > done > as in the following examples: > > pricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | sqlite3 > Accounts.gnucashpricehist fetch ecb EUR/USD -s 2021-06-25 -o > gnucash-sql | mysql -u username -p -D databasenamepricehist fetch ecb > EUR/USD -s 2021-06-25 -o gnucash-sql | psql -U username -d > databasename -v ON_ERROR_STOP=1 > > I discuss some details of the generated SQL in the source code: > > https://gitlab.com/chrisberkhout/pricehist/-/blob/master/src/pricehist/outputs/gnucashsql.py > > As far as I am aware GnuCash's built-in price fetching is for current > prices only. The wiki documents wrapper scripts for the Finance::QuoteHist > Perl module, and the Piecash library has a Commodity.update_prices method > for fetching historical prices, but I hope that pricehist will make > fetching historical prices easy for GnuCash users who don't want to write > their own code for it. > > If pricehist might be useful for you please try it and let me know what > you > think. I'm still improving error handling and some other things but the > main functionality is done. > > Cheers, > Chris > ___ > gnucash-user mailing list > gnucash-user@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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] GNUCash 4.6 for Ubuntu 20.04 LTS
> On Jul 1, 2021, at 6:05 AM, David G. Pickett via gnucash-user > wrote: > > Bug: Entering price on price database - add, prices auto round to to places ! > Securities - edit says it is trades in 1/1000. Cannot find a setting to > control this. https://bugs.gnucash.org/show_bug.cgi?id=798219 Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Finance Quote Not working on MacBook Air M1 chip
OK. I suspect that it's because GnuCash is running under Rosetta2 and that forces the Intel perl. Try following the instructions in https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ to create a Terminal instance that runs under Rosetta2 and use that to run gnc-fq-update. Regards, John Ralls > On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: > > Hallo John - Many Thanks for your response. > > I ran the GUI from the terminal command prompt as you have suggested - > however, the problem remains the same - the application does not “get” / > “find” Finance::Quote. > > Regards, > Kamlesh > > Regards, > Kamlesh > >> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur
> On Jun 28, 2021, at 11:52 PM, Anita Graves wrote: > > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I need to work with, > or any of the other files in the history list. This all happened to me when > I installed GC 4.6. Before I was using 4.1. Now, when I try to import a log > file it gives the same screen. Then GC crashes! > > I am afraid to wipe all my history and all my work! > > Thanks for your help and suggestions. Your screenshot didn't make it onto the list, but if GnuCash is asking if you want to delete a file from the history list that means that it can't find the file. You'll want to investigate why that is, but rest assured that GnuCash isn't offering to delete the file, just to remove it from the history list. For the crash, please open a bug and attach the crash report from Console. You can find instructions for finding the crash report at https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did leading up to the crash in the bug description. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] pricehist: a tool to fetch historical prices
Hi, Just note that GnuCash (and more generally, the GnuCash team) does not support modifications of the gnucash database outside of GnuCash. Doing so may break your data file, especially as it changes over time. If you're not using the GnuCash APIs to modify your data file, you "void the warranty". YMMV. -derek On Thu, July 1, 2021 9:45 am, Chris Berkhout wrote: > Hi all, > > I've written a command-line tool to fetch daily historical prices. It > currently supports 5 sources of data and will generate output in 4 > formats, > including SQL for a GnuCash database. > > https://gitlab.com/chrisberkhout/pricehist > > Fetching prices and immediately applying them to a GnuCash database is > done > as in the following examples: > > pricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | sqlite3 > Accounts.gnucashpricehist fetch ecb EUR/USD -s 2021-06-25 -o > gnucash-sql | mysql -u username -p -D databasenamepricehist fetch ecb > EUR/USD -s 2021-06-25 -o gnucash-sql | psql -U username -d > databasename -v ON_ERROR_STOP=1 > > I discuss some details of the generated SQL in the source code: > > https://gitlab.com/chrisberkhout/pricehist/-/blob/master/src/pricehist/outputs/gnucashsql.py > > As far as I am aware GnuCash's built-in price fetching is for current > prices only. The wiki documents wrapper scripts for the Finance::QuoteHist > Perl module, and the Piecash library has a Commodity.update_prices method > for fetching historical prices, but I hope that pricehist will make > fetching historical prices easy for GnuCash users who don't want to write > their own code for it. > > If pricehist might be useful for you please try it and let me know what > you > think. I'm still improving error handling and some other things but the > main functionality is done. > > Cheers, > Chris > ___ > gnucash-user mailing list > gnucash-user@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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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.
[GNC] pricehist: a tool to fetch historical prices
Hi all, I've written a command-line tool to fetch daily historical prices. It currently supports 5 sources of data and will generate output in 4 formats, including SQL for a GnuCash database. https://gitlab.com/chrisberkhout/pricehist Fetching prices and immediately applying them to a GnuCash database is done as in the following examples: pricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | sqlite3 Accounts.gnucashpricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | mysql -u username -p -D databasenamepricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | psql -U username -d databasename -v ON_ERROR_STOP=1 I discuss some details of the generated SQL in the source code: https://gitlab.com/chrisberkhout/pricehist/-/blob/master/src/pricehist/outputs/gnucashsql.py As far as I am aware GnuCash's built-in price fetching is for current prices only. The wiki documents wrapper scripts for the Finance::QuoteHist Perl module, and the Piecash library has a Commodity.update_prices method for fetching historical prices, but I hope that pricehist will make fetching historical prices easy for GnuCash users who don't want to write their own code for it. If pricehist might be useful for you please try it and let me know what you think. I'm still improving error handling and some other things but the main functionality is done. Cheers, Chris ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] split transaction
Hi, There are multiple ways to fix this. 1) Let the system auto-complete and then Right-Click -> Delete Splits 2) Let the system auto-complete and then manually remove the additional splits. 3) Try to convince the system not to autocomplete (usually this can be done by adding an extra space at the end of the description, tabbing out, filling in the transfer account and amount, then backing up to the description and removing that space. Which option you use is up to you, they all work. -derek On Thu, July 1, 2021 8:56 am, Billie-Internet wrote: > I have entered a split transaction and now I can't enter a one line, not > split transaction for the same vendor. > > [image: image.png] > > Help. > > Billie > 706-383-9057 > ___ > gnucash-user mailing list > gnucash-user@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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] GNUCash 4.6 for Ubuntu 20.04 LTS
Bug: Entering price on price database - add, prices auto round to to places ! Securities - edit says it is trades in 1/1000. Cannot find a setting to control this. -Original Message- From: David G. Pickett To: gnucash-user@gnucash.org Sent: Tue, Jun 29, 2021 3:42 pm Subject: GNUCash 4.6 for Ubuntu 20.04 LTS I got so envious of gnucash 4.6 users that I used flatpak to install it on Ubuntu 20.04 LTS (the current LTS). The procedure to run it is a bit odd but I followed the product specific bits of the online instructions. https://wiki.gnucash.org/wiki/Flatpak It did not tell me what it was going t install! After Install it seems to work, some settings seemed to be lost or ignored as it asked me if I wanted to auto save, which had been turned on -- the usual install forgets stuff problem! I does complain on the way up, but I am not sure what is not working: dgp@dgp-p6803w:~$ flatpak run org.gnucash.GnuCash --versionGtk-Message: 15:26:12.233: Failed to load module "canberra-gtk-module"Gtk-Message: 15:26:12.238: Failed to load module "canberra-gtk-module"GnuCash 4.6Build ID: Flathub 4.6-0dgp@dgp-p6803w:~$ flatpak run org.gnucash.GnuCashGtk-Message: 15:26:22.685: Failed to load module "canberra-gtk-module"Gtk-Message: 15:26:22.688: Failed to load module "canberra-gtk-module"Found Finance::Quote version 1.49. ___ gnucash-user mailing list gnucash-user@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.
[GNC] split transaction
I have entered a split transaction and now I can't enter a one line, not split transaction for the same vendor. [image: image.png] Help. Billie 706-383-9057 ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Preferences reset problem?
Op donderdag 1 juli 2021 05:19:58 CEST schreef John Ralls: > > On Jun 30, 2021, at 2:52 AM, Geert Janssens > > wrote:> > > Op dinsdag 29 juni 2021 22:22:36 CEST schreef incoming-gnuc...@sabot.com: > >> After gnucash 4.5 was announced, I tested upgrading to it on a > >> standalone test machine (running flatpak on ubuntu 20.04), and > >> > >> I encountered the issue later described here: > >> https://bugs.gnucash.org/show_bug.cgi?id=798194 > >> > >> where all my gnucash settings were lost. On that same test machine, I > >> tried downgrading to 4.4, but my settings were still gone. This > >> seemed kind of scary, so I put off upgrading my real machine pending a > >> fix. > >> > >> I see that the bug report linked to above includes some manual > >> migration steps to export/re-import settings as a workaround, so I > >> plan to just go ahead and try that (and I will go direct from 4.4 to > >> 4.6, skipping 4.5). But I thought I'd check in to make sure that > >> there was no other pending/better way or automatic approach to this, > >> or is the manual workaround the way to go? > > > > So far there's no better workaround. You can either manually set your > > preferences again or use the command provided in the bug report. > > > > The short version of the issue is that a flatpak install of gnucash is as > > if you install gnucash on a different machine, completely isolated from > > your normal environment. There used to be a convenience to share > > preferences between your normal environment and that "virtual" flatpak > > machine. That convenience was dropped recently by the flatpak developers > > (well, the gnome runtime developers really). Instead they provide a means > > to automatically import settings from your main environment to the > > flatpak "virtual" machine, but for historical reasons this can't work > > with gnucash. So as for the convenience of having your preferences > > magically available in the flatpak environment we're stuck between a rock > > and a hard place unfortunately.> > >> If this issue affects all flatpak users, perhaps the release notes > >> should reference the preferences issue and describe or link to the > >> appropriate workaround? > > > > That's a reasonable idea. I hope someone will do so. > > Geert, > > Can you elaborate on the historical reasons on > https://github.com/flathub/org.gnucash.GnuCash/pull/43? > > Regards, > John Ralls Did so now. Geert ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Apparent slow down with GnuCash 4.6
On Thursday, July 1st, 2021 at 18:49, Tim Hume wrote: > Has anyone notice an apparent slow down when doing operations such as > changing the date of a transaction? I think the answer to my question is that I had to use the -DCMAKE_BUILD_TYPE=Release option with cmake. The web site said this was the default, but it didn't seem to be. Turning this option on sets -O3 C compiler flags. My initial run after compiling with this option seems "snappier". Are there any other optimisation options when compiling? ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur
> On 29 Jun 2021, at 07:52, Anita Graves wrote: > > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I need to work with, > or any of the other files in the history list. This all happened to me when > I installed GC 4.6. Before I was using 4.1. Now, when I try to import a log > file it gives the same screen. Then GC crashes! > > I am afraid to wipe all my history and all my work! > > Thanks for your help and suggestions. > > Anita That’s disappointing, to say the least! I’m shortly going to be forced to use Big Sur when I upgrade my elderly iMac, and have confirmed through a friend who has a more recent iMac version with Big Sur, that he can install and run 4.6 without difficulty - but of course this was a clean installation with no data files, history, etc. Unfortunately, your screenshot didn’t survive the journey to my inbox, so I can’t see the warning you received. IIUC, the history list is there for convenience only, and if you allow it to be deleted you can still open your accounts by using File=>Open and then choosing the book you want - you have to do this anyway, if you are managing more than the maximum number of books the history list can handle (4 by default, max 6). I hope you have all your important files backed up - easy to do if you use Time Machine on your Mac, but you might also want to copy everything you need into a local directory. I don’t think I’ve ever imported a log file, except perhaps as a what-does-this-do? experiment. Did something go wrong before you did this? Best of luck! Michael ___ gnucash-user mailing list gnucash-user@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.
[GNC] Apparent slow down with GnuCash 4.6
Hi, Firstly, thanks to the developers for the new release. I'm on Fedora, so compiled 4.6 from source rather than waiting for it to get into the dnf system. Compilation was fairly straight forward, and I've been putting the new release to moderately heavy use for the last couple of days. So far nothing has broken on me. In a few days I'll be doing a big import of CSV transactions, so I'm curious to see if the crashing I previously experienced has been fixed (it felt like a memory leak, and I saw many memory leaks had been fixed). Has anyone notice an apparent slow down when doing operations such as changing the date of a transaction? It could be just psychological, but I get the feeling I have to wait longer from when I push the "+" key to move the transaction date forward by a day than what I used to have to wait. Or it could be that my database has just become too big. Here in Australia we've just started the new financial year, so I might need to "close" the books and start a new database - my current one is becoming too unwieldy. But I'd really prefer to keep the current database file going - it's much easier than having to go through the palaver of starting up a new file. Regards, Tim Hume Sent with ProtonMail Secure Email. ___ gnucash-user mailing list gnucash-user@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.
