Re: [GNC] Revisiting Quotes (Bruce Schuck)

2023-05-29 Thread 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

Re: [GNC] Revisiting Quotes (Bruce Schuck)

2023-05-29 Thread 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

Re: [GNC] gunzip test.gnucash fails

2023-05-29 Thread R Losey
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

Re: [GNC] gunzip test.gnucash fails

2023-05-29 Thread R Losey
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

Re: [GNC] Revisiting Quotes

2023-05-29 Thread Tom Teixeira
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

Re: [GNC] Revisiting Quotes (Bruce Schuck)

2023-05-29 Thread Colin Arndt
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

[GNC] Invoice system and Deffered Income

2023-05-29 Thread davidvernonlong
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

Re: [GNC] Invoice system and Deffered Income

2023-05-29 Thread Sergey Mende
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

Re: [GNC] Invoice system and Deffered Income

2023-05-29 Thread Vincent Dawans
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

Re: [GNC] Finance-Quote 1.56 released!

2023-05-29 Thread Bruce Schuck
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

[GNC] Updated: Last Num Bug(s) ??

2023-05-29 Thread viking2ev
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.

Re: [GNC] Finance-Quote 1.56 released!

2023-05-29 Thread WR D
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

[GNC] Last Num Bug(s) ??

2023-05-29 Thread viking2ev
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.

[GNC] Finance-Quote 1.56 released!

2023-05-29 Thread Bruce Schuck
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 *

Re: [GNC] Problem with using Python with version 5.1

2023-05-29 Thread Jon Schewe
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

[GNC] Invoice system and Deffered Income

2023-05-29 Thread Sergey Mende
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,

Re: [GNC] Finance::Quote Quote Throttling

2023-05-29 Thread John Layman
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

Re: [GNC] experience using Alpha Vantage

2023-05-29 Thread John Layman
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,

[GNC] Problem with using Python with version 5.1

2023-05-29 Thread Bob Reite
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

Re: [GNC] Revisiting Quotes

2023-05-29 Thread Bruce Schuck
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

Re: [GNC] experience using Alpha Vantage

2023-05-29 Thread David G. Pickett via gnucash-user
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