[GNC] Yahoo JSON - throwing unauthorized error

R Losey rlosey at gmail.com
Mon May 8 14:05:48 EDT 2023


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


More information about the gnucash-user mailing list