Re: [GNC] Yahoo JSON - throwing unauthorized error

-- Message: 1 Date: Mon, 8 May 2023 15:18:40 -0400 From: "John Layman" To: "'R Losey'" , "'David G. Pickett'" Cc: Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Message-ID: &

Re: [GNC] Yahoo JSON - throwing unauthorized error

To: David G. Pickett Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Others will probably report this, but Alphavantage has a built-in one minute delay for every 5 (I think 5)prices you look up; for example: 4 stocks: may take 7 seconds; 6 proces: 1 minute, 7

Re: [GNC] Yahoo JSON - throwing unauthorized error

On 5/8/23 8:56 PM, john wrote: The api docs indicate only one symbol per request. I tried https://www.alphavantage.co/query?function=GLOBAL_QUOTE=IBM=AAPL=X  and got a quote only for AAPL so it seems the implication is

Re: [GNC] Yahoo JSON - throwing unauthorized error

> On May 8, 2023, at 2:00 PM, Bruce Schuck wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 5/8/23 13:05 PM, R Losey wrote: > > > Others will probably report this, but Alphavantage has a built-in > > one minute delay for every 5 (I think 5)prices you look up; for > >

Re: [GNC] Yahoo JSON - throwing unauthorized error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 5/8/23 13:05 PM, R Losey wrote: > Others will probably report this, but Alphavantage has a built-in > one minute delay for every 5 (I think 5)prices you look up; for > example: 4 stocks: may take 7 seconds; 6 proces: 1 minute, 7 seconds; > 12

Re: [GNC] Yahoo JSON - throwing unauthorized error

This hasn't been repeated for a while, So I will add that the work-around that Bruce Schuck offered in his email Saturday, May 6 at 2:12 PM Central time (well, that's where I live) to change my $YIND_URL_HEAD = ' https://query1.finance.yahoo.com/v7/finance/quote?symbols='; to my $YIND_URL_HEAD =

Re: [GNC] Yahoo JSON - throwing unauthorized error

All good points! ⁣David T. ​ On May 8, 2023, 7:36 PM, at 7:36 PM, Bruce Schuck wrote: >On 5/8/23 13:05 +0300, David T. wrote: > >> It's a wiki, so you could put it in. You'd get to decide where that >> would best live, too. > >Perhaps sometime during the week I'll add something. With the

Re: [GNC] Yahoo JSON - throwing unauthorized error

> stamps, if desired. POGSX did not have a 5/5 quote, only 5/4 for some > reason! > > -Original Message----- > From: David G. Pickett > To: gnucash-user@gnucash.org > Sent: Sat, May 6, 2023 1:51 pm > Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error > >

Re: [GNC] Yahoo JSON - throwing unauthorized error

On 5/8/23 13:05 +0300, David T. wrote: It's a wiki, so you could put it in. You'd get to decide where that would best live, too. Perhaps sometime during the week I'll add something. With the obvious warnings about making backups and the possibility of making a mess for one's self. FWIW, my

Re: [GNC] Yahoo JSON - throwing unauthorized error

It's a wiki, so you could put it in. You'd get to decide where that would best live, too. FWIW, my method for doing this is to save the file as an SQLite file, open the result in a DB reader, locate the appropriate table there, and execute the change globally. Then I reopen the file in GnuCash

Re: [GNC] Yahoo JSON - throwing unauthorized error

If it includes sufficient warnings about working on a copy and voiding your warranty, sure. Regards, John Ralls > On May 7, 2023, at 6:02 PM, Bruce Schuck wrote: > > To the maintainers of the Wiki, would this be something perhaps helpful to > include in the section about stocks and

Re: [GNC] Yahoo JSON - throwing unauthorized error

To the maintainers of the Wiki, would this be something perhaps helpful to include in the section about stocks and commodities? I can also add 'xmlstarlet' commands as an alternative to manually editing the file. - Bruce S. On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com

Re: [GNC] Yahoo JSON - throwing unauthorized error

On 5/7/23 11:33, David G. Pickett wrote: I have previously posted my mystery regarding why I am stuck 1.5301 even after downloading and installing later versions! I went to flatpak to get later releases than the Ubuntu base. I guess I can start doing uninstall hacks using synaptics! If it

Re: [GNC] Yahoo JSON - throwing unauthorized error

- From: Bruce Schuck To: gnucash-user@gnucash.org Cc: dgpick...@aol.com Sent: Sat, May 6, 2023 9:16 pm Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error > Switching all my securities to Alphadvantage was tiresome, as the > gui was no responsive to the keyboard, but I found the

Re: [GNC] Yahoo JSON - throwing unauthorized error

ote: > > -- > > Message: 8 > Date: Sat, 6 May 2023 12:12:12 -0700 > From: Bruce Schuck <mailto:bsch...@asgard-systems.com>> > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Cc: farle...@gmail.com <mailto:farle...@gmail.co

Re: [GNC] Yahoo JSON - throwing unauthorized error

Bruce, It's okay, I'm not an expert with Perl, but have done a lot of programming. I used one of the methods proposed to extract the data I need and use it. It's not elegant code, but as with all such investigations that eventually get solved, it's so satisfying to have done it. And I

Re: [GNC] Yahoo JSON - throwing unauthorized error

Switching all my securities to Alphadvantage was tiresome, as the gui was no responsive to the keyboard, but I found the source could be found using page up. Some display at the security editor main screen or somewhere would help to see which is running quotes where, how many currently owned. I

Re: [GNC] Yahoo JSON - throwing unauthorized error

