[GNC] Finance::quote YahooJSON

[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 shows 401 type errors (Unauthorized) so I thought I'd add some diagnostics in case it helps anyone.

Here is a set of lines from the log I keep (security redacted):
	Found Finance::Quote version 1.59.
	* 15:30:02  WARN <gnc.price-quotes> [GncQuotesImpl::parse_one_quote()] Skipped NASDAQ:XXXXX - Finance::Quote returned fetch failure.
	Reason Error retrieving quote for XXXXX. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=XXXXX&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized)

If I try the above URL, I get what appears to be a JSON reply:
	{"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Crumb"}}}

Dooing a bit of Google-fu, I find a 1 day old comment on reddit r/GnuCash saying it's broke and a reply saying it's been turned off (no longer free) but I have not found any comment from yahoo on the subject.

Hoping for some good news (and I'm sure I'm not alone on that).

I really appreciate this great working mail list and thanks for those who devlop/fix/maintain the program.

-greg



-----Original Message-----
From: Kalpesh Patel [mailto:kalpesh.patel at usa.net] 
Sent: Thursday, April 11, 2024 7:44 AM
To: 'Geoff'; fromvendor; 'GnuCash User eMail List'
Subject: RE: [GNC] Finance::quote YahooJSON

You may want to review my personal project at https://github.com/ka-patel/dl_quotes ...

-----Original Message-----
From: Geoff <cleanoutmyshed at gmail.com> 
Sent: Thursday, April 11, 2024 7:57 AM
To: fromvendor <fromvendor at outtacyte.com>; 'GnuCash User eMail List' <gnucash-user at gnucash.org>
Subject: Re: [GNC] Finance::quote YahooJSON

 > 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) Price
(5) Currency

See attached.

Regards

Geoff
=====

On 11/04/2024 4:41 pm, fromvendor wrote:
> I've tried Advantech, Motley, and Rowe.  All failed (different, but fails for all of them).
> 
> I put in manual entries for now.  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.
> 
> Thanks all,
> -g
> 
> -----Original Message-----
> From: fromVendor at outtacyte.com
> Sent: Thursday, April 11, 2024 1:27 AM
> To: GnuCash User eMail List
> Subject: RE: [GNC] Finance::quote YahooJSON
> 
> OK, I just noticed in my log that I got bit by this.  What other source do you recommend for the nonce?  I only have 3 to get updated.
> -greg
> 
> For help with any of our services, please reach out to our Helpdesk:  
> helpdesk at outtacyte.com
> 
> OuttaCyTE / Greg's Helpdesk
> E-Mail: helpdesk at outtacyte.com
> Phone: 830-672-9068, Dial ext. 852 to reach a staff person during 
> office hours
> 
> -----Original Message-----
> From: gnucash-user 
> [mailto:gnucash-user-bounces+fromvendor=outtacyte.com at gnucash.org] On 
> Behalf Of Bruce Schuck
> Sent: Wednesday, April 10, 2024 4:26 PM
> To: GnuCash User eMail List
> Subject: Re: [GNC] Finance::quote YahooJSON
> 
> Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote:
> 
>> Did something happen to the YahooJSON module in Finance::Quote? Or 
>> perhaps more likely the Yahoo API? I get this now, using 
>> Finance::Quote version 1.59:
> 
> Unfortunately Yahoo once again made some changes with respect to the 
> API URLs. F::Q team is aware and an issue has been opened, but so far 
> no determination if it can be corrected or when. For now the best 
> suggestion is to select a different source.
> 
> Regards,
> 
> Bruce S.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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 at 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.