Re: [GNC] Finance-Quote 1.61 released!
Flatpak? ___ 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/28/24 06:28, Klaus Dahlke wrote: It took a while to figure out why yahoo_json didn't work. When trying to fetch the cookie from fc.yahoo.com the response was 'connection refused', also when trying to connect via browser. In the end it turned out that pihole blocked fc.yahoo.com. Once I added fc.yahoo.com to the whitelist in pihole, yahoo_json works as designed. Klaus, Thank you for that update. The YahooJSON.pm module needs to add some error handling for when either of the first two URL fetches fail or return an unexpected response. Sorry I missed that in reviewing recent updates. Bruce S OpenPGP_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.61 released!
It took a while to figure out why yahoo_json didn't work. When trying to fetch the cookie from fc.yahoo.com the response was 'connection refused', also when trying to connect via browser. In the end it turned out that pihole blocked fc.yahoo.com. Once I added fc.yahoo.com to the whitelist in pihole, yahoo_json works as designed. 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.
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=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={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}=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.
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=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={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}=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.
[GNC] Finance-Quote 1.61 released!
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 Authors: - Erik Colson - Paul Fenwick - Bruce Schuck - Vincent Lucarelli - David Hampton - jvolkening - Pawel Konieczny - Mike Alexander - AndreJ - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Paul Howarth - Sam Morris - Linas Vepstas - Hiranya Samarasekera - Manuel Friedli - Achim Winkler - Diego Marcolungo - John Haiducek - Rajan Vaswani <111571283+bgr22...@users.noreply.github.com> - alex314159 - gregor herrmann - Jalon Avens - Sigve Indregard - bgr22112 <111571283+bgr22...@users.noreply.github.com> - goodvibes2 - Ben Hemming - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - Eelco Dolstra - Emmanuel Di Pretoro - Florian Schlichting - Gabor Szabo - GitGord <46006740+gitg...@users.noreply.github.com> - Gustavo R. Montesino - Henrik Ahlgren - Jean-Marie Pacquet - Joseph Heron - Lance Wicks - Liviu Tinta - Martin Kompf - Pete Ratzlaff - Ross Peachey - Stephan Ebelt - Stephan Gambke - linas - thinus - x42x64 ___ 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.