On Sat, May 6 2023 at 17:45 EDT Michael wrote: Thanks Bruce. Worked great calling the v6 version of the API. In the mean time, for those savvy enough to find and edit the YahooJSON.pm file on their system, a quick fix is to change this line: my $YIND_URL_HEAD =

Re: [GNC] Yahoo JSON - throwing unauthorized error

Thanks Bruce. Worked great calling the v6 version of the API. On Sat, May 6, 2023 at 2:13 PM Bruce Schuck wrote: > Ken, > > I am currently evaluating which of the alternatives is the best > replacement. I'm also a little hopeful that in the meantime the > functionality of the current URL/API

Re: [GNC] Yahoo JSON - throwing unauthorized error

$  I can send the strace, or make an strace, optionally with usec time stamps, if desired.  POGSX did not have a 5/5 quote, only 5/4 for some reason! -Original Message- From: David G. Pickett To: gnucash-user@gnucash.org Sent: Sat, May 6, 2023 1:51 pm Subject: Re: [GNC] Yahoo JSON - throwing unaut

Re: [GNC] Yahoo JSON - throwing unauthorized error

On 5/6/23 17:51, David G. Pickett wrote: Yeah, it's back.?? > - Is Yahoo aware of their server rejects??? - Is there some magic cookie or such we need to be authorized?? > Many previous fixes proposed, which did not seem to prevent > its return! I don't believe the APIs

Re: [GNC] Yahoo JSON - throwing unauthorized error

Ken, I am currently evaluating which of the alternatives is the best replacement. I'm also a little hopeful that in the meantime the functionality of the current URL/API is restored before the time is spent to not only make the changes, but the related housekeeping necessary before pushing

Re: [GNC] Yahoo JSON - throwing unauthorized error

Yeah, it's back.   - Is Yahoo aware of their server rejects?   - Is there some magic cookie or such we need to be authorized?  Many previous fixes proposed, which did not seem to prevent its return! ___ gnucash-user mailing list

Re: [GNC] Yahoo JSON - throwing unauthorized error

This message from the list contains links to the development bug reports for the Finance:Quote module: https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106863.html If you look at those reports, there are alternate queries discussed that could provide the data needed. They need to be

Re: [GNC] Yahoo JSON - throwing unauthorized error

Not working for me either. Was there someone that had a work-around for GnuCash? On Thu, May 4, 2023 at 6:40 PM Ken Farley wrote: > Don't know if this is going to be a periodic thing that happens, or if > it is just me, but this is going on again. Guess I'll wait a day or two > and see if it

Re: [GNC] Yahoo JSON - throwing unauthorized error

Don't know if this is going to be a periodic thing that happens, or if it is just me, but this is going on again. Guess I'll wait a day or two and see if it "recovers", unless someone feels it's only my setup that is failing... ___ gnucash-user

Re: [GNC] Yahoo JSON - throwing unauthorized error

Cordiales > > > Murugan > > > From: gnucash-user hotmail@gnucash.org> on behalf of Tom Teixeira < > tjteixe...@earthlink.net> > Sent: Thursday, April 20, 2023 9:47 AM > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Yahoo JSON - throwing unaut

Re: [GNC] Yahoo JSON - throwing unauthorized error

just checked, yahoo is back with v7 and am able to update pricing. Saludos Cordiales Murugan From: gnucash-user on behalf of Tom Teixeira Sent: Thursday, April 20, 2023 9:47 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] Yahoo JSON - throwing

Re: [GNC] Yahoo JSON - throwing unauthorized error

Other projects using Yahoo for finance quotes are running into the issue as well. https://github.com/joshuaulrich/quantmod/issues/382 is interesting because someone has developed a patch, but I don't think they are using Finance::Quotes. I'm not sure how to get this patch raised to the

Re: [GNC] Yahoo JSON - throwing unauthorized error

On Wed, 19 Apr 2023 20:37:09 Murugan Muruganandam wrote: Today when i ran get quote got the following error message Finance::Quote reported a failure for symbol acn: Error retrieving quote for acn. Attempt to fetch the URLhttps://query1.finance.yahoo.com/v7/finance/quote?symbols=acn resulted

Re: [GNC] Yahoo JSON - throwing unauthorized error

I hope they've not removed it as a free data source. That would be a shame. Michael On Wed, Apr 19, 2023 at 5:29 PM David H wrote: > Yes, I also saw the same error this morning. > > Cheers David H. > > > On Thu, 20 Apr 2023 at 06:46, Fross, Michael wrote: > >> I'm seeing the exact same

Re: [GNC] Yahoo JSON - throwing unauthorized error

Yes, I also saw the same error this morning. Cheers David H. On Thu, 20 Apr 2023 at 06:46, Fross, Michael wrote: > I'm seeing the exact same situation, Murugan. This worked yesterday so > something must have changed today. > > Switching to v6 in YahooJSON.pm fixed the issue for now, but not

Re: [GNC] Yahoo JSON - throwing unauthorized error

I'm seeing the exact same situation, Murugan. This worked yesterday so something must have changed today. Switching to v6 in YahooJSON.pm fixed the issue for now, but not a good long term solution. Michael On Wed, Apr 19, 2023 at 3:38 PM Murugan Muruganandam < m.muruganan...@hotmail.com>

[GNC] Yahoo JSON - throwing unauthorized error

Today when i ran get quote got the following error message Finance::Quote reported a failure for symbol acn: Error retrieving quote for acn. Attempt to fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=acn resulted in HTTP response 401 (Unauthorized) When i queried the