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 <[email protected]> On Behalf Of R Losey Sent: Monday, May 8, 2023 2:06 PM To: David G. Pickett <[email protected]> Cc: [email protected] 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 < [email protected]> 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 <[email protected]> > To: [email protected] <[email protected]> > 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 > [email protected] > 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 [email protected] Micah 6:8 _______________________________________________ gnucash-user mailing list [email protected] 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 [email protected] 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.
