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.lay...@laymanandlayman.com> To: "'R Losey'" <rlo...@gmail.com>, "'David G. Pickett'" <dgpick...@aol.com> Cc: <gnucash-user@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....@gnucash.org> On Behalf Of R Losey Sent: Monday, May 8, 2023 2:06 PM To: David G. Pickett <dgpick...@aol.com> 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 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@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@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@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@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 <dgpick...@aol.com> > To: gnucash-user@gnucash.org <gnucash-user@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@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 rlo...@gmail.com Micah 6:8 _______________________________________________ gnucash-user mailing list gnucash-user@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@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.
