[GNC] Yahoo JSON - throwing unauthorized error

Tue May 9 16:40:10 EDT 2023

In case someone doesn't like yahoo_json (don't have to wait until their
releases are synched up on all CDN servers and prime time ready) and
Alphavantage (beat the throttling wait) ... the python way. Working on
multi-threaded one to make it faster ...

https://github.com/ka-patel/dl_quotes

----------------------------------------------------------------------

Message: 1
Date: Mon, 8 May 2023 15:18:40 -0400
From: "John Layman" <john.layman at laymanandlayman.com>
To: "'R Losey'" <rlosey at gmail.com>,	"'David G. Pickett'"
	<dgpickett at aol.com>
Cc: <gnucash-user at gnucash.org>
Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error
Message-ID: <000001d981e1$e67c22a0$b37467e0$@laymanandlayman.com>
Content-Type: text/plain;	charset="utf-8"

I used to get prices from Alphavantage but switched to Yahoo JSON somewhere
along the line.  My recent switch back to Alphavantage was a failure until I
brought F::Q up to date.  It's slow for the 40 quotes I routinely fetch, but
I think I need to re-acclimate to the slowness.  It appears to me that Yahoo
has intended all along to fully monetize their service and the loopholes are
just oversight on their part.  So I am giving up on Yahoo as a source.

I do however daily download prices into Excel using the new financial market
information data type of Microsoft 365.  It's just a trial, and I am
invested in a rather new American bond fund whose ticker goes unrecognized,
but it might ultimately provide a means of putting together an alternative
method of importing quotes.

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+john.layman=ieee.org at gnucash.org>
On Behalf Of R Losey
Sent: Monday, May 8, 2023 2:06 PM
To: David G. Pickett <dgpickett at aol.com>
Cc: gnucash-user at 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 seconds; 12 prices: 2
minutes, 10 seconds...

I am talking about the free version of Alphavantage, but the way.

On Sat, May 6, 2023 at 3:08?PM David G. Pickett via gnucash-user <
gnucash-user at gnucash.org> wrote:

> PS: I give up on Yahoo!
> 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 have many stocks not currently owned, and so they should not be quoted.
> I got more info out of an strace.  Having the security editor sort each
> list might be much nicer, too.   Ditto for the portfolio report.  Most
> reports in this world sort left to right, for some silly reason.
>
> Now it is so slow, and while some work, it locks up on some security.
> Maybe it needs a timeout error?  I resolves the host name over and over.
> Eventually only perl is running, and then nothing.  It takes a long 
> time just to get to "Found Finance::Quote version 1.5301."  I ran an 
> strace on the batch quotes, found a few stocks still on Yahoo by 
> accident (but yahoo was at least not hanging), reran, still running, 
> showing occasional activity, but really slow, so slow I was sure it 
> was dead, but no!  I can send the strace if it would help!  The yahoo 
> when working ran all my stocks in a few seconds.  OK for midnight 
> crontab but for the get quotes button is too slow.
> dgp at dgp-p6803w:~$ time trussx flatpak run --command=gnucash-cli 
> org.gnucash.GnuCash --quotes get -- 
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2>tmp/quote.trFound 
> Finance::Quote version 1.5301.
> real    6m3.619suser    0m5.033ssys     0m12.509sdgp at dgp-p6803w:~$ time
> flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- 
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucashFound Finance::Quote version
> 1.5301.  real    5m15.338suser    0m0.056ssys     0m0.025sdgp at dgp-p6803w
> :~$
> 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 <dgpickett at aol.com>
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Sent: Sat, May 6, 2023 1:51 pm
> Subject: 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
> 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.
>

--
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8
_______________________________________________
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.

------------------------------