[GNC] Yahoo JSON - throwing unauthorized error

[John Layman]

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.