[GNC] Tesouro_direto not working after F:Q 1.60
Hi Guys, I realise that I can’t get quotes from tesouro_direto anymore after update to Finance::Quote 1.60. I was receiving this error message: Found Finance::Quote version 1.60. * 07:05:12 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use string ("") as a HASH ref while "strict refs" in use at /Applications/Gnucash.app/Contents/Resources/bin/finance-quote-wrapper line 185. Price retrieval failed: Unrecognized Finance::Quote Error: Can't use string ("") as a HASH ref while "strict refs" in use at /Applications/Gnucash.app/Contents/Resources/bin/finance-quote-wrapper line 185. Thanks ___ 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] Help with setting up stock price updates
Hello David, thanks for your reply …. I confess though that I’m not sure what to do with the answer and don’t know how to uninstall Finance::Quote … I also dont find a \bin directory. Maybe i need baby steps help :) Anna Sent from my iPad On Apr 17, 2024, at 15:28, david amaral wrote: cpanm Finance::Quote go to gnucash\bin perl gnc-fq-update might have to uninstall finance quote if problems cpanm --uninstall Finance::Quote On Wednesday, April 17, 2024 at 03:10:48 PM GMT-7, Anna Scott wrote: Hello all … I’m advancing beyond basics for the first time and am stuck trying to create a new security in pricing editor - under “Quote Source Information” it gives error message that “Warning: Finance: Quote not installed properly”. I’ve seen other references to this as a bug … but don’t know if it’s been resolved? I’m using GNUCASH 5.3 on a MAC with Sonoma 14.0 . Id appreciate any and all help! Thanks in advance, A ___ gnucash-user mailing list [1]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [2]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. References 1. mailto:gnucash-user@gnucash.org 2. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ 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.
[GNC] Merge amounts in report
I have some expenses accounts that hold the same name (for example, "eating out") but one is related to my personal expenses and the other either is related to the mutual expenses I have with my fianceé or to a trip expense, for example. I would like to know if there is a way that when I'm looking at an expense report, for example, I could see the total amount of these accounts sumed up rather than the each amount separately. I'd appreciate thoughts on the topic. Bruno Alves ___ 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.61 released!
Hi Bruce, nup, I checked it again: $ locate YahooJSON.pm /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm /usr/share/perl5/site_perl/Finance/Quote/CurrencyRates/YahooJSON.pm $ grep -i version /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm #the Free Software Foundation; either version 2 of the License, or #(at your option) any later version. use vars qw($VERSION $YIND_URL_HEAD $YIND_URL_TAIL); our $VERSION = '1.61'; # VERSION $ DEBUG=1 ./stockdump.pl yahoojson ^GDAXI ### AlphaVantage->new args : {} ### [Fri Apr 19 23:46:21 2024]cookie_jar : bless( { ### COOKIES => { ### 'www.yahoo.com' => { ### '/' => { ### RRC => [ ### 0, ### 'st=1713563181248.6&cnt=1', ### undef, ### 1, ### undef, ### undef, ### 1, ### { ### HttpOnly => undef ### } ### ] ### } ### } ###} ### }, 'HTTP::Cookies' ) ### [Fri Apr 19 23:46:21 2024] crumb : '{"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Cookie"}}}' $VAR1 = { '^GDAXIerrormsg' => 'Error retrieving quote for ^GDAXI. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=^GDAXI&crumb={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Cookie"}}}&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized)', '^GDAXIsymbol' => '^GDAXI', '^GDAXIsuccess' => 0 $ cat ./stockdump.pl #!/usr/bin/perl -w use strict; use lib '../lib'; use Finance::Quote; use Data::Dumper; use Getopt::Std; use DateTime; # A very very simple script. Takes a source and a symbol, looks it up, # and dumps it to STDOUT. Useful for debugging. my %options = ('c' => ''); getopts('c:',\%options); die "Usage: $0 [-c currency] source symbol\n" unless (defined $ARGV[1]); my $q = Finance::Quote->new; if ($options{'c'}) { $q->set_currency($options{'c'}); } my %quotes = $q->fetch(@ARGV); -- I run Archlinux on my machines and both show the same error: 'invalid cookie'. Best regards Klaus On Fri, 19 Apr 2024 09:23:16 -0700 Bruce Schuck wrote: > Adam Griffis also noted that it is working from Germany. > > I suspect that you set PERL5LIB to use > $HOME/.cpan/build/Finance-Quote-1.60-0/ instead of 1.61? ___ 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.
[GNC] F::Q CLI issue with GNC 5.6-1 on Win 11
When using GNC 5.4 on Windows 11, F::Q 1.59 & 1.60 work perfectly (except for the quote source issues resolved with 1.6). When upgrade to GNC 5.6-1 neither F::Q 1.59 nor 1.6 CLI works, error message indicates unable to find data file. Note that using the Get Quotes button in the Price Database window does work perfectly with GNC 5.6-1. My CLI command, run as administrator, is: "C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe" --verbose --quotes get file://C:/Users/KCBurns/AppData/Local/GnuCash/KCBurns.gnucash I am USA-based using unknown\yahoojson as the quote source for six securities on NASDAQ and NYSE; though I have tried other quote sources with no success. Re-installing GNC 5.4 gives me a functioning F::Q CLI. ___ 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.61 released!
On 4/19/24 9:52 AM, Murugan Muruganandam wrote: Bruce and team, thanks for the build It was Kalpesh that spent time looking for different Yahoo URIs and standing up AWS instances in other regions for testing. Me, I just did the administrative work to get the new package pushed to CPAN. I think i was using yahooweb and yahoojson With 1.60, and now 1.61, "yahoojson" is sort of an alias for "yahoo_json". It uses the same method within the YahooJSON.pm source module. The "yahooweb" issue of the header being too large has not yet been addressed. Aside from adding code to allow the large amount of header information sent from the URL used, the HTML/CSS also changed recently. now it is working perfectly With "Yahoo!" I hate to ask, "but for how long?"... Thank you. 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.
Re: [GNC] Finance-Quote 1.61 released!
Bruce and team, thanks for the build I think i was using yahooweb and yahoojson now it is working perfectly Saludos Cordiales Murugan From: gnucash-user on behalf of Murugan Muruganandam Sent: Friday, April 19, 2024 10:09 AM To: Adam Griffis ; Richard Ullger Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Finance-Quote 1.61 released! From Chile, Currency is working but stocks are failing for NYSE, Nasdaq Saludos Cordiales Murugan From: gnucash-user on behalf of Adam Griffis Sent: Friday, April 19, 2024 3:08 AM To: Richard Ullger Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Finance-Quote 1.61 released! Also can confirm 1.61 is working from Germany! On Fri, Apr 19, 2024 at 9:03 AM Richard Ullger via gnucash-user wrote: > > 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 > ___ > 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. ___ 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.
Re: [GNC] Finance-Quote 1.61 released!
Adam Griffis also noted that it is working from Germany. I suspect that you set PERL5LIB to use $HOME/.cpan/build/Finance-Quote-1.60-0/ instead of 1.61? ___ 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.61 released!
Doesn't work for me out of Germany, reply is 'invalid cookie': $ DEBUG=1 ./stockdump.pl yahoo_json ^GDAXI ### AlphaVantage->new args : {} ### [Fri Apr 19 16:48:36 2024]cookie_jar : bless( { ### COOKIES => { ### 'www.yahoo.com' => { ### '/' => { ### RRC => [ ### 0, ### 'st=1713538115915.3&cnt=1', ### undef, ### 1, ### undef, ### undef, ### 1, ### { ### HttpOnly => undef ### } ### ] ### } ### } ###} ### }, 'HTTP::Cookies' ) ### [Fri Apr 19 16:48:36 2024] crumb : '{"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Cookie"}}}' $VAR1 = { '^GDAXIerrormsg' => 'Error retrieving quote for ^GDAXI. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=^GDAXI&crumb={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Cookie"}}}&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized)', '^GDAXIsymbol' => '^GDAXI', '^GDAXIsuccess' => 0 }; Best regards Klaus On Fri, 19 Apr 2024 09:08:00 +0200 Adam Griffis wrote: > Also can confirm 1.61 is working from Germany! > > On Fri, Apr 19, 2024 at 9:03 AM Richard Ullger via gnucash-user > wrote: > > > > 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 > > ___ ___ 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.61 released!
From Chile, Currency is working but stocks are failing for NYSE, Nasdaq Saludos Cordiales Murugan From: gnucash-user on behalf of Adam Griffis Sent: Friday, April 19, 2024 3:08 AM To: Richard Ullger Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Finance-Quote 1.61 released! Also can confirm 1.61 is working from Germany! On Fri, Apr 19, 2024 at 9:03 AM Richard Ullger via gnucash-user wrote: > > 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 > ___ > 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. ___ 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.61 released
Hello I get a the following error message: Quotes for the following commodities were unavailable or unusable: Finance::Quote reported failure with error: 500 Header line too long (limit is 8192) WIN 10 or WIN 11 FQ 1.59, 1.60, 1.61 On 2024-04-19 15:09, Adam Griffiswrote: > Also can confirm 1.61 is working from Germany! > > On Fri, Apr 19, 2024 at 9:03 AM Richard Ullger via gnucash-user > wrote: > > > > 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 > > ___ > > 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. ___ 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.61 released!
Also can confirm 1.61 is working from Germany! On Fri, Apr 19, 2024 at 9:03 AM Richard Ullger via gnucash-user wrote: > > 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 > ___ > 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.
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.