Re: [GNC] Finance-Quote 1.61 released!
On Thu, 18 Apr 2024 21:34:49 -0700 "Bruce Schuck" wrote: > New version 1.61 of Finance-Quote is available with the following > changes: > > * SIX.pm - Changed lookup for currency, added lookups for > symbol and last. Issue #380 > * YahooJSON.pm - URLs to retrieve required cookies and crumbs > were changed to allow EU based users to use the module. Issue #373 > Can confirm yahoojson is now working from the UK. Thank you! -- Richard signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 12:39:51 -0700 "Bruce Schuck" wrote: > "AS=v=1=..." cookie. > > ### [Wed Apr 17 08:59:30 2024]cookie_jar : bless( { > ### COOKIES => { > ### 'login.yahoo.com' => { > ### '/' => { > ### AS => [ > ### 0, > ### > 'v=1=pdMraThU=A6620c4d1|itU7Kpb.2SoujXrNK8pQPMi... > ### undef, > ### 1, > ### 1, > ### undef, > ### 1, > ### { > ### HttpOnly => undef > ### } > ### ] > ### } > ### } > ### } > ### }, 'HTTP::Cookies' ) > > The other 3 cookies that I get can see in debug mode are not in the > cookie jar. My theory is that for those it is not working, they are > not getting all 4 cookies. > Sorry for the delayed response. I had to build packages for missing dependencie s required by stockdump.pl. I'm in the UK and confirm output from stockdump.pl shows only the AS cookie. Output from curl --include https://login.yahoo.com/?.lang=en-US=finance&.done=https%3A%2F%2Ffinance.yahoo.com%2F=118332=ybar-signin from the UK gives the same result. -- Richard signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 11:58:37 -0400 "Kalpesh Patel" wrote: > Richard, > > Is this happening on Windows 10 with Strawberry perl? > > There is one other user is having problem getting secure cookies on > Windows 10 which is what this appears to be as well. It is related to > some Perl's SSL package being broken or not installed correctly but > haven't been able to pinpoint it. Hi Kalpesh, I'm running Arch Linux with perl 5.38.2. -- Richard signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 08:23:38 +0200 "Adam Griffis" wrote: > Yes, I have the AlphaVantage api key set. But that's not the issue -- > I'm not pulling from AlphaVantage. I'm pulling from YahooJSON. > > If I understand correctly, the 1.60 update should include a fix to get > YahooJSON working again, resolving the "cookie and crumb" issue. > However, YahooJSON is still giving me the same error. Is an API key > required for YahooJSON now? > > Thanks, > Adam yahoojson and yahooweb are not working for me either in v1.60 and they didn't work in 1.59_01. I have perl-http-cookiejar installed. perl-finance-quote has been dropped from the arch repos to the AUR. It's still at 1.59 in the AUR so I've taken the PKGBUILD and modified it for 1.60. I am currently running gnucash v4.14. The output for yahoojson is... gnc-fq-dump -v yahoojson AEI.L Finance::Quote fields Gnucash uses: symbol: AEI.L<=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock AEI.L stock field value - - - AEI.Lerrormsg: Error retrieving quote for AEI.L. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=AEI.L={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Cookie"}}}=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) AEI.Llast: **missing** AEI.L nav: **missing** AEI.L price: **missing** AEI.L success: 0 AEI.L symbol: AEI.L The output for yahooweb is... gnc-fq-dump -v y ahooweb AEI.L Finance::Quote fields Gnucash uses: symbol: AEI.L (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock AEI.L stock field value - - - AEI.Lerrormsg: 500 Header line too long (limit is 8192) AEI.Llast: **missing** AEI.L nav: **missing** AEI.L price: **missing** AEI.L success: 0 -- Richard signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Reports not displaying.
John, The issue is with webkitgtk 2.42 on Nvidia GPUs and not directly related to flatpak. From the bug report [https://bugs.webkit.org/show\_bug.cgi?id=261874][https_bugs.webkit.org_show_bug.cgi_id_261874] setting WEBKIT\_DISABLE\_DMABUF\_RENDERER=1 provides a temporary fix. This fixed report rendering in gnucash for me. I'm running gnucash 4.14 built from source on an arch system which has webkitgtk 2.42. Regards, Richard \ Original Message On 4 Oct 2023, 05:08, john < jra...@ceridwen.us> wrote: > > Since releasing GnuCash 5.4 we've gotten 3 bug reports (see below) about > report tabs failing to display anything. Two of the three are for the flatpak > distribution of GnuCash 5.4 and running WEBKIT\_DISABLE\_COMPOSITING\_MODE=1 > flatpak run org.gnucash.GnuCash works around the problem and allows reports > to display normally. Both users have Nvidia GPUs, one quite old. The third > report says its for GnuCash 5.2 and the reporter hasn't yet provided any > details. The second reporter also installed Gnome Web, aka Epiphany, via > Flathub and reported that it has the same symptoms. For reference GnuCash > 5.3's flatpak used Gnome Runtime 43 with WebKitGtk 2.37, GnuCash 5.4's is > Gnome Runtime 44 with WebKitGtk 2.39, and the current Epiphany flatpak is > runtime 45 with WebKitGtk 2.42. In addition to flatpaks it seems likely to me > that bleeding-edge distributions like Arch Linux might be affected. I'd like > to know who else is affected along with what GPU and driver they have and if > they're not using the flatpak what version of WebKitGtk they have installed. > I'd also like to collect the same information from people who have Nvidia > GPUs and WebKitGtk >= 2.39 for whom GnuCash reports render normally. Regards, > John Ralls https://bugs.gnucash.org/show\_bug.cgi?id=799086 > https://bugs.gnucash.org/show\_bug.cgi?id=799095 > https://bugs.gnucash.org/show\_bug.cgi?id=799095 > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > 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. [https_bugs.webkit.org_show_bug.cgi_id_261874]: https://bugs.webkit.org/show_bug.cgi?id=261874 signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance::Quote 1.57_02 - YahooWeb gets correct trading date and fixed pricing for single char symbols
Hi Bruce, Just confirming there were no issues updating prices after market close yesterday. Arch Linux Gnucash 4.14 Finance::Quote 1.57\_02 yahoojson yahooweb mstaruk Regards, Richard \ Original Message On 16 Jul 2023, 21:38, Bruce Schuck < bsch...@asgard-systems.com> wrote: > > Greetings, Another beta pre-release for F::Q v1.58 has been uploaded to CPAN. > The URL used by YahooWeb (yahooweb) has been changed to the date is pulled > from web page. The issue with some single-character symbols getting bad > pricing has also been fixed, and labels 'open', 'high', 'low', and 'volume' > have been added. Again, not a production indexed release, you can still > install it using CPAN. $ cpan BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ > cpanm BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ perl -MCPAN -e shell cpan> > install BPSCHUCK/Finance-Quote-1.57\_02.tar.gz Bruce S. > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > 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. signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance::Quote 1.57_01 - YahooJSON Quick Fix
On 15/07/2023 03:28, Bruce Schuck wrote: Greetings, A beta pre-release for F::Q v1.58 has been uploaded to CPAN. It has the quick fix I noted in the earlier "Yahoo Closed the Door on Finance API" thread. Hi Bruce, I've already updated Friday's prices using your quick fix which worked fine, so I'll test this using v1.57_01 after Monday's close. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance-Quote 1.57 released!
Hi Bruce, When prices are updated after midnight, the yahooweb price source is returning the current date instead of the price date. See below... date Wed 5 Jul 00:02:35 BST 2023 gnc-fq-dump yahoo_json STAN.L symbol: STAN.L <=== required date: 07/04/2023 <=== recommended currency: GBP <=== required last: 6.918<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb STAN.L symbol: STAN.L <=== required date: 07/05/2023 <=== recommended currency: GBP <=== required last: 6.918<=\ nav: <=== one of these price: <=/ timezone: <=== optional Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation
On 27/06/2023 02:43, Bruce Schuck wrote: On 6/26/23 22:42 +, Richard Ullger wrote: Thanks for the 1.56_04 update. The price format for LSE securities using the yahooweb price source is fixed but I'm getting a difference in precision on crypto between yahoo_json and yahooweb. Unfortunately that is because the precision available from https://finance.yahoo.com/quote/USDT-USD?p=USDT-USD&.tsrc=fin-srch is not the same as it is from the API. Bruce S. Hi Bruce, I just wanted to report that I have been downloading prices in gnucash for both US and UK stocks and ETFs using yahoo_json and yahooweb price sources without any errors. Arch Linux, gnucash 4.14, Finance::Quote 1.56_04. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation
On 25/06/2023 02:30, Bruce Schuck wrote: Oooops! Make that 1.56_04. I forgot to merge one pull request. Hi Bruce, Thanks for the 1.56_04 update. The price format for LSE securities using the yahooweb price source is fixed but I'm getting a difference in precision on crypto between yahoo_json and yahooweb. gnc-fq-dump yahoo_json USDT-USD symbol: USDT-USD <=== required date: 06/26/2023 <=== recommended currency: USD <=== required last: 1.0002108<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb USDT-USD symbol: USDT-USD <=== required date: 06/26/2023 <=== recommended currency: USD <=== required last: 1.0002 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
On 15/06/2023 20:23, Bruce Schuck wrote: Non-production release 1.56_02 is available for evaluation/testing. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. Anticipating that Yahoo may block access to the URL used in the YahooJSON (yahoo_json) module, there are 3 new modules that gather information from URLs normally accessed through a browser. GoogleWeb (googleweb) MarketWatch (marketwatch) YahooWeb (yahooweb) Hi Bruce, I'm doing preliminary testing using gnc-fq-dump with the yahoo_json and yahooweb sources. I'm getting different price formats between the two sources for LSE securities with yahoo_json being the correct format. gnc-fq-dump yahoo_json SUK2.L symbol: SUK2.L <=== required date: 06/16/2023 <=== recommended currency: GBP <=== required last: 3.53975 <=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb SUK2.L symbol: SUK2.L <=== required date: 06/16/2023 <=== recommended currency: GBp (0.01 GBP) <=== required last: 353.98 <=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahoo_json STAN.L symbol: STAN.L <=== required date: 06/16/2023 <=== recommended currency: GBP <=== required last: 6.752<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb STAN.L symbol: STAN.L <=== required date: 06/16/2023 <=== recommended currency: GBp (0.01 GBP) <=== required last: 675.20 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Arch Linux, gnucash 4.14. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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.
Re: [GNC] Uneven line spacing in Accounts list since 4.11
I've been seeing that in 4.10 on Linux. Regards, Richard \ Original Message On 1 Jul 2022, 01:00, < dull...@gmail.com> wrote: > > I think since 4.11 (am using Windows 11 and a dark theme), I notice very odd > random line spacing in Account list window (the default window when I open > Gnucash) I see the lines for each sub-accounts are not evenly distributed - > spacing seems completely random (some have space above and below, others do > not) I have attached a partial screenshot showing this uneven spacing for the > subaccounts (if the mailing list supports attachments?) Regards, Bill > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > gnucash-user mailing list gnucash-user@gnucash.org To update your > subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using > Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing\_Lists for > more information. - Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online crypto value quote
That's strange, I don't have any issues getting crypto quotes using yahoo json as the source. Regards, Richard On 17/06/2022 16:17, Adrien Monteleone wrote: The error message reports "500" as the status code. That's an Internal Server Error, so it isn't you. Unfortunately, "500" is a generic catch-all for server errors, so there isn't any further information as to what type of error. There's nothing you can do but wait. (at least for Yahoo) Try getting individual quotes in the Terminal using AlphaVantage. Regards, Adrien On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote: Thank you, Geoff, I tried and it says as in attached screenshot. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.