Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread fromvendor
Bruce, thank you for that excellent reply. Hoping the best for all the Devs. -greg -Original Message- From: Bruce Schuck [mailto:bsch...@asgard-systems.com] Sent: Thursday, April 11, 2024 9:39 PM To: gnucash-user@gnucash.org Cc: From: Terrence Branscombe; fromvendor Subject: Re: [GNC] F

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread Bruce Schuck
On 4/11/24 17:29:59 +, Greg wrote: I'm sure the Dev's are working on it, but do we have any idea what happened? My log shows 401 type errors (Unauthorized) so I thought I'd add some diagnostics in case it helps anyone. Hoping for some good news (and I'm sure I'm not alone on that). I

Re: [GNC] Import of CSV

2024-04-11 Thread David Cousens
Gyle The CSV data is likely not marked as cleared as the CSV importer can be used fro importing data from any source, including self generated while the OFX data is more likely to originate form a bank download. Cleared is not the same as reconciled. It was more relevant in the days when cheques m

Re: [GNC] Import of CSV

2024-04-11 Thread David Cousens
Gyle, The import matcher works with a number of settable parameters (Edit- >Preferences->Import. The default values of these may not be suitable for your specific cases. A problem I have encountered with one supplier is that my bank include sa unique identifier number from the vendor in the

Re: [GNC] I'm looking at installing GnuCash but has a couple of questions first

2024-04-11 Thread Robert Dew
Thanks for the pointer John. Looks like I'm going to have to learn Python to go down this route. >From what I can find with quick google searches seems to suggest that the >Flask App captures the output from GnuCash and then via Flask, Python and possibly Node.JS renders an HTML output which i

Re: [GNC] Import of CSV

2024-04-11 Thread Gyle McCollam
Thank Jean, I do and I use OFX/QFX whenever I can, but Discover doesn't support that option. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email From: gnucash-user on behalf of Jean Laroche Sent: Thurs

Re: [GNC] Import of CSV

2024-04-11 Thread Jean Laroche
I can't help you with the CSV import as I typically use ofx and am not familiar with the CSV workflow. The option to reconcile is there with the OFX import because it was added by the people who maintain and update gnucash (I worked on the ofx import myself). I'm guessing it's not on the CSV imp

[GNC] Import of CSV

2024-04-11 Thread Gyle McCollam
Back on 3/11 I sent 2 emails about issues with imports. Neither received any responses. This month when I imported the CSV file I had the following issues: 1. There were many receipts from the same vendor. It matched the 1st to an entry that was already reconciled, which to me doesn't make

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread David G. Pickett via gnucash-user
Yes, off the rails again: Found Finance::Quote version 1.59. * 23:45:21  WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:VZ - Finance::Quote returned fetch failure.Reason Error retrieving quote for VZ. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?sym

[GNC] Finance::Quote error after update?

2024-04-11 Thread Terrence Branscombe
Hello I've run into a problem with Finance::Quote (F::Q) that may or may not be appropriate to report here. Please let me know if it belongs elsewhere, as I'm an infrequent visitor to this list. I have had weekly stock price updates configured and working on my Windows 10 system for several

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread fromvendor
Kalpesh - Thank you for the link. I took a quick gander and it seems pretty nice. Have you used it since the Yahoo thing went south and did it work? Are you using the query api or scraping the window? All, I'm sure the Dev's are working on it, but do we have any idea what happened? My log

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread john
YohooWeb is a page-scraping alternative to Yahoo-json. The web URLs are a lot more stable than the REST API ones. Page format changes will break it, but one can hope that web breakage and REST breakage will happen at different times. There's one caveat, Yahoo! uses a script element for the quot

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread sunfish62--- via gnucash-user
In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can

Re: [GNC] Recording transactions (date)

2024-04-11 Thread R Losey
All true; if this problem becomes enough of an annoyance, I'm considering closing the account and opening a new one... the outstanding check would bounce should it ever be deposited. On Wed, Apr 10, 2024 at 11:26 AM Kalpesh Patel wrote: > " WOULD honor the check " -- that is the price to be pai

Re: [GNC] Split Transactions Version 5.6

2024-04-11 Thread Michael or Penny Novack
On 4/11/2024 8:38 AM, Kalpesh Patel wrote: Just to add some distinction, if you are coming from Intuit's Quicken world then its split is not same as GNC's split . If you are coming from Intuit's QuickBooks, the same as gnucash. If you are coming from Intuit's Quicken, not. QuickBooks is st

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread Kalpesh Patel
You may want to review my personal project at https://github.com/ka-patel/dl_quotes ... -Original Message- From: Geoff Sent: Thursday, April 11, 2024 7:57 AM To: fromvendor ; 'GnuCash User eMail List' Subject: Re: [GNC] Finance::quote YahooJSON > Is there a way to import data to the

Re: [GNC] Split Transactions Version 5.6

2024-04-11 Thread Kalpesh Patel
Just to add some distinction, if you are coming from Intuit's Quicken world then its split is not same as GNC's split ... the way I think is, split happens when "one" side of the transaction in double entry is broken down into multiple segments -- example: going out to a restaurant with a frien

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread Geoff
> Is there a way to import data to the price database? I could create a > CSV or the like and just update the numbers from day to day until this > gets resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) P