Re: [GNC] Revisiting Quotes (Bruce Schuck)
While I would confirm if the Python source is grabbing the normal webpage or the API calls we use(d) in F::Q, this did give me the idea to search CPAN. I found the module Yahoo::Finance which may also be a good start and possibly does the heavy lifting already. Colin, The Yahoo::Finance Perl module is based on the https://query2.finance.yahoo.com/v7/... URL. So it's currently broken. Looking at the source for the yfinance Python library, it uses a couple different Yahoo URLs including at least one instance of a https://query2.finance.yahoo.com/v10/... URL. Which means that if Yahoo blocks access to the v10 and v11 URLs, both Finance::Quote::YahooJSON and yfinance will break. It was worth a look though. As I said, extracting the data from the HTML returned from https://finance.yahoo.com/quote/AAPL?p=AAPL&.tsrc=fin-srch is doable. Just not as simple as parsing JSON. I recently created the Finance::Quote::BVB module to replace a broken module of a different name for Romanian stocks. It is a web scrape of the HTML. Thanks. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Revisiting Quotes (Bruce Schuck)
On 5/29/23 7:41 PM, Colin Arndt wrote: Thanks for all your work to keep up this past month. The latest 1.56 update fixes price retrieval within GnuCash. This means modules will need to be rewritten to parse the HTML. Doable, but not as simple as parsing JSON. There is an excellent python module ‘yfinance’ which does exactly this - scrapes price data from Yahoo!’s website. This might not be of any use because it’s written in python instead of Perl, but nonetheless wanted to make sure you’re aware of it. Colin, While I would confirm if the Python source is grabbing the normal web page or the API calls we use(d) in F::Q, this did give me the idea to search CPAN. I found the module Yahoo::Finance which may also be a good start and possibly does the heavy lifting already. Thanks a bunch for the info! Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gunzip test.gnucash fails
So I looked up the gzip/gunzip command; the -S "" option will allow it to work on any file (it basically ignores the 'suffix') Thus, you should be able to do gunzip -S "" test.gnucash On Sun, May 28, 2023 at 10:21 AM Fred Tydeman wrote: > On Sun, May 28, 2023 at 4:20 AM Ken Farley wrote: > > > Where did you get the impression that you could use gunzip to uncompress > > the files? > > > > A previous message about mass change of stock price source used gunzip > as part of that process. But, in rereading that message, I see that I > missed > that ".gz" was added to the file name. > > > > To "uncompress" the file you need to change your preferences in Gnucash > > to turn off "Compress Files", then save your file. This will make the > > file uncompressed. > > > > I expected to find that option in: File: Properties > Instead, I found it in: Edit: Preferences: General > Anyway, changing it did get me a plain text file that I could edit. > Thanks. > > After doing my mass edit of changing the security namespace, > I also did: Actions: Check & Repair: Check & Repair 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gunzip test.gnucash fails
I remember running into this problem; there is an option to tell gunzip to ignore the extension (but I don't remember it at the moment)... alternatively, you could make a copy of the gnucash file and rename it with a .gz extension instead of gnucash. On Sun, May 28, 2023 at 12:28 AM Fred Tydeman wrote: > I am trying to unzip a copy of my gnucash file with: > gunzip test.gnucash > But, I get: unknown suffix -- ignored > I am running Fedora Linux 37 and Gnucash 4.14 > > I am trying to change the name of a parent security namespace which has > many children. I had hoped that I could edit the uncompressed XML file. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Revisiting Quotes
A way to bypass Finance::Quote is to create a .csv file with price quotes and import that. It turns out that several commercial spreadsheet packages have the ability to look up stock prices and don't seem to charge extra or to limit query rates. I've tried this with Microsoft Excel, Apple Numbers and Google Sheets. The .csv file needs columns for symbol, date, namespace (as used by Gnucash's security editor) and currency. While not as convenient as updating directly in Gnucash, with a lot of stocks it can be faster than waiting for the throttling of Alphavantage. Tom T. On 5/29/23 5:31 PM, Bruce Schuck wrote: On Thu May 25, 2023 at 14:59:14 EDT R Losey wrote: From the discussion here, one would get the idea that the only two options for quotes are Alphavantage and Yahoo/JSON... don't the other options work? I seem to remember seeing a very long list of options. Most of the other modules retrieve data for non-US based securities, or specific funds such as TSP.pm for data from https://www.tsp.gov/. Fool.pm is one that probably just needs someone to spend a little time investigating why it no longer works, but it could be a viable alternative. People either forget or don't realize that companies like AlphaVantage, Yahoo, Alphabet (aka Google), and others pay for the stock market data available on their websites or through APIs. Along with what is likely a a large cost, there are license limitations on how they may make that data available to others. This would be the reason AlphaVantage has limits placed on access using the free API key, and probably why Yahoo has been blocking access to long utilized URLs/APIs. I fully expect the new URL for Yahoo in coming F::Q release 1.56 to get blocked at some point. Maybe a few months, maybe a year, but I would bet on it. This means modules will need to be rewritten to parse the HTML. Doable, but not as simple as parsing JSON. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Revisiting Quotes (Bruce Schuck)
Hi Bruce, Thanks for all your work to keep up this past month. The latest 1.56 update fixes price retrieval within GnuCash. > This means modules will need to be rewritten to parse the HTML. Doable, > but not as simple as parsing JSON. There is an excellent python module ‘yfinance’ which does exactly this - scrapes price data from Yahoo!’s website. This might not be of any use because it’s written in python instead of Perl, but nonetheless wanted to make sure you’re aware of it. https://pypi.org/project/yfinance Best, Colin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Invoice system and Deffered Income
Hi, I wonder if a simple way is that when you create an invoice, you then post it for some distant time in the future. After all, at some date in the future it should become income, it's only a question of time. . That way, when you run an income statement for year to date, I guess you will not see the income. Then when the customer pays, you unpost the invoice and then post it using the date of payment. If eventually, if the customer never pays, you could just unpost the invoice. II think that might work, but not sure if its exactly what you want. Seems too simple though. David > Hi there, > I am trying to figure out if the existing customer invoice system is > suitable for my needs. > For simplicity, let's say I have the following accounts: > > Current (Bank) > Undetermined Income (Income, for bank account transactions just > imported from the online banking) Deferred Income (Income, used at > invoice creation to track invoices that are posted and sent to the > customers but not paid yet) Income (for invoices that got paid, so the > payment actually received as a bank transaction and processed as a > payment of an invoice) Receivable (A/Receivable, for tracking > invoices) > > The problem is that I don't like to see non-paid invoice splits in the > Income Register until the invoice payment arrives to my bank account, > imported and processed as invoice payment. > > The idea is to assign an incoming imported transaction as a payment > for an invoice from the Bank account Register and change the Income > account appropriately, so the paid invoice appears in the Income > Register > > As I got from the docs, this mailing list and my experiments, there is > no way to change the Income account after the Invoice has been posted > and specifically at the payment processing step. > > Am I missing something? > > Thank you, > Sergey -Original Message- From: gnucash-user On Behalf Of gnucash-user-requ...@gnucash.org Sent: Tuesday, May 30, 2023 8:06 AM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 242, Issue 70 Send gnucash-user mailing list submissions to gnucash-user@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-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@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: Revisiting Quotes (Bruce Schuck) 2. Problem with using Python with version 5.1 (Bob Reite) 3. Re: experience using Alpha Vantage (John Layman) 4. Re: Finance::Quote Quote Throttling (John Layman) 5. Invoice system and Deffered Income (Sergey Mende) 6. Re: Problem with using Python with version 5.1 (Jon Schewe) 7. Finance-Quote 1.56 released! (Bruce Schuck) 8. Last Num Bug(s) ?? (viking...@san.rr.com) 9. Re: Finance-Quote 1.56 released! (WR D) 10. Updated: Last Num Bug(s) ?? (viking...@san.rr.com) 11. Re: Finance-Quote 1.56 released! (Bruce Schuck) 12. Re: Invoice system and Deffered Income (Vincent Dawans) -- Message: 1 Date: Mon, 29 May 2023 14:31:55 -0700 From: Bruce Schuck To: gnucash-user@gnucash.org Subject: Re: [GNC] Revisiting Quotes Message-ID: <4c6d310d-9e3b-309f-ff21-dd550cf5a...@asgard-systems.com> Content-Type: text/plain; charset=UTF-8; format=flowed On Thu May 25, 2023 at 14:59:14 EDT R Losey wrote: > From the discussion here, one would get the idea that the only two > options for quotes are Alphavantage and Yahoo/JSON... don't the other > options work? I seem to remember seeing a very long list of options. Most of the other modules retrieve data for non-US based securities, or specific funds such as TSP.pm for data from https://www.tsp.gov/. Fool.pm is one that probably just needs someone to spend a little time investigating why it no longer works, but it could be a viable alternative. People either forget or don't realize that companies like AlphaVantage, Yahoo, Alphabet (aka Google), and others pay for the stock market data available on their websites or through APIs. Along with what is likely a a large cost, there are license limitations on how they may make that data available to others. This would be the reason AlphaVantage has limits placed on access using the free API key, and probably why Yahoo has been blocking access to long utilized URLs/APIs. I fully expect the new URL for Yahoo in coming F::Q release 1.56 to get blocked at some point. Maybe a few months, maybe a year, but I would bet on it. This means modules will need to be rewritten to parse the HTML. Doable, but not as simple as parsing JSON. Bruce S. -- Message: 2 Date: Sun, 28 May 2023 12:55:29
Re: [GNC] Invoice system and Deffered Income
Dear Vincent, Thank you very much for your quite comprehensive explanation and provided references. Now I see the difference and understand why this feature is implemented this way. In regard to suggested workaround, I probably would use the idea: anyway I am using mariadb as a data storage with some extra functionality already implemented in nodejs, so I can implement these extra splits creation automation while keeping the "generic" invoices implementation functional. I am just trying to use as many existing gnucash functions as possible for the project I am presently working on. Kind regards, Sergey On Tue, May 30, 2023 at 3:05 AM Vincent Dawans wrote: > Hi Sergey: > > I think you are describing the ability to use cash accounting instead of > accrual accounting. Gnucash does not offer this by default unfortunately. > There is an old enhancement report about it > https://bugs.gnucash.org/show_bug.cgi?id=95700 and even an old wiki page > https://wiki.gnucash.org/wiki/Cash_Based_Accounting > > There is actually a not-so-bad workaround but it still requires some > manual adjustments. So it's a workaround, not an ideal solution. > > It is very similar to what you have done so far as per your description, > with the additional advice of putting all of your transitional accounts > under a single top-level account. If you want to accommodate both invoices > and bills you would have: > Pending invoices and bills (TOP LEVEL of type asset or liability) > -- Pending bills (type: liability) > Bills Payable (type: a/payable) This is the account where bills will > be posted by gnucash -- it will be selected by default because it is of > type a/payable > Deferred Expenses (type: asset) This is the account you need to use > inside bills in lieu of expense account. Ideally it should include sub > accounts matching your expense accounts needed in bills, although not > entirely necessary. > -- Pending invoices (type: asset) > Invoices Receivable (type: a/receivable) This is the account where > invoices will be posted by gnucash -- it will be selected by default > because it is of type a/receivable > Deferred Income (type: liability). This is the account you need to > use inside invoices in lieu of income accounts. Ideally it should include > sub accounts matching your income accounts needed in invoices, although not > entirely necessary. > > You can just do the Pending invoices part if you don't use the bills > feature of course. > > The reasons why this structure is useful: > - the low level accounts in that hierarchy under Pending bills and Pending > invoices should always balance each other. If they do, you will see zeros > under Pending bills and Pending invoices in the account view. If you don't > see zeros, it means your manual adjustments are wrong OR your mistakenly > used income/expense accounts (instead of deferred income/deferred expenses) > in your invoices or bills. Without that check it will be hard to detect > errors. > - by not using actual income/expense accounts they will be excluded from > the P by default. > > The BIG caveat: > - After you process each payment, you need to enter adjustments between > the Deferred Expenses and expense accounts (for bills) and Deferred Income > and income accounts (for invoices); Ideally you put the adjustments as > additional splits in the same transaction processing the payment so there > is an easy track record of it and no risk of getting the date wrong. If you > have complex invoices with a lot of items going to different > income/expenses accounts this is far from ideal of course as you have to > adjust each account. You could also just use one "deferred income" account > and one "deferred expense" account and distribute expenses and income to > the correct expense/income account in the adjustment. In that case you need > the info from somewhere else (the item description in the invoice, etc). > Hence why this is a workaround. This is the part requiring the most manual > work and the main part that would need to be automated for this feature to > be fully implemented. How much work depends on how complex your > invoices/bills are. > > Little caveats: > - You need to exclude these accounts from the balance sheet, although the > balance sheet is still balancing with them, it just shows an additional > asset balanced by an additional liability of opposite value. Not what you > want but still not unbalanced. Still best to exclude them in the report > options. It's easy because they are all under one single main account. > - You need to include these accounts in some reports such as Customer > summary for instance. Easy enough to do in report options as well. > > Now the above workaround is the heavy-duty one when you want your books to > be in cash-basis at all times. Personally, because I don't use the vendor > bill option and do have that many invoices and only need precise reporting > once a year, I just edit my unpaid invoices and push
Re: [GNC] Invoice system and Deffered Income
Hi Sergey: I think you are describing the ability to use cash accounting instead of accrual accounting. Gnucash does not offer this by default unfortunately. There is an old enhancement report about it https://bugs.gnucash.org/show_bug.cgi?id=95700 and even an old wiki page https://wiki.gnucash.org/wiki/Cash_Based_Accounting There is actually a not-so-bad workaround but it still requires some manual adjustments. So it's a workaround, not an ideal solution. It is very similar to what you have done so far as per your description, with the additional advice of putting all of your transitional accounts under a single top-level account. If you want to accommodate both invoices and bills you would have: Pending invoices and bills (TOP LEVEL of type asset or liability) -- Pending bills (type: liability) Bills Payable (type: a/payable) This is the account where bills will be posted by gnucash -- it will be selected by default because it is of type a/payable Deferred Expenses (type: asset) This is the account you need to use inside bills in lieu of expense account. Ideally it should include sub accounts matching your expense accounts needed in bills, although not entirely necessary. -- Pending invoices (type: asset) Invoices Receivable (type: a/receivable) This is the account where invoices will be posted by gnucash -- it will be selected by default because it is of type a/receivable Deferred Income (type: liability). This is the account you need to use inside invoices in lieu of income accounts. Ideally it should include sub accounts matching your income accounts needed in invoices, although not entirely necessary. You can just do the Pending invoices part if you don't use the bills feature of course. The reasons why this structure is useful: - the low level accounts in that hierarchy under Pending bills and Pending invoices should always balance each other. If they do, you will see zeros under Pending bills and Pending invoices in the account view. If you don't see zeros, it means your manual adjustments are wrong OR your mistakenly used income/expense accounts (instead of deferred income/deferred expenses) in your invoices or bills. Without that check it will be hard to detect errors. - by not using actual income/expense accounts they will be excluded from the P by default. The BIG caveat: - After you process each payment, you need to enter adjustments between the Deferred Expenses and expense accounts (for bills) and Deferred Income and income accounts (for invoices); Ideally you put the adjustments as additional splits in the same transaction processing the payment so there is an easy track record of it and no risk of getting the date wrong. If you have complex invoices with a lot of items going to different income/expenses accounts this is far from ideal of course as you have to adjust each account. You could also just use one "deferred income" account and one "deferred expense" account and distribute expenses and income to the correct expense/income account in the adjustment. In that case you need the info from somewhere else (the item description in the invoice, etc). Hence why this is a workaround. This is the part requiring the most manual work and the main part that would need to be automated for this feature to be fully implemented. How much work depends on how complex your invoices/bills are. Little caveats: - You need to exclude these accounts from the balance sheet, although the balance sheet is still balancing with them, it just shows an additional asset balanced by an additional liability of opposite value. Not what you want but still not unbalanced. Still best to exclude them in the report options. It's easy because they are all under one single main account. - You need to include these accounts in some reports such as Customer summary for instance. Easy enough to do in report options as well. Now the above workaround is the heavy-duty one when you want your books to be in cash-basis at all times. Personally, because I don't use the vendor bill option and do have that many invoices and only need precise reporting once a year, I just edit my unpaid invoices and push them to January 1st when I reach the end of the fiscal year. Not pretty but it does the job for me. But I could see that not working if you have a lot of invoices or need cash-basis reporting more often. There could also be a way to deal with this purely with reports. It would keep the registers in accrual mode as they are, not do any pending accounts and adjustments there, but then provide a cash-basis P and cash-basis Balance sheet reports that would do the adjustment. That would be the simplest way to provide at least some functionality without any manual entries. But the challenge would come from partial payments. If an invoice has several income accounts in it, and a partial payment is made, there is no way (for the computer) to tell which income account the partial payment should be applied to
Re: [GNC] Finance-Quote 1.56 released!
On 5/29/23 15:13, WR D wrote: Can I confirm ... does this take time to propagate? Depending on what CPAN mirrors are configured on your system, yes. So I am not clear if this install method will update eventually and then look for 1.56? Unless there is some other issue with your CPAN or Perl installation, you are correct? Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Updated: Last Num Bug(s) ??
I am using GnuCash v5.1 I use the "Num" field in the account register to log the transaction number (e,g, check number or other reference). I want to see the latest transaction number in the "Account Tree window". I have therefore set my "Account Tree window" to show the "Last Num" Heading. Bug1: For the last transaction in my Bank1 account I have set the "Num" field to 50. The "Last Num" Heading in the "Account Tree window" then properly shows 50. I then edit "Num" to 51. However, the "Last Num" Heading in the "Account Tree window" is not updated. It still shows 50. Bug2 (maybe not a bug?): Instead of using integers in the "Num" field, I would like to use use decimals; e.g. 4.5. However, that is not recognized in the "Last Num" Heading in the "Account Tree window". It still shows the previous integer value for the "Num" field. Bug3: For the last transaction in my Bank1 account I have set the "Num" field to 50. The "Last Num" Heading in the "Account Tree window" then properly shows 50. This transaction entered in Bank1 is a Transfer to Bank2. The transfer properly shows up in Bank2 with the last "Num" field as 50 as it should. However, the "Last Num" Heading in the "Account Tree window" for Bank2 is not updated to show 50 (It shows the previous last number directly entered in the Bank2 register). ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.56 released!
Thank you for this. Can I confirm ... does this take time to propagate? On Windows right now, if I run the "Install Online Price Retrieval for GnuCash" under my Gnucash start menu entry (which points to ""C:\Program Files (x86)\gnucash\bin\install-fq-mods.cmd") , it is still recognising version 1.55 as latest version and thus not installing anything. The message I see is ... Finance::Quote is up to date (1.55). So I am not clear if this install method will update eventually and then look for 1.56? Regards, Bill -Original Message- From: gnucash-user On Behalf Of Bruce Schuck Sent: Tuesday, 30 May 2023 7:57 AM To: finance-quote-n...@lists.sourceforge.net; gnucash-user@gnucash.org Subject: [GNC] Finance-Quote 1.56 released! New version 1.56 of Finance-Quote is available with the following changes: * Replaced Tradeville.pm with BVB.pm - Issue #269 * Added new TwelveData module * Updated YahooJSON.pm and CurrencyRates/YahooJSON.pm to use https://query2.finance.yahoo.com/v11 - PR #284 * Bourso.pm - Squash anything but numbers and period in quote values. * Renamed MStarUK.pm to MorningstarUK.pm * Added get_features method - PR #260 Authors: - Erik Colson - Paul Fenwick - Vincent Lucarelli - David Hampton - Bruce Schuck - jvolkening - Pawel Konieczny - AndreJ - Mike Alexander - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Sam Morris - Linas Vepstas - Manuel Friedli - Diego Marcolungo - John Haiducek - alex314159 - gregor herrmann - Hiranya Samarasekera - Jalon Avens - Paul Howarth - Sigve Indregard - goodvibes2 - Ben Hemming - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - Eelco Dolstra - Emmanuel Di Pretoro - Florian Schlichting - GitGord <46006740+gitg...@users.noreply.github.com> - Gustavo R. Montesino - Henrik Ahlgren - Jean-Marie Pacquet - Lance Wicks - Liviu Tinta - Martin Kompf - Pete Ratzlaff - Ross Peachey - Stephan Ebelt - linas - thinus - x42x64 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Last Num Bug(s) ??
I am using GnuCash v5.1 I use the "Num" field in the account register to log the transaction number (e,g, check number or other reference). I want to see the latest transaction number in the "Account Tree window". I have therefore set my "Account Tree window" to show the "Last Num" Heading. Bug1: For the last transaction in my Bank1 account I have set the "Num" field to 50. The "Last Num" Heading in the "Account Tree window" then properly shows 50. I then edit "Num" to 51. However, the "Last Num" Heading in the "Account Tree window" is not updated. It still shows 50. Bug2 (maybe not a bug?): Instead of using integers in the "Num" field, I would like to use use decimals; e.g. 4.5. However, that is not recognized in the "Last Num" Heading in the "Account Tree window". It still shows the previous integer value for the "Num" field. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Finance-Quote 1.56 released!
New version 1.56 of Finance-Quote is available with the following changes: * Replaced Tradeville.pm with BVB.pm - Issue #269 * Added new TwelveData module * Updated YahooJSON.pm and CurrencyRates/YahooJSON.pm to use https://query2.finance.yahoo.com/v11 - PR #284 * Bourso.pm - Squash anything but numbers and period in quote values. * Renamed MStarUK.pm to MorningstarUK.pm * Added get_features method - PR #260 Authors: - Erik Colson - Paul Fenwick - Vincent Lucarelli - David Hampton - Bruce Schuck - jvolkening - Pawel Konieczny - AndreJ - Mike Alexander - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Sam Morris - Linas Vepstas - Manuel Friedli - Diego Marcolungo - John Haiducek - alex314159 - gregor herrmann - Hiranya Samarasekera - Jalon Avens - Paul Howarth - Sigve Indregard - goodvibes2 - Ben Hemming - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - Eelco Dolstra - Emmanuel Di Pretoro - Florian Schlichting - GitGord <46006740+gitg...@users.noreply.github.com> - Gustavo R. Montesino - Henrik Ahlgren - Jean-Marie Pacquet - Lance Wicks - Liviu Tinta - Martin Kompf - Pete Ratzlaff - Ross Peachey - Stephan Ebelt - linas - thinus - x42x64 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem with using Python with version 5.1
Bob, Did you install GnuCash using Flatpak or via a deb file? Also are you certain that you're executing "python3" and not "python", which may execute python2. This is what I see on Ubuntu 22. >apt list --installed '*gnucash*' Listing... Done gnucash-common/jammy,now 1:4.8-1build2 all [installed] gnucash-docs/jammy,now 4.8-1 all [installed,automatic] gnucash/jammy,now 1:4.8-1build2 amd64 [installed,automatic] python3-gnucash/jammy,now 1:4.8-1build2 amd64 [installed] >python3 Python 3.10.6 (main, Mar 10 2023, 10:55:28) [GCC 11.3.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import gnucash >>> Note that I also have GnuCash installed via Flatpak and that's the GUI that I use. I need to figure out how to update my environment to execute python scripts against the flatpak as I expect that eventually the 4.8 libraries won't be able to read the 5.X files. Jon On Sun, 2023-05-28 at 12:55 -0400, Bob Reite wrote: > I am trying to run python scripts to import data from Quickbooks, but > I > get the following error: > > ImportError: No module named gnucash. > > Phthon3-guncash is installed. > > System is Linux Mint 20 Ulyana > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Invoice system and Deffered Income
Hi there, I am trying to figure out if the existing customer invoice system is suitable for my needs. For simplicity, let's say I have the following accounts: Current (Bank) Undetermined Income (Income, for bank account transactions just imported from the online banking) Deferred Income (Income, used at invoice creation to track invoices that are posted and sent to the customers but not paid yet) Income (for invoices that got paid, so the payment actually received as a bank transaction and processed as a payment of an invoice) Receivable (A/Receivable, for tracking invoices) The problem is that I don't like to see non-paid invoice splits in the Income Register until the invoice payment arrives to my bank account, imported and processed as invoice payment. The idea is to assign an incoming imported transaction as a payment for an invoice from the Bank account Register and change the Income account appropriately, so the paid invoice appears in the Income Register As I got from the docs, this mailing list and my experiments, there is no way to change the Income account after the Invoice has been posted and specifically at the payment processing step. Am I missing something? Thank you, Sergey ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote Quote Throttling
Where AlphaVantage is concerned, the problem for me is not the throttling. It's the missing mutual fund prices. I would consider purchasing a premium key for those. But, hey, except for want of spare time, I could develop a screen scrape of data I already have in Yahoo and get the same result for free. -Original Message- From: gnucash-user On Behalf Of Bruce Schuck Sent: Sunday, May 28, 2023 5:07 PM To: gnucash-user@gnucash.org Subject: [GNC] Finance::Quote Quote Throttling I was wondering if any GnuCash users pay for a premium key from a data source like AlphaVantage? Or would some of you be more inclined to purchase premium keys from the vendors if Finance::Quote was able to optionally by-pass its throttling mechanisms? I am gauging if the interest is enough to justify the effort although I think it is a nice feature to add at some point. Reply here or add to the F::Q discussion thread at https://github.com/finance-quote/finance-quote/discussions/274#discussioncom ment-6014874 Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] experience using Alpha Vantage
Mostly, no. I'm getting few mutual fund returns. But misses are only sporadically logged. That makes me wonder if stale quotes are being delivered. But it also makes me wonder if I've been tuned out and am unaware that a secret handshake is now needed. I don't fetch prices automatically, but typically download around 6 AM. I also run an Excel spreadsheet that fetches quotes from Refinitiv using the Stocks data type. That has its own issues as some newer mutual fund tickers aren't recognized. -Original Message- From: gnucash-user On Behalf Of David G. Pickett via gnucash-user Sent: Friday, May 26, 2023 4:42 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] experience using Alpha Vantage I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Problem with using Python with version 5.1
I am trying to run python scripts to import data from Quickbooks, but I get the following error: ImportError: No module named gnucash. Phthon3-guncash is installed. System is Linux Mint 20 Ulyana ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Revisiting Quotes
On Thu May 25, 2023 at 14:59:14 EDT R Losey wrote: From the discussion here, one would get the idea that the only two options for quotes are Alphavantage and Yahoo/JSON... don't the other options work? I seem to remember seeing a very long list of options. Most of the other modules retrieve data for non-US based securities, or specific funds such as TSP.pm for data from https://www.tsp.gov/. Fool.pm is one that probably just needs someone to spend a little time investigating why it no longer works, but it could be a viable alternative. People either forget or don't realize that companies like AlphaVantage, Yahoo, Alphabet (aka Google), and others pay for the stock market data available on their websites or through APIs. Along with what is likely a a large cost, there are license limitations on how they may make that data available to others. This would be the reason AlphaVantage has limits placed on access using the free API key, and probably why Yahoo has been blocking access to long utilized URLs/APIs. I fully expect the new URL for Yahoo in coming F::Q release 1.56 to get blocked at some point. Maybe a few months, maybe a year, but I would bet on it. This means modules will need to be rewritten to parse the HTML. Doable, but not as simple as parsing JSON. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] experience using Alpha Vantage
One theory I have that seems good is that they delay Fund pricing, perhaps because each fund firm publishes their NAVs at different times after the trading day, so the do not collect them or make them visible until much later. I finally got my Friday fund prices today, which is not a trading day because of the holiday, but to a simple computer schedule might seem a trading day, as it is Monday. -Original Message- From: David G. Pickett To: john.lay...@laymanandlayman.com ; gnucash-user@gnucash.org Sent: Sat, May 27, 2023 5:14 pm Subject: Re: [GNC] experience using Alpha Vantage It is frustrating that you can find dozens of free sites for human viewing with up to date quotes, especially for funds that change once after each trading day close (I guess if they have interest bearing securities they could fluctuate all the time as rates fluctuate, but not that I ever heard of). If we learn to mine these pages, the quote fetch overhead on the providers goes way up from them creating junk we throw away, e.g.: https://finance.yahoo.com/quote/SPY/ -Original Message- From: John Layman To: 'David G. Pickett' ; gnucash-user@gnucash.org Sent: Sat, May 27, 2023 8:09 am Subject: RE: [GNC] experience using Alpha Vantage Mostly, no. I'm getting few mutual fund returns. But misses are only sporadically logged. That makes me wonder if stale quotes are being delivered. But it also makes me wonder if I've been tuned out and am unaware that a secret handshake is now needed. I don't fetch prices automatically, but typically download around 6 AM. I also run an Excel spreadsheet that fetches quotes from Refinitiv using the Stocks data type. That has its own issues as some newer mutual fund tickers aren't recognized. -Original Message- From: gnucash-user On Behalf Of David G. Pickett via gnucash-user Sent: Friday, May 26, 2023 4:42 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] experience using Alpha Vantage I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.