Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
Kalpesh Assuming the F::Q 1.56_02 build files still exist in your C:\Strawberry\cpan\build directory, trying the stockdump.pl example script as I did would help. GnuCash 4.x uses the old gnc-fq-check gnc-fq-dump scripts for checking F::Q. Please show the output from trying these. cd C:\Program Files (x86)\gnucash\bin perl gnc-fq-check perl gnc-fq-dump -v yahoo_json AAPL perl gnc-fq-dump -v yahooweb AAPL cd C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0 (directory name may be slightly different) perl Examples\stockdump.pl yahoo_json AAPL perl Examples\stockdump.pl yahooweb AAPL 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.56_02 Available for Evaluation
My apologies all around, Bruce (I am a subscriber to finance-quote-user):
I was hoping to spare version chase and try to get to where the problem is
myself before possibly sending anyone on a wild rabbit hole. Here is the detail
if it helps in anyway:
- Windows 11
- Strawberry Perl version 5.28 with F::Q 1.56_02
- GnuCash 4.14
I am testing it on GNC Build ID: 4.14+(2023-03-25) at the moment though (should
there be a call difference from GNC 4.X vs 5.X?). I installed the Perl module
using CPAN module like this:
perl -MCPAN -e shell
install 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'
-- start of output from console --
Microsoft Windows [Version 10.0.22621.1848]
(c) Microsoft Corporation. All rights reserved.
C:\Users\kalpesh>ver
Microsoft Windows [Version 10.0.22621.1848]
C:\Users\kalpesh>perl -v
This is perl 5, version 28, subversion 1 (v5.28.1) built for
MSWin32-x86-multi-thread-64int
Copyright 1987-2018, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
C:\Users\kalpesh>where perl
C:\Strawberry\perl\bin\perl.exe
C:\Users\kalpesh>perl -MFinance::Quote -le "print $Finance::Quote::VERSION"
1.56_02
C:\Users\kalpesh>
-- end of output from console --
-Original Message-
From: Bruce Schuck
Sent: Thursday, June 22, 2023 3:40 PM
To: gnucash-user@gnucash.org
Cc: Kalpesh Patel
Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
On 6/22/23 9:16 -0400, Kalpesh Patel" wrote:
> I was using this release in a prod like env (on my own real live files
> in an non-business use case) and seem to be getting unknown error in
> calls from GNC since last night. What is the best way to go about
> debugging this? Precise (un-helpful) error message is:
> There was an unknown error while retrieving the price quotes.
> Other than two securities using AlphaVantage as the source they all
> use Yahoo JSON as the source.
Kalpesh,
First order of business, it's always helpful to include OS info and GnuCash
version in addition to the F::Q version. Even better, the version of Perl as
well (output of "perl -v" or "perl -V").
But from my quick tests, this looks like some odd issue with GnuCash, at least
in Gnucash v5.1 build 5.1+(2023-04-30).
On my Windows 10 VirtualBox system I opened the command prompt and changed
directory to the CPAN build directory for F::Q v1.56_02. Then executed F::Q's
own example program. Using yahoo_json and the new yahooweb as the source method.
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>perl
Examples\stockdump.pl yahoo_json AAPL
$VAR1 = {
'AAPL∟low' => '183.67',
'AAPL∟last' => '186.4784',
'AAPL∟year_range' => ' 124.17 - 186.99',
'AAPL∟open' => '183.74',
'AAPL∟currency' => 'USD',
'AAPL∟isodate' => '2023-06-22',
'AAPL∟high' => '186.73',
'AAPL∟eps' => '5.9',
'AAPL∟pe' => '31.606506',
'AAPL∟close' => '183.96',
'AAPL∟date' => '06/22/2023',
'AAPL∟div_yield' => '0.50010870001',
'AAPL∟volume' => 34407477,
'AAPL∟name' => 'AAPL (Apple Inc.)',
'AAPL∟method' => 'yahoo_json',
'AAPL∟success' => 1,
'AAPL∟exchange' => 'Sourced from Yahoo Finance (as JSON)',
'AAPL∟type' => 'EQUITY',
'AAPL∟symbol' => 'AAPL'
};
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0> perl Examples\stockdump.pl
yahooweb AAPL
$VAR1 = {
'AAPL∟date' => '06/22/2023',
'AAPL∟currency' => 'USD',
'AAPL∟last' => '186.49',
'AAPL∟isodate' => '2023-06-22',
'AAPL∟success' => 1,
'AAPL∟symbol' => 'AAPL',
'AAPL∟method' => 'yahooweb',
'AAPL∟name' => 'Apple Inc.',
'AAPL∟exchange' => 'NasdaqGS - NasdaqGS Real Time Price'
};
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>
Both worked fine. As well as using the GnuCash CLI.
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>gnucash-cli --verbose --quotes
dump yahoo_json AAPL
AAPL:
volume => 36019308
success => 1
date => 06/22/2023
open => 183.74
high => 186.73
last => 186.4601
low => 183.67
exchange => Sourced from Yahoo Finance (as JSON)
name => AAPL (Apple Inc.)
div_yield => 0.50010870001
close => 183.96
type => EQUITY
currency => USD
symbol => AAPL
year_range => 124.17 - 186.99
method => yahoo_json
isodate => 2023-06-22
pe => 31.603407
eps => 5.9
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>gnucash-cli --verbose
--quotes dump yahooweb A
Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
On 6/22/23 9:16 -0400, Kalpesh Patel" wrote:
I was using this release in a prod like env (on my own real live
files in an non-business use case) and seem to be getting unknown
error in calls from GNC since last night. What is the best way to go
about debugging this? Precise (un-helpful) error message is:
There was an unknown error while retrieving the price quotes.
Other than two securities using AlphaVantage as the source they all
use Yahoo JSON as the source.
Kalpesh,
First order of business, it's always helpful to include OS info and
GnuCash version in addition to the F::Q version. Even better, the
version of Perl as well (output of "perl -v" or "perl -V").
But from my quick tests, this looks like some odd issue with GnuCash, at
least in Gnucash v5.1 build 5.1+(2023-04-30).
On my Windows 10 VirtualBox system I opened the command prompt and
changed directory to the CPAN build directory for F::Q v1.56_02. Then
executed F::Q's own example program. Using yahoo_json and the new
yahooweb as the source method.
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>perl
Examples\stockdump.pl yahoo_json AAPL
$VAR1 = {
'AAPL∟low' => '183.67',
'AAPL∟last' => '186.4784',
'AAPL∟year_range' => ' 124.17 - 186.99',
'AAPL∟open' => '183.74',
'AAPL∟currency' => 'USD',
'AAPL∟isodate' => '2023-06-22',
'AAPL∟high' => '186.73',
'AAPL∟eps' => '5.9',
'AAPL∟pe' => '31.606506',
'AAPL∟close' => '183.96',
'AAPL∟date' => '06/22/2023',
'AAPL∟div_yield' => '0.50010870001',
'AAPL∟volume' => 34407477,
'AAPL∟name' => 'AAPL (Apple Inc.)',
'AAPL∟method' => 'yahoo_json',
'AAPL∟success' => 1,
'AAPL∟exchange' => 'Sourced from Yahoo Finance (as JSON)',
'AAPL∟type' => 'EQUITY',
'AAPL∟symbol' => 'AAPL'
};
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0> perl
Examples\stockdump.pl yahooweb AAPL
$VAR1 = {
'AAPL∟date' => '06/22/2023',
'AAPL∟currency' => 'USD',
'AAPL∟last' => '186.49',
'AAPL∟isodate' => '2023-06-22',
'AAPL∟success' => 1,
'AAPL∟symbol' => 'AAPL',
'AAPL∟method' => 'yahooweb',
'AAPL∟name' => 'Apple Inc.',
'AAPL∟exchange' => 'NasdaqGS - NasdaqGS Real Time Price'
};
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>
Both worked fine. As well as using the GnuCash CLI.
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>gnucash-cli --verbose
--quotes dump yahoo_json AAPL
AAPL:
volume => 36019308
success => 1
date => 06/22/2023
open => 183.74
high => 186.73
last => 186.4601
low => 183.67
exchange => Sourced from Yahoo Finance (as JSON)
name => AAPL (Apple Inc.)
div_yield => 0.50010870001
close => 183.96
type => EQUITY
currency => USD
symbol => AAPL
year_range => 124.17 - 186.99
method => yahoo_json
isodate => 2023-06-22
pe => 31.603407
eps => 5.9
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>gnucash-cli --verbose
--quotes dump yahooweb AAPL
AAPL:
date => 06/22/2023
currency => USD
symbol => AAPL
name => Apple Inc.
exchange => NasdaqGS - NasdaqGS Real Time Price
method => yahooweb
last => 186.45
success => 1
isodate => 2023-06-22
C:\Strawberry\cpan\build\Finance-Quote-1.56_02-0>
Thank you.
Bruce S.
P.S. - When replying to all, please remove mailing lists that you are
not subscribed to from the recipients (in your case it was
finance-quote-devel and finance-quote-user, but you are not the only
guilty party).
___
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
Hi Bruce - I was using this release in a prod like env (on my own real live files in an non-business use case) and seem to be getting unknown error in calls from GNC since last night. What is the best way to go about debugging this? Precise (un-helpful) error message is: There was an unknown error while retrieving the price quotes. Other than two securities using AlphaVantage as the source they all use Yahoo JSON as the source. Thanks. -Original Message- From: Bruce Schuck Sent: Thursday, June 15, 2023 3:24 PM To: Finance-Quote-News ; Finance-Quote-User ; GnuCash User Subject: [GNC] Finance::Quote 1.56_02 Available for Evaluation Greetings all, 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) In addition the Fool module was corrected so it now works. 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.
