Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

On 5/6/23 15:01, John Ralls wrote:


On my mid-2010 MBP running Mac OS X 10.13.6 I get the following from
your script: 



`.cpan/build/Finance::Quote-blah/Examples/stockdump.pl
alphavantage AAPL` works fine. `Examples/currency-lookup.pl EUR GBP`
returns "Urgh. Nothing back" while on my 2013 MacPro running macOS 12
it returns "EUR->GBP = 0.87222" as expected.



Weird, eh?


Not really. Perl's ability to easily change where modules are loaded 
from, great for developers; sometimes creates a mess when modules were 
sometimes installed as root (or using sudo), and in custom or local user 
based paths other times.


The key to testing the examples is to always test from the immediate 
parent directory of ./Examples. Since they all have this line to modify 
the search path for modules.


use lib '../lib';

But as I said, my High Sierra VM was a virgin fresh install. I installed 
F::Q using sudo in MyConfig.pm, then updated Module::Load also with the 
sudo based MyConfig. Fetching data did not work until I updated 
Module::Load. I think the version that came installed on High Sierra was 
.24 or something else quite lower than .36.


- 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 problem MacOS High Sierra.

[John Ralls]

Bruce,

On my mid-2010 MBP running Mac OS X 10.13.6 I get the following from your 
script:

Archive::Any::Lite version = 0.11
Array::Diff version = 0.09
AutoLoader version = 5.74
B::COW version = 0.007
B::Keywords version = 1.24
Bundle::NetSNMP version = Not Found
CPAN::DistnameInfo version = 0.12
CPAN::Meta version = 2.150010
CPAN::Meta::Check version = 0.017
CPAN::Meta::Requirements version = 2.140
CPAN::Meta::YAML version = 0.018
Clone version = 0.46
Compress::Raw::Zlib version = 2.204
Config::Tiny version = 2.28
Crypt::RC4 version = 2.02
Data::Binary version = 0.01
Data::Section version = 0.28
Date::Manip version = 6.91
Date::Range version = 1.41
Date::Simple version = 3.03
DateTime version = 1.59
DateTime::Format::Builder version = 0.83
DateTime::Format::ISO8601 version = 0.16
DateTime::Format::Strptime version = 1.79
DateTime::Locale version = 1.37
DateTime::TimeZone version = 2.57
Devel::StackTrace version = 2.04
Devel::Symdump version = 2.18
Devel::Trace version = 0.12
Digest::Perl::MD5 version = 1.9
Encode version = 3.19
Exception::Class version = 1.45
ExtUtils::MakeMaker version = 7.68
ExtUtils::MakeMaker::CPANfile version = 0.09
File::Copy::Recursive version = 0.45
File::Find::Object version = 0.3.7
File::ShareDir version = 1.118
File::ShareDir::Install version = 0.14
File::TreeCreate version = 0.0.1
File::pushd version = 1.016
Finance::Quote version = 1.54
HTML-TableExtract version = Not Found
HTML::Selector::XPath version = 0.26
HTML::TokeParser::Simple version = 3.16
HTML::TreeBuilder::XPath version = 0.14
HTTP::Daemon version = 6.16
HTTP::Message version = 6.44
IO::Socket::IP version = 0.41
IPC::System::Simple version = 1.30
Importer version = 0.026
JSON version = 4.10
JSON::PP version = 4.16
JSON::Parse version = 0.62
LWP version = 6.68
Lingua::EN::Inflect version = 1.905
List::SomeUtils version = 0.59
List::SomeUtils::XS version = 0.58
List::Util version = 1.63
MCE version = 1.884
Module::Build version = 0.4232
Module::Build::Tiny version = 0.039
Module::CPANTS::Analyse version = 1.01
Module::CPANfile version = 1.1004
Module::CoreList version = 5.20230220
Module::Load version = 0.36
Module::Load::Conditional version = 0.74
Module::Metadata version = 1.37
Module::Pluggable version = 5.2
Mozilla::CA version = 20221114
OLE::Storage_Lite version = 0.22
PPI version = 1.276
PPIx::QuoteLike version = 0.023
PPIx::Regexp version = 0.088
PPIx::Utils version = 0.003
Params::ValidationCompiler version = 0.31
Parse::Distname version = 0.05
Path::Tiny version = 0.144
Perl version = 5.18.2
Perl::Critic version = 1.150
Perl::PrereqScanner::NotQuiteLite version = 0.9916
Perl::Tidy version = 20230309
Pod::Coverage version = 0.23
Pod::Spell version = 1.26
Readonly version = 2.05
Regexp::Trie version = 0.02
Role::Tiny version = 2.002004
SelfLoader version = 1.24
Software::License version = 0.104002
Specio version = 0.48
Spiffy version = 0.46
Spreadsheet::ParseExcel version = 0.65
Spreadsheet::XLSX version = 0.17
String::Format version = 1.18
String::Util version = 1.34
Sub::Identify version = 0.14
Sub::Info version = 0.002
Sub::Override version = 0.09
Term::Table version = 0.016
Test2::Plugin::NoWarnings version = 0.09
Test2::Suite version = 0.000148
Test::Base version = 0.89
Test::FailWarnings version = 0.008
Test::File version = 1.993
Test::File::ShareDir version = 1.001002
Test::Harness version = 3.44
Test::Inter version = 1.10
Test::Kwalitee version = 1.28
Test::LeakTrace version = 0.17
Test::More::UTF8 version = 0.05
Test::Needs version = 0.002010
Test::NoWarnings version = 1.06
Test::Perl::Critic version = 1.04
Test::Pod version = 1.52
Test::Pod::Coverage version = 1.10
Test::RequiresInternet version = 0.05
Test::Simple version = 1.302194
Test::UseAllModules version = 0.17
Test::Warnings version = 0.031
Test::Without::Module version = 0.21
Test::YAML version = 1.07
Text::Template version = 1.61
Web::Scraper version = 0.38
XML::XPathEngine version = 0.14
XString version = 0.005
YAML version = 1.30
local::lib version = Not Found
mod_perl2 version = 2.09
namespace::autoclean version = 0.29

`.cpan/build/Finance::Quote-blah/Examples/stockdump.pl alphavantage AAPL` works 
fine. `Examples/currency-lookup.pl EUR GBP` returns "Urgh. Nothing back" while 
on my 2013 MacPro running macOS 12 it returns "EUR->GBP = 0.87222" as expected.

Weird, eh?

Regards,
John Ralls

> On May 6, 2023, at 2:29 PM, Bruce Schuck  wrote:
> 
> John,
> 
> Is this still an issue?
> 
> From my virgin High Sierra Virtual Box system after installing Finance::Quote 
> and updating Load::Module.
> 
> Archive::Any::Lite version=0.11
> Array::Diff version=0.09
> AutoLoader version=5.74
> B::COW version=0.007
> B::Keywords version=1.24
> Bundle::NetSNMP version=Version Not Found.
> CPAN::DistnameInfo version=0.12
> CPAN::Meta version=2.150010
> CPAN::Meta::Check version=0.017
> CPAN::Meta::Requirements version=2.140
> CPAN::Meta::YAML version=0.018
> Clone version=0.46
> Compress::Raw::Zlib version=2.204
> Config::Tiny version=2.28

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

John,

Is this still an issue?

From my virgin High Sierra Virtual Box system after installing 
Finance::Quote and updating Load::Module.


Archive::Any::Lite version=0.11
Array::Diff version=0.09
AutoLoader version=5.74
B::COW version=0.007
B::Keywords version=1.24
Bundle::NetSNMP version=Version Not Found.
CPAN::DistnameInfo version=0.12
CPAN::Meta version=2.150010
CPAN::Meta::Check version=0.017
CPAN::Meta::Requirements version=2.140
CPAN::Meta::YAML version=0.018
Clone version=0.46
Compress::Raw::Zlib version=2.204
Config::Tiny version=2.28
Crypt::RC4 version=2.02
Cwd version=3.75
Data::Binary version=0.01
Data::Dumper::Perltidy version=0.03
Data::Section version=0.28
Date::Manip version=6.91
Date::Range version=1.41
Date::Simple version=3.03
DateTime version=1.59
DateTime::Format::Builder version=0.83
DateTime::Format::ISO8601 version=0.16
DateTime::Format::Strptime version=1.79
DateTime::Locale version=1.37
DateTime::TimeZone version=2.59
Devel::StackTrace version=2.04
Devel::Symdump version=2.18
Devel::Trace version=0.12
Digest::Perl::MD5 version=1.9
Encode version=3.19
Exception::Class version=1.45
ExtUtils::MakeMaker version=7.68
ExtUtils::MakeMaker::CPANfile version=0.09
File::Copy::Recursive version=0.45
File::Find::Object version=0.3.7
File::ShareDir version=1.118
File::ShareDir::Install version=0.14
File::TreeCreate version=0.0.1
File::pushd version=1.016
Finance::Quote version=1.54
HTML-TableExtract version=Version Not Found.
HTML::Selector::XPath version=0.26
HTML::TokeParser::Simple version=3.16
HTML::TreeBuilder::XPath version=0.14
HTTP::Daemon version=6.16
HTTP::Message version=6.44
IO::Socket::IP version=0.41
IPC::System::Simple version=1.30
Importer version=0.026
JSON version=4.10
JSON::PP version=4.16
LWP version=6.68
Lingua::EN::Inflect version=1.905
List::SomeUtils version=0.59
List::SomeUtils::XS version=0.58
List::Util version=1.63
MCE version=1.884
Module::Build version=0.4232
Module::Build::Tiny version=0.039
Module::CPANTS::Analyse version=1.01
Module::CPANfile version=1.1004
Module::CoreList version=5.20230320
Module::Load version=0.36
Module::Metadata version=1.37
Module::Pluggable version=5.2
Mozilla::CA version=20221114
OLE::Storage_Lite version=0.22
PPI version=1.276
PPIx::QuoteLike version=0.023
PPIx::Regexp version=0.088
PPIx::Utils version=0.003
Params::ValidationCompiler version=0.31
Parse::Distname version=0.05
Path::Tiny version=0.144
Perl version=5.18.2
Perl::Critic version=1.150
Perl::PrereqScanner::NotQuiteLite version=0.9916
Perl::Tidy version=20230309
Pod::Coverage version=0.23
Pod::Spell version=1.26
Readonly version=2.05
Regexp::Trie version=0.02
Role::Tiny version=2.002004
SelfLoader version=1.24
Smart::Comments version=1.06
Software::License version=0.104002
Specio version=0.48
Spiffy version=0.46
Spreadsheet::ParseExcel version=0.65
Spreadsheet::XLSX version=0.17
String::Format version=1.18
String::Util version=1.34
Sub::Identify version=0.14
Sub::Info version=0.002
Sub::Override version=0.09
Term::ReadLine version=1.14
Term::Table version=0.016
Test2::Plugin::NoWarnings version=0.09
Test2::Suite version=0.000150
Test::Base version=0.89
Test::FailWarnings version=0.008
Test::File version=1.993
Test::File::ShareDir version=1.001002
Test::Harness version=3.44
Test::Inter version=1.10
Test::Kwalitee version=1.28
Test::LeakTrace version=0.17
Test::More::UTF8 version=0.05
Test::Needs version=0.002010
Test::NoWarnings version=1.06
Test::Perl::Critic version=1.04
Test::Pod version=1.52
Test::Pod::Coverage version=1.10
Test::RequiresInternet version=0.05
Test::Simple version=1.302194
Test::UseAllModules version=0.17
Test::Warnings version=0.031
Test::Without::Module version=0.21
Test::YAML version=1.07
Text::Template version=1.61
Web::Scraper version=0.38
XML::XPathEngine version=0.14
XString version=0.005
YAML version=1.30
YAML::LibYAML version=0.86
mod_perl2 version=2.09
namespace::autoclean version=0.29

F::Q is returning good data using AlphaVantage.

Output above created using this little Perl script:

# BEGIN #
#!/usr/bin/perl
use strict;
use warnings;
use ExtUtils::Installed; # By default this module will be available in Perl

my $instmod = ExtUtils::Installed->new();
foreach my $module ($instmod->modules()) {
 my $version = $instmod->version($module) || "Version Not Found.";
 print "$module version=$version \n";
}
I#  END  #
- Bruce S.


On 3/25/23 4:11 PM, Bruce Schuck wrote:

Thanks John.

Coincidentally I just managed to install a High Sierra VM under 
VirtualBox on my MacBook w/Catalina.


I'll be taking a look at this soon.

- Bruce S.

On 3/25/23 3:47 PM, John Ralls wrote:

Bruce,

Versions:
Module::Load 0.36
Module::Load::Conditional 0.74
SelfLoader 1.24
AutoLoader 5.74

and for good measure
Perl 5.18.2

I ran perl -d:Trace 
.cpan/build/Finance-Quote-blah-blah/Examples/currency-lookup.pl EUR 
USD and attached the zipped result below. You might see a couple of 
unfamiliar strings, those are from print statements I'd 

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

John,

I hate to say this, but on the High Sierra VM I just built 
Finance::Quote is getting valid currency exchanges. At first I was 
having the same issue, but after installing/updating Module::Load the 
issue was corrected.


Bruces-Virtual-High-Sierra:~ bschuck$ sw_vers
ProductName:Mac OS X
ProductVersion: 10.13.6
BuildVersion:   17G66

Bruces-Virtual-High-Sierra:~ bschuck$ perl -v

This is perl 5, version 18, subversion 2 (v5.18.2) built for 
darwin-thread-multi-2level


#!/usr/bin/perl
use strict;
use warnings;
use ExtUtils::Installed; # By default this module will be available in Perl

my $instmod = ExtUtils::Installed->new();
foreach my $module ($instmod->modules()) {
 my $version = $instmod->version($module) || "Version Not Found.";
 print "$module version=$version \n";
}


Archive::Any::Lite version=0.11
Array::Diff version=0.09
AutoLoader version=5.74
B::COW version=0.007
B::Keywords version=1.24
Bundle::NetSNMP version=Version Not Found.
CPAN::DistnameInfo version=0.12
CPAN::Meta version=2.150010
CPAN::Meta::Check version=0.017
CPAN::Meta::Requirements version=2.140
CPAN::Meta::YAML version=0.018
Clone version=0.46
Compress::Raw::Zlib version=2.204
Config::Tiny version=2.28
Crypt::RC4 version=2.02
Cwd version=3.75
Data::Binary version=0.01
Data::Dumper::Perltidy version=0.03
Data::Section version=0.28
Date::Manip version=6.91
Date::Range version=1.41
Date::Simple version=3.03
DateTime version=1.59
DateTime::Format::Builder version=0.83
DateTime::Format::ISO8601 version=0.16
DateTime::Format::Strptime version=1.79
DateTime::Locale version=1.37
DateTime::TimeZone version=2.59
Devel::StackTrace version=2.04
Devel::Symdump version=2.18
Devel::Trace version=0.12
Digest::Perl::MD5 version=1.9
Encode version=3.19
Exception::Class version=1.45
ExtUtils::MakeMaker version=7.68
ExtUtils::MakeMaker::CPANfile version=0.09
File::Copy::Recursive version=0.45
File::Find::Object version=0.3.7
File::ShareDir version=1.118
File::ShareDir::Install version=0.14
File::TreeCreate version=0.0.1
File::pushd version=1.016
Finance::Quote version=1.54
HTML-TableExtract version=Version Not Found.
HTML::Selector::XPath version=0.26
HTML::TokeParser::Simple version=3.16
HTML::TreeBuilder::XPath version=0.14
HTTP::Daemon version=6.16
HTTP::Message version=6.44
IO::Socket::IP version=0.41
IPC::System::Simple version=1.30
Importer version=0.026
JSON version=4.10
JSON::PP version=4.16
LWP version=6.68
Lingua::EN::Inflect version=1.905
List::SomeUtils version=0.59
List::SomeUtils::XS version=0.58
List::Util version=1.63
MCE version=1.884
Module::Build version=0.4232
Module::Build::Tiny version=0.039
Module::CPANTS::Analyse version=1.01
Module::CPANfile version=1.1004
Module::CoreList version=5.20230320
Module::Load version=0.36
Module::Metadata version=1.37
Module::Pluggable version=5.2
Mozilla::CA version=20221114
OLE::Storage_Lite version=0.22
PPI version=1.276
PPIx::QuoteLike version=0.023
PPIx::Regexp version=0.088
PPIx::Utils version=0.003
Params::ValidationCompiler version=0.31
Parse::Distname version=0.05
Path::Tiny version=0.144
Perl version=5.18.2
Perl::Critic version=1.150
Perl::PrereqScanner::NotQuiteLite version=0.9916
Perl::Tidy version=20230309
Pod::Coverage version=0.23
Pod::Spell version=1.26
Readonly version=2.05
Regexp::Trie version=0.02
Role::Tiny version=2.002004
SelfLoader version=1.24
Smart::Comments version=1.06
Software::License version=0.104002
Specio version=0.48
Spiffy version=0.46
Spreadsheet::ParseExcel version=0.65
Spreadsheet::XLSX version=0.17
String::Format version=1.18
String::Util version=1.34
Sub::Identify version=0.14
Sub::Info version=0.002
Sub::Override version=0.09
Term::ReadLine version=1.14
Term::Table version=0.016
Test2::Plugin::NoWarnings version=0.09
Test2::Suite version=0.000150
Test::Base version=0.89
Test::FailWarnings version=0.008
Test::File version=1.993
Test::File::ShareDir version=1.001002
Test::Harness version=3.44
Test::Inter version=1.10
Test::Kwalitee version=1.28
Test::LeakTrace version=0.17
Test::More::UTF8 version=0.05
Test::Needs version=0.002010
Test::NoWarnings version=1.06
Test::Perl::Critic version=1.04
Test::Pod version=1.52
Test::Pod::Coverage version=1.10
Test::RequiresInternet version=0.05
Test::Simple version=1.302194
Test::UseAllModules version=0.17
Test::Warnings version=0.031
Test::Without::Module version=0.21
Test::YAML version=1.07
Text::Template version=1.61
Web::Scraper version=0.38
XML::XPathEngine version=0.14
XString version=0.005
YAML version=1.30
YAML::LibYAML version=0.86
mod_perl2 version=2.09
namespace::autoclean version=0.29

I would love to see the output of the above Perl script from the system 
having the issue.


Bruces-Virtual-High-Sierra:finance-quote bschuck$ pwd
/Users/bschuck/tmp/finance-quote
Bruces-Virtual-High-Sierra:finance-quote bschuck$ 
./Examples/currency-lookup.pl EUR USD

EUR->USD = 1.0763104

Thanks.

- Bruce S.


On 3/25/23 4:11 PM, Bruce Schuck wrote:

Thanks John.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

Thanks John.

Coincidentally I just managed to install a High Sierra VM under 
VirtualBox on my MacBook w/Catalina.


I'll be taking a look at this soon.

- Bruce S.

On 3/25/23 3:47 PM, John Ralls wrote:

Bruce,

Versions:
Module::Load 0.36
Module::Load::Conditional 0.74
SelfLoader 1.24
AutoLoader 5.74

and for good measure
Perl 5.18.2

I ran perl -d:Trace 
.cpan/build/Finance-Quote-blah-blah/Examples/currency-lookup.pl EUR USD and 
attached the zipped result below. You might see a couple of unfamiliar strings, 
those are from print statements I'd inserted to try to see what was going on.

Regards,
John Ralls





On Mar 23, 2023, at 7:33 PM, Bruce Schuck  wrote:

On 03/23/23 9:21 PM, Bruce Schuck wrote:

What versions of those modules are on the 10.13 OS you have access to?

Can you update Module::Load and test again?

Perl does have two modules, Devel::Trace and Devel::DumpTrace.

I think the output of Devel::Trace may be more useful.

"perl -d:Trace /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency 
EUR USD 2>/tmp/foobar"

It creates a fairly large file, over 300k lines on my Catalina system where it 
is working. Starting on line 246638 I see the call to autoload and subsequent 
perl lines executed.

Just starting it as "perl -d /Applications/..." runs the script in a sort of 
gdb like environment. But I've always debugged using prints to stdout or Smart::Comments.

So if you or whoever is having issues on a High Sierra OS can install install 
Devel::Trace and provide me the output (I checked mine, my ALPHAVANTAGE API key 
is not exposed, but double check your output), I can maybe compare.

Thanks again.

- 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 problem MacOS High Sierra.

[Bruce Schuck]

On 03/23/23 9:21 PM, Bruce Schuck wrote:

What versions of those modules are on the 10.13 OS you have access to?

Can you update Module::Load and test again?

Perl does have two modules, Devel::Trace and Devel::DumpTrace.

I think the output of Devel::Trace may be more useful.

"perl -d:Trace 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency 
EUR USD 2>/tmp/foobar"


It creates a fairly large file, over 300k lines on my Catalina system 
where it is working. Starting on line 246638 I see the call to autoload 
and subsequent perl lines executed.


Just starting it as "perl -d /Applications/..." runs the script in a 
sort of gdb like environment. But I've always debugged using prints to 
stdout or Smart::Comments.


So if you or whoever is having issues on a High Sierra OS can install 
install Devel::Trace and provide me the output (I checked mine, my 
ALPHAVANTAGE API key is not exposed, but double check your output), I 
can maybe compare.


Thanks again.

- 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 problem MacOS High Sierra.

[Bruce Schuck]

On 3/23/23 3:28 PM, John Ralls wrote:


Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in
/Library/Perl/Updates/5.18.2. @INC includes both directories and
neither PERLLIB nor PERL5LIB is set.



No doubt something else is missing in 10.13. What's a good way to get
perl to tell me?


John,

What versions of those modules are on the 10.13 OS you have access to?

Can you update Module::Load and test again?

Thanks.

- Bruce S.


OpenPGP_0xFBCD3E088F8FA737.asc
Description: OpenPGP public key


OpenPGP_signature
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 problem MacOS High Sierra.

[Bruce Schuck]

On 3/23/23 3:28 PM, John Ralls wrote:


Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in
/Library/Perl/Updates/5.18.2. @INC includes both directories and
neither PERLLIB nor PERL5LIB is set.



No doubt something else is missing in 10.13. What's a good way to get
perl to tell me?


If it were Linux I'd say use "strace" and look at all the different Perl 
Modules being opened. OSX has dtrace/dstruss but SIP has to be disabled. 
While I know how to disable it, my MacBook belongs to work and I'd 
rather not.


On the other hand, it *should* be the same modules being utilized 
regardless of OS. It is baffling that Perl just exits quietly instead of 
complaining about a missing module.


- Bruce S.


OpenPGP_0xFBCD3E088F8FA737.asc
Description: OpenPGP public key


OpenPGP_signature
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 problem MacOS High Sierra.

[John Ralls]

I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
>>>>> result
>>>>>   4.  gnc-fq-dump  yahoo_json EURUSD=X
>>>>> Finance::Quote fields Gnucash uses:
>>>>>     symbol: EURUSD=X     <=== required
>>>>>   date: 03/21/2023   <=== recommended
>>>>>   currency: USD  <=== required
>>>>>   last: 1.0779347<=\
>>>>> 
>>>>> i checked if alphavantage was able to get me stock quote in Macbook and 
>>>>> voila it worked perfectly
>>>>> 
>>>>> gnc-fq-dump alphavantage IBM
>>>>> Finance::Quote fields Gnucash uses:
>>>>> symbol: IBM  <=== required
>>>>>   date: 03/20/2023   <=== recommended
>>>>>   currency: USD  <=== required
>>>>>   last: 125.9400 <=\
>>>>>nav:  <=== one of these
>>>>> 
>>>>> 
>>>>> so looks like the issue is particular to currency rates in mac.  I will 
>>>>> raise a bug report
>>>>> 
>>>>> 
>>>>> Saludos Cordiales
>>>>> 
>>>>> 
>>>>> Murugan
>>>>> 
>>>>> 
>>>>> From: gnucash-user 
>>>>>  on behalf 
>>>>> of John Ralls 
>>>>> Sent: Tuesday, March 21, 2023 12:52 AM
>>>>> To: G R Hewitt 
>>>>> Cc: GNU Cash User 
>>>>> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>>>>> 
>>>>> Please remember to copy the list on all replies.
>>>>> 
>>>>> No, what's expected is what I just got,
>>>>> 1 EUR = 1.072271 USD
>>>>> so something is still not right with your F::Q installation.
>>>>> 
>>>>> You should have a .cpan folder (the . hides it from Finder but you can 
>>>>> say `ls ~/.cpan` on the command line to see if it's there), and so you 
>>>>> should be able to run
>>>>> 
>>>>> ALPHAVANTAGE_API_KEY= 
>>>>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>>>>> 
>>>>> which should print EUR->USD = 1.072386
>>>>> 
>>>>> but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think 
>>>>> it will do much for diagnostics beyond that.
>>>>> 
>>>>> Regards,
>>>>> John Ralls
>>>>> 
>>>>>> On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:
>>>>>> 
>>>>>> Hi John,
>>>>>> Ha ha, you got me there, no I didn't, and should have.
>>>>>> I now get:
>>>>>> 1 EUR =  USD
>>>>>> Is that what is expected?
>>>>>> 
>>>>>> Oddly enough, I was being lazy and tried to paste the code over the 
>>>>>> highlighted '' and terminal wasn't having it and put it at the end 
>>>>>> of the line,
>>>>>> which, went sent, returned the same as the above but with my API code 
>>>>>> appended to USA.
>>>>>> 
>>>>>> Just for fun, I sent your original code with the 'x' intact, and 
>>>>>> still got:
>>>>>> 1 EUR =  USD.
>>>>>> 
>>>>>> Puzzling.
>>>>>> 
>>>>>> 
>>>>>> On Mon, 20 Mar 2023 at 16:12, john  wrote:
>>>>>> Did you do the obvious (to me anyway) replacement of  in the example 
>>>>>> with your key?
>>>>>> 
>>>>>> Regards,
>>>>>> John Ralls
>>>>>> 
>>>>>>> On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:
>>>>>>> 
>>>>>>> Hi John,
>>>>>>> I get this:
>>>>>>> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
>>>>>>> stock quotes with source 'alphavantage' or 'vanguard'; see
>>>>>>>  https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
>>>>>>> 
>>>>>>> Thanks
>>>>>>> 
>>>>>>> On Sun, 19 Mar 2023 at 22:22, John Ralls  wrote:
>>>>>>> What results wh

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

Just to confirm. The modules

Load::Module
Load::Module::Conditional
SelfLoader
AutoLoader

are all installed?

I also found that if one has taken of advantage of using the PERL5LIB 
environment to modify the @INC path when installing modules, things can 
get wonky if it's unset. Or if it was when installing some modules, but 
unset when installing others.


I'm guessing the issue on whatever 10.13 system you have tested is still 
a missing module (I was able to reproduce the issue on my Catalina 
system, no complaints about missing module but still just died after the 
autoload call - autoload is function in Module::Load).


On 3/23/23 1:42 PM, John Ralls wrote:

Bruce,

Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land in 
the autoload call.

Regards,
John Ralls



On Mar 21, 2023, at 6:30 PM, Bruce Schuck  wrote:

Please trying installing Module::Load::Conditional from CPAN. It will also 
install Module::Load. If that still does not work, also install modules 
SelfLoader and AutoLoader.

I will need to these to the package dependencies.

- Bruce S.

On 3/21/23 4:05 PM, John Ralls wrote:

It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using 
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test 
on.
It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so 
it's something in Finance::Quote. I've been salting that with print statements to 
try to figure out what's going on and it seems to be failing to load the 
AlphaVantage currency module at Quote.pm line 421: A print before that line prints 
and one immediately after doesn't. At line 805 `$this->{currency_rate_method}` 
is empty so no attempt to get quotes is made.
It seems strange that this would have come up now. Could it be that nobody has 
tried this on an older Mac in a long time?
Regards,
John Ralls

On Mar 21, 2023, at 3:27 PM, David H  wrote:

Murugan,

Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0

Cheers David H.


On Wed, 22 Mar 2023 at 05:49, David H  wrote:
Murugan,

I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my Intel 
MacBook Pro was OK - will double check later and confirm whether that is the 
case.  Also the same command works on Win 11 when formatted correctly :-)  None 
of the tests I ran required a valid AlphaVantage api key, a single x was all 
that was required.

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
EUR->USD = 1.0766


ALPHAVANTAGE_API_KEY=x 
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
currency EUR USD
1 EUR = 1.07678 USD

Cheers David H.


On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam  
wrote:
I fired up my old macbook pro and installed the Finance quote 1.54


   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR USD
   2.  Since i run on windows i tried the same command in Windows and it 
brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i 
have been using it for years and it works for me)
   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
result
   4.  gnc-fq-dump  yahoo_json EURUSD=X
Finance::Quote fields Gnucash uses:
 symbol: EURUSD=X <=== required
   date: 03/21/2023   <=== recommended
   currency: USD  <=== required
   last: 1.0779347<=\

i checked if alphavantage was able to get me stock quote in Macbook and voila 
it worked perfectly

gnc-fq-dump alphavantage IBM
Finance::Quote fields Gnucash uses:
 symbol: IBM  <=== required
   date: 03/20/2023   <=== recommended
   currency: USD  <=== required
   last: 125.9400 <=\
nav:  <=== one of these


so looks like the issue is particular to currency rates in mac.  I will raise a 
bug report


Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of John Ralls 
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt 
Cc: GNU Cash User 
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.

Please remember to copy the list on all replies.

No, what's expected is what I just got,
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.

You should have a .cpan folder (the . hides it from Finder but you can say `ls 
~/.cpan` on the command line to see if it's there), and so you should be able 
to run

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD

which should print EUR->USD = 1.072386

but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
will do much for diagnostics beyond that.

Regards,
John Ralls


On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:

Hi John,
Ha ha, you got

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

Bruce,

Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land in 
the autoload call.

Regards,
John Ralls


> On Mar 21, 2023, at 6:30 PM, Bruce Schuck  wrote:
> 
> Please trying installing Module::Load::Conditional from CPAN. It will also 
> install Module::Load. If that still does not work, also install modules 
> SelfLoader and AutoLoader.
> 
> I will need to these to the package dependencies.
> 
> - Bruce S.
> 
> On 3/21/23 4:05 PM, John Ralls wrote:
>> It works for me on macOS 11 and later and fails on 10.14 and earlier; 
>> Murugan reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that 
>> they're using 10.15, so I guess that's the cutoff. I don't have a 10.15 
>> machine or VM to test on.
>> It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier 
>> so it's something in Finance::Quote. I've been salting that with print 
>> statements to try to figure out what's going on and it seems to be failing 
>> to load the AlphaVantage currency module at Quote.pm line 421: A print 
>> before that line prints and one immediately after doesn't. At line 805 
>> `$this->{currency_rate_method}` is empty so no attempt to get quotes is made.
>> It seems strange that this would have come up now. Could it be that nobody 
>> has tried this on an older Mac in a long time?
>> Regards,
>> John Ralls
>>> On Mar 21, 2023, at 3:27 PM, David H  wrote:
>>> 
>>> Murugan,
>>> 
>>> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Wed, 22 Mar 2023 at 05:49, David H  wrote:
>>> Murugan,
>>> 
>>> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my 
>>> Intel MacBook Pro was OK - will double check later and confirm whether that 
>>> is the case.  Also the same command works on Win 11 when formatted 
>>> correctly :-)  None of the tests I ran required a valid AlphaVantage api 
>>> key, a single x was all that was required.
>>> 
>>> ALPHAVANTAGE_API_KEY= 
>>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>>> EUR->USD = 1.0766
>>> 
>>> 
>>> ALPHAVANTAGE_API_KEY=x 
>>> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>>> currency EUR USD
>>> 1 EUR = 1.07678 USD
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam 
>>>  wrote:
>>> I fired up my old macbook pro and installed the Finance quote 1.54
>>> 
>>> 
>>>   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR 
>>> USD
>>>   2.  Since i run on windows i tried the same command in Windows and it 
>>> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, 
>>> i have been using it for years and it works for me)
>>>   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
>>> result
>>>   4.  gnc-fq-dump  yahoo_json EURUSD=X
>>> Finance::Quote fields Gnucash uses:
>>> symbol: EURUSD=X <=== required
>>>   date: 03/21/2023   <=== recommended
>>>   currency: USD  <=== required
>>>   last: 1.0779347<=\
>>> 
>>> i checked if alphavantage was able to get me stock quote in Macbook and 
>>> voila it worked perfectly
>>> 
>>> gnc-fq-dump alphavantage IBM
>>> Finance::Quote fields Gnucash uses:
>>> symbol: IBM      <=== required
>>>   date: 03/20/2023   <=== recommended
>>>   currency: USD  <=== required
>>>   last: 125.9400 <=\
>>>nav:  <=== one of these
>>> 
>>> 
>>> so looks like the issue is particular to currency rates in mac.  I will 
>>> raise a bug report
>>> 
>>> 
>>> Saludos Cordiales
>>> 
>>> 
>>> Murugan
>>> 
>>> 
>>> From: gnucash-user 
>>>  on behalf of 
>>> John Ralls 
>>> Sent: Tuesday, March 21, 2023 12:52 AM
>>> To: G R Hewitt 
>>> Cc: GNU Cash User 
>>> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>>> 
>>> Please remember to copy the list on all replies.
>>> 
>>> No, what's expected is what I just got,
>>> 1 EUR = 1.072271 USD
>>&

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Murugan Muruganandam]

Bruce, thanks so much you exactly resolved it.  I installed the modules  
Module::Load::Conditional from CPAN and now i am able to fetch rates for 
currency in the application.  I have closed the bug as well.





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Bruce Schuck 
Sent: Tuesday, March 21, 2023 10:30 PM
To: John Ralls ; David H 
Cc: GNU Cash User 
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.

Please trying installing Module::Load::Conditional from CPAN. It will
also install Module::Load. If that still does not work, also install
modules SelfLoader and AutoLoader.

I will need to these to the package dependencies.

- Bruce S.

On 3/21/23 4:05 PM, John Ralls wrote:
> It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
> reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're 
> using 10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM 
> to test on.
>
> It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier 
> so it's something in Finance::Quote. I've been salting that with print 
> statements to try to figure out what's going on and it seems to be failing to 
> load the AlphaVantage currency module at Quote.pm line 421: A print before 
> that line prints and one immediately after doesn't. At line 805 
> `$this->{currency_rate_method}` is empty so no attempt to get quotes is made.
>
> It seems strange that this would have come up now. Could it be that nobody 
> has tried this on an older Mac in a long time?
>
> Regards,
> John Ralls
>
>
>> On Mar 21, 2023, at 3:27 PM, David H  wrote:
>>
>> Murugan,
>>
>> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
>>
>> Cheers David H.
>>
>>
>> On Wed, 22 Mar 2023 at 05:49, David H  wrote:
>> Murugan,
>>
>> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my 
>> Intel MacBook Pro was OK - will double check later and confirm whether that 
>> is the case.  Also the same command works on Win 11 when formatted correctly 
>> :-)  None of the tests I ran required a valid AlphaVantage api key, a single 
>> x was all that was required.
>>
>> ALPHAVANTAGE_API_KEY= 
>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>> EUR->USD = 1.0766
>>
>>
>> ALPHAVANTAGE_API_KEY=x 
>> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> currency EUR USD
>> 1 EUR = 1.07678 USD
>>
>> Cheers David H.
>>
>>
>> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam 
>>  wrote:
>> I fired up my old macbook pro and installed the Finance quote 1.54
>>
>>
>>1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR 
>> USD
>>2.  Since i run on windows i tried the same command in Windows and it 
>> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, 
>> i have been using it for years and it works for me)
>>3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
>> result
>>4.  gnc-fq-dump  yahoo_json EURUSD=X
>> Finance::Quote fields Gnucash uses:
>>  symbol: EURUSD=X <=== required
>>date: 03/21/2023   <=== recommended
>>currency: USD  <=== required
>>last: 1.0779347<=\
>>
>> i checked if alphavantage was able to get me stock quote in Macbook and 
>> voila it worked perfectly
>>
>> gnc-fq-dump alphavantage IBM
>> Finance::Quote fields Gnucash uses:
>>  symbol: IBM  <=== required
>>date: 03/20/2023   <=== recommended
>>currency: USD  <=== required
>>    last: 125.9400         <=\
>> nav:  <=== one of these
>>
>>
>> so looks like the issue is particular to currency rates in mac.  I will 
>> raise a bug report
>>
>>
>> Saludos Cordiales
>>
>>
>> Murugan
>>
>> 
>> From: gnucash-user 
>>  on behalf of 
>> John Ralls 
>> Sent: Tuesday, March 21, 2023 12:52 AM
>> To: G R Hewitt 
>> Cc: GNU Cash User 
>> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>>
>> Please remember to copy the list on all replies.
>>
>> No, what's expected is what I just got,
>> 1 EUR = 1.072271 USD
>> so something is still not right with your F::Q installation.
>>
>> You should have a .cpan folder (the . hides it from Finder 

Re: [GNC] Finance Quote problem MacOS High Sierra.

[R Losey]

Fair enough. I don't think I ever got the Windows version working, and my
iMac effort wasn't great... Linux worked pretty well for me.

When I tried to install all the other "stuff" I needed on Windows, I
*think* it installed, but it still failed to get quotes.


On Mon, Mar 20, 2023 at 11:39 PM David T.  wrote:

> R.,
>
> Generalizations aren't helpful, especially if they aren't fully accurate.
>
> To assert that "one can forget Windows entirely" is contradicted by many
> users' experiences to the contrary. F::Q has worked for me under Windows
> for many years (and on Mac before that).
>
> David T.
> On Mar 20, 2023, at 22:38, R Losey  wrote:
>>
>> I'm impressed that you got this running on the iMac; I only have this
>> working on Linux (and one can forget Windows entirely).
>>
>>
>> On Sun, Mar 19, 2023 at 4:51 PM G R Hewitt  wrote:
>>
>>  Hello everyone,
>>>  Gnucash 4.13
>>>  Finance Quote 1.54
>>>  MacPro 2010 High Sierra
>>>  iMac 2017 Ventura
>>>
>>>  After hours of much aggravation - don't ask ' I eventually got Finance
>>>  Quote 1.54 to install, the 'Get Quotes' button was active and I was well
>>>  pleased with myself.
>>>
>>>  Anyway, on pressing it I got the dismaying message:
>>>  'Unable to retrieve quotes for these items: CURRENCY:EUR'
>>>
>>>  I have searched for answers and found none.
>>>
>>>  Can anyone point me in the right direction, please to solving this.
>>>
>>>  Thanks in advance.
>>> --
>>>
>>>  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.
>>
>>
>>
>>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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 problem MacOS High Sierra.

[Bruce Schuck]

Please trying installing Module::Load::Conditional from CPAN. It will 
also install Module::Load. If that still does not work, also install 
modules SelfLoader and AutoLoader.


I will need to these to the package dependencies.

- Bruce S.

On 3/21/23 4:05 PM, John Ralls wrote:

It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using 
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test 
on.

It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so 
it's something in Finance::Quote. I've been salting that with print statements to 
try to figure out what's going on and it seems to be failing to load the 
AlphaVantage currency module at Quote.pm line 421: A print before that line prints 
and one immediately after doesn't. At line 805 `$this->{currency_rate_method}` 
is empty so no attempt to get quotes is made.

It seems strange that this would have come up now. Could it be that nobody has 
tried this on an older Mac in a long time?

Regards,
John Ralls



On Mar 21, 2023, at 3:27 PM, David H  wrote:

Murugan,

Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0

Cheers David H.


On Wed, 22 Mar 2023 at 05:49, David H  wrote:
Murugan,

I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my Intel 
MacBook Pro was OK - will double check later and confirm whether that is the 
case.  Also the same command works on Win 11 when formatted correctly :-)  None 
of the tests I ran required a valid AlphaVantage api key, a single x was all 
that was required.

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
EUR->USD = 1.0766


ALPHAVANTAGE_API_KEY=x 
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
currency EUR USD
1 EUR = 1.07678 USD

Cheers David H.


On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam  
wrote:
I fired up my old macbook pro and installed the Finance quote 1.54


   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR USD
   2.  Since i run on windows i tried the same command in Windows and it 
brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i 
have been using it for years and it works for me)
   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
result
   4.  gnc-fq-dump  yahoo_json EURUSD=X
Finance::Quote fields Gnucash uses:
 symbol: EURUSD=X <=== required
   date: 03/21/2023   <=== recommended
   currency: USD  <=== required
   last: 1.0779347<=\

i checked if alphavantage was able to get me stock quote in Macbook and voila 
it worked perfectly

gnc-fq-dump alphavantage IBM
Finance::Quote fields Gnucash uses:
 symbol: IBM  <=== required
   date: 03/20/2023   <=== recommended
   currency: USD  <=== required
   last: 125.9400 <=\
nav:  <=== one of these


so looks like the issue is particular to currency rates in mac.  I will raise a 
bug report


Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of John Ralls 
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt 
Cc: GNU Cash User 
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.

Please remember to copy the list on all replies.

No, what's expected is what I just got,
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.

You should have a .cpan folder (the . hides it from Finder but you can say `ls 
~/.cpan` on the command line to see if it's there), and so you should be able 
to run

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD

which should print EUR->USD = 1.072386

but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
will do much for diagnostics beyond that.

Regards,
John Ralls


On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:

Hi John,
Ha ha, you got me there, no I didn't, and should have.
I now get:
1 EUR =  USD
Is that what is expected?

Oddly enough, I was being lazy and tried to paste the code over the highlighted 
'' and terminal wasn't having it and put it at the end of the line,
which, went sent, returned the same as the above but with my API code appended 
to USA.

Just for fun, I sent your original code with the 'x' intact, and still got:
1 EUR =  USD.

Puzzling.


On Mon, 20 Mar 2023 at 16:12, john  wrote:
Did you do the obvious (to me anyway) replacement of  in the example with 
your key?

Regards,
John Ralls


On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:

Hi John,
I get this:
ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
stock quotes with source 'alphavantage' or 'vanguard'; see
  https://wiki.gnucash.org/wiki/Online_Quotes#Source_A

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

Yes. No Homebrew version installed on this Macbook.

Version of GnuCash is Build ID: 4.8a+(2021-09-28).

I can try taking a look at the code anyway in the next couple days, but 
I have no way of testing OSX versions 10.14 and lower.


- Bruce S.

On 3/21/23 4:42 PM, John Ralls wrote:

Bruce,

Are you using "stock" perl?

Regards,
John Ralls



On Mar 21, 2023, at 4:31 PM, Bruce Schuck  wrote:

I hate to say this, but it works fine on my Mac OSX 10.15.7 (Catalina).

bruce.schuck@Bruces-MacBook-Pro-2 F5 % sw_vers
ProductName:Mac OS X
ProductVersion: 10.15.7
BuildVersion:   19H2026

bruce.schuck@Bruces-MacBook-Pro-2 ~ % gnc-fq-check
("1.54" "aex" ...

bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency EUR USD
1 EUR = 1.077354 USD

bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency USD EUR
1 USD = 0.9282 EUR

I also do not have access to a 10.14 system/VM.

FYI - there is a bug in AlphaVantage's check for an API key. Almost any strings works as their 
"free" key (just don't use "demo").

- Bruce S.

On 3/21/23 4:05 PM, John Ralls wrote:

It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using 
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test 
on.
It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so 
it's something in Finance::Quote. I've been salting that with print statements to 
try to figure out what's going on and it seems to be failing to load the 
AlphaVantage currency module at Quote.pm line 421: A print before that line prints 
and one immediately after doesn't. At line 805 `$this->{currency_rate_method}` 
is empty so no attempt to get quotes is made.
It seems strange that this would have come up now. Could it be that nobody has 
tried this on an older Mac in a long time?
Regards,
John Ralls

On Mar 21, 2023, at 3:27 PM, David H  wrote:

Murugan,

Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0

Cheers David H.


On Wed, 22 Mar 2023 at 05:49, David H  wrote:
Murugan,

I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my Intel 
MacBook Pro was OK - will double check later and confirm whether that is the 
case.  Also the same command works on Win 11 when formatted correctly :-)  None 
of the tests I ran required a valid AlphaVantage api key, a single x was all 
that was required.

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
EUR->USD = 1.0766


ALPHAVANTAGE_API_KEY=x 
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
currency EUR USD
1 EUR = 1.07678 USD

Cheers David H.


On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam  
wrote:
I fired up my old macbook pro and installed the Finance quote 1.54


   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR USD
   2.  Since i run on windows i tried the same command in Windows and it 
brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i 
have been using it for years and it works for me)
   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
result
   4.  gnc-fq-dump  yahoo_json EURUSD=X
Finance::Quote fields Gnucash uses:
 symbol: EURUSD=X <=== required
   date: 03/21/2023   <=== recommended
   currency: USD  <=== required
   last: 1.0779347<=\

i checked if alphavantage was able to get me stock quote in Macbook and voila 
it worked perfectly

gnc-fq-dump alphavantage IBM
Finance::Quote fields Gnucash uses:
 symbol: IBM  <=== required
   date: 03/20/2023   <=== recommended
   currency: USD  <=== required
   last: 125.9400 <=\
nav:  <=== one of these


so looks like the issue is particular to currency rates in mac.  I will raise a 
bug report


Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of John Ralls 
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt 
Cc: GNU Cash User 
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.

Please remember to copy the list on all replies.

No, what's expected is what I just got,
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.

You should have a .cpan folder (the . hides it from Finder but you can say `ls 
~/.cpan` on the command line to see if it's there), and so you should be able 
to run

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD

which should print EUR->USD = 1.072386

but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
will do much for diagnostics beyond that.

Regards,
John Ralls


On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:

Hi John,
Ha ha, you got 

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

Bruce,

Are you using "stock" perl?

Regards,
John Ralls


> On Mar 21, 2023, at 4:31 PM, Bruce Schuck  wrote:
> 
> I hate to say this, but it works fine on my Mac OSX 10.15.7 (Catalina).
> 
> bruce.schuck@Bruces-MacBook-Pro-2 F5 % sw_vers
> ProductName:  Mac OS X
> ProductVersion:   10.15.7
> BuildVersion: 19H2026
> 
> bruce.schuck@Bruces-MacBook-Pro-2 ~ % gnc-fq-check
> ("1.54" "aex" ...
> 
> bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency EUR USD
> 1 EUR = 1.077354 USD
> 
> bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency USD EUR
> 1 USD = 0.9282 EUR
> 
> I also do not have access to a 10.14 system/VM.
> 
> FYI - there is a bug in AlphaVantage's check for an API key. Almost any 
> strings works as their "free" key (just don't use "demo").
> 
> - Bruce S.
> 
> On 3/21/23 4:05 PM, John Ralls wrote:
>> It works for me on macOS 11 and later and fails on 10.14 and earlier; 
>> Murugan reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that 
>> they're using 10.15, so I guess that's the cutoff. I don't have a 10.15 
>> machine or VM to test on.
>> It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier 
>> so it's something in Finance::Quote. I've been salting that with print 
>> statements to try to figure out what's going on and it seems to be failing 
>> to load the AlphaVantage currency module at Quote.pm line 421: A print 
>> before that line prints and one immediately after doesn't. At line 805 
>> `$this->{currency_rate_method}` is empty so no attempt to get quotes is made.
>> It seems strange that this would have come up now. Could it be that nobody 
>> has tried this on an older Mac in a long time?
>> Regards,
>> John Ralls
>>> On Mar 21, 2023, at 3:27 PM, David H  wrote:
>>> 
>>> Murugan,
>>> 
>>> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Wed, 22 Mar 2023 at 05:49, David H  wrote:
>>> Murugan,
>>> 
>>> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my 
>>> Intel MacBook Pro was OK - will double check later and confirm whether that 
>>> is the case.  Also the same command works on Win 11 when formatted 
>>> correctly :-)  None of the tests I ran required a valid AlphaVantage api 
>>> key, a single x was all that was required.
>>> 
>>> ALPHAVANTAGE_API_KEY= 
>>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>>> EUR->USD = 1.0766
>>> 
>>> 
>>> ALPHAVANTAGE_API_KEY=x 
>>> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>>> currency EUR USD
>>> 1 EUR = 1.07678 USD
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam 
>>>  wrote:
>>> I fired up my old macbook pro and installed the Finance quote 1.54
>>> 
>>> 
>>>   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR 
>>> USD
>>>   2.  Since i run on windows i tried the same command in Windows and it 
>>> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, 
>>> i have been using it for years and it works for me)
>>>   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
>>> result
>>>   4.  gnc-fq-dump  yahoo_json EURUSD=X
>>> Finance::Quote fields Gnucash uses:
>>> symbol: EURUSD=X <=== required
>>>   date: 03/21/2023   <=== recommended
>>>   currency: USD  <=== required
>>>   last: 1.0779347<=\
>>> 
>>> i checked if alphavantage was able to get me stock quote in Macbook and 
>>> voila it worked perfectly
>>> 
>>> gnc-fq-dump alphavantage IBM
>>> Finance::Quote fields Gnucash uses:
>>> symbol: IBM  <=== required
>>>   date: 03/20/2023   <=== recommended
>>>   currency: USD  <=== required
>>>   last: 125.9400 <=\
>>>nav:  <=== one of these
>>> 
>>> 
>>> so looks like the issue is particular to currency rates in mac.  I will 
>>> raise a bug report
>>> 
>>> 
>>> Saludos Cordiales
>>> 
>>> 
>>> Murugan
>>> 
>>> ___

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

According to 
https://everymac.com/systems/by_capability/maximum-macos-supported.html 2010 
and 2011 MBPs maxed out on High Sierra (10.13); 2012s and 2013s on 10.15. You'd 
need at least a 2014 to run 11 or later.

Regards,
John Ralls
 
> On Mar 21, 2023, at 4:26 PM, David H  wrote:
> 
> Probably, don't think the 2010 MacBook Pro OS is upgradable from High Sierra 
> ? but it should work on GR's iMac 2017 Ventura.
> 
> Cheers David H.
> 
> On Wed, 22 Mar 2023 at 09:06, John Ralls  wrote:
> It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
> reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're 
> using 10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM 
> to test on.
> 
> It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier 
> so it's something in Finance::Quote. I've been salting that with print 
> statements to try to figure out what's going on and it seems to be failing to 
> load the AlphaVantage currency module at Quote.pm line 421: A print before 
> that line prints and one immediately after doesn't. At line 805 
> `$this->{currency_rate_method}` is empty so no attempt to get quotes is made.
> 
> It seems strange that this would have come up now. Could it be that nobody 
> has tried this on an older Mac in a long time?
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 21, 2023, at 3:27 PM, David H  wrote:
> > 
> > Murugan,
> > 
> > Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
> > 
> > Cheers David H.
> > 
> > 
> > On Wed, 22 Mar 2023 at 05:49, David H  wrote:
> > Murugan,
> > 
> > I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my 
> > Intel MacBook Pro was OK - will double check later and confirm whether that 
> > is the case.  Also the same command works on Win 11 when formatted 
> > correctly :-)  None of the tests I ran required a valid AlphaVantage api 
> > key, a single x was all that was required.
> > 
> > ALPHAVANTAGE_API_KEY= 
> > .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
> > EUR->USD = 1.0766
> > 
> > 
> > ALPHAVANTAGE_API_KEY=x 
> > /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> > currency EUR USD 
> > 1 EUR = 1.07678 USD
> > 
> > Cheers David H.
> > 
> > 
> > On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam 
> >  wrote:
> > I fired up my old macbook pro and installed the Finance quote 1.54
> > 
> > 
> >   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR 
> > USD
> >   2.  Since i run on windows i tried the same command in Windows and it 
> > brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, 
> > i have been using it for years and it works for me)
> >   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
> > result
> >   4.  gnc-fq-dump  yahoo_json EURUSD=X
> > Finance::Quote fields Gnucash uses:
> > symbol: EURUSD=X <=== required
> >   date: 03/21/2023   <=== recommended
> >   currency: USD  <=== required
> >   last: 1.0779347<=\
> > 
> > i checked if alphavantage was able to get me stock quote in Macbook and 
> > voila it worked perfectly
> > 
> > gnc-fq-dump alphavantage IBM
> > Finance::Quote fields Gnucash uses:
> > symbol: IBM  <=== required
> >   date: 03/20/2023   <=== recommended
> >   currency: USD  <=== required
> >       last: 125.9400     <=\
> >nav:  <=== one of these
> > 
> > 
> > so looks like the issue is particular to currency rates in mac.  I will 
> > raise a bug report
> > 
> > 
> > Saludos Cordiales
> > 
> > 
> > Murugan
> > 
> > 
> > From: gnucash-user 
> >  on behalf of 
> > John Ralls 
> > Sent: Tuesday, March 21, 2023 12:52 AM
> > To: G R Hewitt 
> > Cc: GNU Cash User 
> > Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
> > 
> > Please remember to copy the list on all replies.
> > 
> > No, what's expected is what I just got,
> > 1 EUR = 1.072271 USD
> > so something is still not right with your F::Q installation.
> > 
> > You should have a .cpan folder (the . hides it from Finder but you can say 
> > `ls ~/.cpan` on the command line to see if it's there), and so you should 
> > be able to run
&g

Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

I hate to say this, but it works fine on my Mac OSX 10.15.7 (Catalina).

bruce.schuck@Bruces-MacBook-Pro-2 F5 % sw_vers
ProductName:Mac OS X
ProductVersion: 10.15.7
BuildVersion:   19H2026

bruce.schuck@Bruces-MacBook-Pro-2 ~ % gnc-fq-check
("1.54" "aex" ...

bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency EUR USD
1 EUR = 1.077354 USD

bruce.schuck@Bruces-MacBook-Pro-2 F5 % gnc-fq-dump -v currency USD EUR
1 USD = 0.9282 EUR

I also do not have access to a 10.14 system/VM.

FYI - there is a bug in AlphaVantage's check for an API key. Almost any 
strings works as their "free" key (just don't use "demo").


- Bruce S.

On 3/21/23 4:05 PM, John Ralls wrote:

It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using 
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test 
on.

It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so 
it's something in Finance::Quote. I've been salting that with print statements to 
try to figure out what's going on and it seems to be failing to load the 
AlphaVantage currency module at Quote.pm line 421: A print before that line prints 
and one immediately after doesn't. At line 805 `$this->{currency_rate_method}` 
is empty so no attempt to get quotes is made.

It seems strange that this would have come up now. Could it be that nobody has 
tried this on an older Mac in a long time?

Regards,
John Ralls



On Mar 21, 2023, at 3:27 PM, David H  wrote:

Murugan,

Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0

Cheers David H.


On Wed, 22 Mar 2023 at 05:49, David H  wrote:
Murugan,

I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my Intel 
MacBook Pro was OK - will double check later and confirm whether that is the 
case.  Also the same command works on Win 11 when formatted correctly :-)  None 
of the tests I ran required a valid AlphaVantage api key, a single x was all 
that was required.

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
EUR->USD = 1.0766


ALPHAVANTAGE_API_KEY=x 
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
currency EUR USD
1 EUR = 1.07678 USD

Cheers David H.


On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam  
wrote:
I fired up my old macbook pro and installed the Finance quote 1.54


   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR USD
   2.  Since i run on windows i tried the same command in Windows and it 
brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i 
have been using it for years and it works for me)
   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
result
   4.  gnc-fq-dump  yahoo_json EURUSD=X
Finance::Quote fields Gnucash uses:
 symbol: EURUSD=X <=== required
   date: 03/21/2023   <=== recommended
   currency: USD  <=== required
   last: 1.0779347<=\

i checked if alphavantage was able to get me stock quote in Macbook and voila 
it worked perfectly

gnc-fq-dump alphavantage IBM
Finance::Quote fields Gnucash uses:
 symbol: IBM  <=== required
   date: 03/20/2023   <=== recommended
   currency: USD  <=== required
   last: 125.9400 <=\
nav:  <=== one of these


so looks like the issue is particular to currency rates in mac.  I will raise a 
bug report


Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of John Ralls 
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt 
Cc: GNU Cash User 
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.

Please remember to copy the list on all replies.

No, what's expected is what I just got,
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.

You should have a .cpan folder (the . hides it from Finder but you can say `ls 
~/.cpan` on the command line to see if it's there), and so you should be able 
to run

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD

which should print EUR->USD = 1.072386

but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
will do much for diagnostics beyond that.

Regards,
John Ralls


On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:

Hi John,
Ha ha, you got me there, no I didn't, and should have.
I now get:
1 EUR =  USD
Is that what is expected?

Oddly enough, I was being lazy and tried to paste the code over the highlighted 
'' and terminal wasn't having it and put it at the end of the line,
which, went sent, returned the same as the above but with my API code appended 
to USA.

Just for fun, I sent your original code with the 'x' intact, and st

Re: [GNC] Finance Quote problem MacOS High Sierra.

[David H]

Probably, don't think the 2010 MacBook Pro OS is upgradable from High
Sierra ? but it should work on GR's iMac 2017 Ventura.

Cheers David H.

On Wed, 22 Mar 2023 at 09:06, John Ralls  wrote:

> It works for me on macOS 11 and later and fails on 10.14 and earlier;
> Murugan reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that
> they're using 10.15, so I guess that's the cutoff. I don't have a 10.15
> machine or VM to test on.
>
> It demonstrates with the Examples/currency_rates.pl I pointed GR at
> earlier so it's something in Finance::Quote. I've been salting that with
> print statements to try to figure out what's going on and it seems to be
> failing to load the AlphaVantage currency module at Quote.pm line 421: A
> print before that line prints and one immediately after doesn't. At line
> 805 `$this->{currency_rate_method}` is empty so no attempt to get quotes is
> made.
>
> It seems strange that this would have come up now. Could it be that nobody
> has tried this on an older Mac in a long time?
>
> Regards,
> John Ralls
>
>
> > On Mar 21, 2023, at 3:27 PM, David H  wrote:
> >
> > Murugan,
> >
> > Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
> >
> > Cheers David H.
> >
> >
> > On Wed, 22 Mar 2023 at 05:49, David H  wrote:
> > Murugan,
> >
> > I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my
> Intel MacBook Pro was OK - will double check later and confirm whether that
> is the case.  Also the same command works on Win 11 when formatted
> correctly :-)  None of the tests I ran required a valid AlphaVantage api
> key, a single x was all that was required.
> >
> > ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
> currency-lookup.pl EUR USD
> > EUR->USD = 1.0766
> >
> >
> > ALPHAVANTAGE_API_KEY=x
> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> currency EUR USD
> > 1 EUR = 1.07678 USD
> >
> > Cheers David H.
> >
> >
> > On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
> > I fired up my old macbook pro and installed the Finance quote 1.54
> >
> >
> >   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency
> EUR USD
> >   2.  Since i run on windows i tried the same command in Windows and it
> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows,
> i have been using it for years and it works for me)
> >   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the
> exact result
> >   4.  gnc-fq-dump  yahoo_json EURUSD=X
> > Finance::Quote fields Gnucash uses:
> > symbol: EURUSD=X <=== required
> >   date: 03/21/2023   <=== recommended
> >   currency: USD  <=== required
> >   last: 1.0779347<=\
> >
> > i checked if alphavantage was able to get me stock quote in Macbook and
> voila it worked perfectly
> >
> > gnc-fq-dump alphavantage IBM
> > Finance::Quote fields Gnucash uses:
> > symbol: IBM  <=== required
> >   date: 03/20/2023   <=== recommended
> >   currency: USD  <=== required
> >   last: 125.9400 <=\
> >    nav:          <=== one of these
> >
> >
> > so looks like the issue is particular to currency rates in mac.  I will
> raise a bug report
> >
> >
> > Saludos Cordiales
> >
> >
> > Murugan
> >
> > 
> > From: gnucash-user  hotmail@gnucash.org> on behalf of John Ralls 
> > Sent: Tuesday, March 21, 2023 12:52 AM
> > To: G R Hewitt 
> > Cc: GNU Cash User 
> > Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
> >
> > Please remember to copy the list on all replies.
> >
> > No, what's expected is what I just got,
> > 1 EUR = 1.072271 USD
> > so something is still not right with your F::Q installation.
> >
> > You should have a .cpan folder (the . hides it from Finder but you can
> say `ls ~/.cpan` on the command line to see if it's there), and so you
> should be able to run
> >
> > ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
> currency-lookup.pl EUR USD
> >
> > which should print EUR->USD = 1.072386
> >
> > but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think
> it will do much for diagnostics beyond that.
> >
> > Regards,
> > John Ralls
> >
> > > On Mar 2

Re: [GNC] Finance Quote problem MacOS High Sierra.

[John Ralls]

It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan 
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using 
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test 
on.

It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so 
it's something in Finance::Quote. I've been salting that with print statements 
to try to figure out what's going on and it seems to be failing to load the 
AlphaVantage currency module at Quote.pm line 421: A print before that line 
prints and one immediately after doesn't. At line 805 
`$this->{currency_rate_method}` is empty so no attempt to get quotes is made.

It seems strange that this would have come up now. Could it be that nobody has 
tried this on an older Mac in a long time?

Regards,
John Ralls


> On Mar 21, 2023, at 3:27 PM, David H  wrote:
> 
> Murugan,
> 
> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
> 
> Cheers David H.
> 
> 
> On Wed, 22 Mar 2023 at 05:49, David H  wrote:
> Murugan,
> 
> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my 
> Intel MacBook Pro was OK - will double check later and confirm whether that 
> is the case.  Also the same command works on Win 11 when formatted correctly 
> :-)  None of the tests I ran required a valid AlphaVantage api key, a single 
> x was all that was required.
> 
> ALPHAVANTAGE_API_KEY= 
> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
> EUR->USD = 1.0766
> 
> 
> ALPHAVANTAGE_API_KEY=x 
> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> currency EUR USD 
> 1 EUR = 1.07678 USD
> 
> Cheers David H.
> 
> 
> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam 
>  wrote:
> I fired up my old macbook pro and installed the Finance quote 1.54
> 
> 
>   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency EUR 
> USD
>   2.  Since i run on windows i tried the same command in Windows and it 
> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i 
> have been using it for years and it works for me)
>   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact 
> result
>   4.  gnc-fq-dump  yahoo_json EURUSD=X
> Finance::Quote fields Gnucash uses:
> symbol: EURUSD=X <=== required
>   date: 03/21/2023   <=== recommended
>   currency: USD  <=== required
>   last: 1.0779347<=\
> 
> i checked if alphavantage was able to get me stock quote in Macbook and voila 
> it worked perfectly
> 
> gnc-fq-dump alphavantage IBM
> Finance::Quote fields Gnucash uses:
> symbol: IBM  <=== required
>   date: 03/20/2023   <=== recommended
>   currency: USD  <=== required
>   last: 125.9400 <=\
>nav:  <=== one of these
> 
> 
> so looks like the issue is particular to currency rates in mac.  I will raise 
> a bug report
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> John Ralls 
> Sent: Tuesday, March 21, 2023 12:52 AM
> To: G R Hewitt 
> Cc: GNU Cash User 
> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
> 
> Please remember to copy the list on all replies.
> 
> No, what's expected is what I just got,
> 1 EUR = 1.072271 USD
> so something is still not right with your F::Q installation.
> 
> You should have a .cpan folder (the . hides it from Finder but you can say 
> `ls ~/.cpan` on the command line to see if it's there), and so you should be 
> able to run
> 
> ALPHAVANTAGE_API_KEY= 
> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
> 
> which should print EUR->USD = 1.072386
> 
> but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
> will do much for diagnostics beyond that.
> 
> Regards,
> John Ralls
> 
> > On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:
> >
> > Hi John,
> > Ha ha, you got me there, no I didn't, and should have.
> > I now get:
> > 1 EUR =  USD
> > Is that what is expected?
> >
> > Oddly enough, I was being lazy and tried to paste the code over the 
> > highlighted '' and terminal wasn't having it and put it at the end of 
> > the line,
> > which, went sent, returned the same as the above but with my API code 
> > appended to USA.
> >
> > Just for fun, I sent your original code with the 'x' intact, and still 
> > got:
> > 1 EUR =  USD.
> >
> > Puzzling.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[David H]

Murugan,

Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0

Cheers David H.


On Wed, 22 Mar 2023 at 05:49, David H  wrote:

> Murugan,
>
> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my
> Intel MacBook Pro was OK - will double check later and confirm whether that
> is the case.  Also the same command works on Win 11 when formatted
> correctly :-)  None of the tests I ran required a valid AlphaVantage api
> key, a single x was all that was required.
>
> ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
> currency-lookup.pl EUR USD
>
> EUR->USD = 1.0766
>
>
>
> ALPHAVANTAGE_API_KEY=x
> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> currency EUR USD
>
> 1 EUR = 1.07678 USD
>
>
> Cheers David H.
>
>
>
> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
>
>> I fired up my old macbook pro and installed the Finance quote 1.54
>>
>>
>>   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency
>> EUR USD
>>   2.  Since i run on windows i tried the same command in Windows and it
>> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows,
>> i have been using it for years and it works for me)
>>   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact
>> result
>>   4.  gnc-fq-dump  yahoo_json EURUSD=X
>> Finance::Quote fields Gnucash uses:
>> symbol: EURUSD=X <=== required
>>   date: 03/21/2023   <=== recommended
>>   currency: USD  <=== required
>>   last: 1.0779347<=\
>>
>> i checked if alphavantage was able to get me stock quote in Macbook and
>> voila it worked perfectly
>>
>> gnc-fq-dump alphavantage IBM
>> Finance::Quote fields Gnucash uses:
>> symbol: IBM  <=== required
>>   date: 03/20/2023   <=== recommended
>>   currency: USD  <=== required
>>   last: 125.9400 <=\
>>nav:  <=== one of these
>>
>>
>> so looks like the issue is particular to currency rates in mac.  I will
>> raise a bug report
>>
>>
>> Saludos Cordiales
>>
>>
>> Murugan
>>
>> 
>> From: gnucash-user > hotmail@gnucash.org> on behalf of John Ralls 
>> Sent: Tuesday, March 21, 2023 12:52 AM
>> To: G R Hewitt 
>> Cc: GNU Cash User 
>> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>>
>> Please remember to copy the list on all replies.
>>
>> No, what's expected is what I just got,
>> 1 EUR = 1.072271 USD
>> so something is still not right with your F::Q installation.
>>
>> You should have a .cpan folder (the . hides it from Finder but you can
>> say `ls ~/.cpan` on the command line to see if it's there), and so you
>> should be able to run
>>
>> ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
>> currency-lookup.pl EUR USD
>>
>> which should print EUR->USD = 1.072386
>>
>> but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think
>> it will do much for diagnostics beyond that.
>>
>> Regards,
>> John Ralls
>>
>> > On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:
>> >
>> > Hi John,
>> > Ha ha, you got me there, no I didn't, and should have.
>> > I now get:
>> > 1 EUR =  USD
>> > Is that what is expected?
>> >
>> > Oddly enough, I was being lazy and tried to paste the code over the
>> highlighted '' and terminal wasn't having it and put it at the end of
>> the line,
>> > which, went sent, returned the same as the above but with my API code
>> appended to USA.
>> >
>> > Just for fun, I sent your original code with the 'x' intact, and
>> still got:
>> > 1 EUR =  USD.
>> >
>> > Puzzling.
>> >
>> >
>> > On Mon, 20 Mar 2023 at 16:12, john  wrote:
>> > Did you do the obvious (to me anyway) replacement of  in the
>> example with your key?
>> >
>> > Regards,
>> > John Ralls
>> >
>> >> On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:
>> >>
>> >> Hi John,
>> >> I get this:
>> >> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
>> >> stock quotes with source 'alphavantage' or 'vanguard'; see
>&

Re: [GNC] Finance Quote problem MacOS High Sierra.

[David H]

Murugan,

I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my
Intel MacBook Pro was OK - will double check later and confirm whether that
is the case.  Also the same command works on Win 11 when formatted
correctly :-)  None of the tests I ran required a valid AlphaVantage api
key, a single x was all that was required.

ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
currency-lookup.pl EUR USD

EUR->USD = 1.0766



ALPHAVANTAGE_API_KEY=x
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
currency EUR USD

1 EUR = 1.07678 USD


Cheers David H.



On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> I fired up my old macbook pro and installed the Finance quote 1.54
>
>
>   1.  i go the same issue of 1 EUR =  USD gnc-fq-dump currency
> EUR USD
>   2.  Since i run on windows i tried the same command in Windows and it
> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows,
> i have been using it for years and it works for me)
>   3.   I checked using gnc-fq-dump  yahoo_json USDEUR=X and got the exact
> result
>   4.  gnc-fq-dump  yahoo_json EURUSD=X
> Finance::Quote fields Gnucash uses:
> symbol: EURUSD=X <=== required
>   date: 03/21/2023   <=== recommended
>   currency: USD  <=== required
>   last: 1.0779347<=\
>
> i checked if alphavantage was able to get me stock quote in Macbook and
> voila it worked perfectly
>
> gnc-fq-dump alphavantage IBM
> Finance::Quote fields Gnucash uses:
> symbol: IBM  <=== required
>   date: 03/20/2023   <=== recommended
>   currency: USD  <=== required
>   last: 125.9400 <=\
>nav:  <=== one of these
>
>
> so looks like the issue is particular to currency rates in mac.  I will
> raise a bug report
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail....@gnucash.org> on behalf of John Ralls 
> Sent: Tuesday, March 21, 2023 12:52 AM
> To: G R Hewitt 
> Cc: GNU Cash User 
> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>
> Please remember to copy the list on all replies.
>
> No, what's expected is what I just got,
> 1 EUR = 1.072271 USD
> so something is still not right with your F::Q installation.
>
> You should have a .cpan folder (the . hides it from Finder but you can say
> `ls ~/.cpan` on the command line to see if it's there), and so you should
> be able to run
>
> ALPHAVANTAGE_API_KEY= .cpan/build/Finance-Quote-1.54-0/Examples/
> currency-lookup.pl EUR USD
>
> which should print EUR->USD = 1.072386
>
> but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think
> it will do much for diagnostics beyond that.
>
> Regards,
> John Ralls
>
> > On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:
> >
> > Hi John,
> > Ha ha, you got me there, no I didn't, and should have.
> > I now get:
> > 1 EUR =  USD
> > Is that what is expected?
> >
> > Oddly enough, I was being lazy and tried to paste the code over the
> highlighted '' and terminal wasn't having it and put it at the end of
> the line,
> > which, went sent, returned the same as the above but with my API code
> appended to USA.
> >
> > Just for fun, I sent your original code with the 'x' intact, and
> still got:
> > 1 EUR =  USD.
> >
> > Puzzling.
> >
> >
> > On Mon, 20 Mar 2023 at 16:12, john  wrote:
> > Did you do the obvious (to me anyway) replacement of  in the example
> with your key?
> >
> > Regards,
> > John Ralls
> >
> >> On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:
> >>
> >> Hi John,
> >> I get this:
> >> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
> >> stock quotes with source 'alphavantage' or 'vanguard'; see
> >>  https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
> >>
> >> Thanks
> >>
> >> On Sun, 19 Mar 2023 at 22:22, John Ralls  wrote:
> >> What results when you try from the command line, e.g.
> >>   ALPHAVANTAGE_API_KEY=
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency
> EUR USD
> >> ?
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
> >>
> >>
> >> > On Mar 19, 2023, at 3:17 PM, G R Hewitt  wrote:
> >> >
> >> > Hi John,
> >> > Thanks f

Re: [GNC] Finance Quote problem MacOS High Sierra.

[David T. via gnucash-user]

R.,

Generalizations aren't helpful, especially if they aren't fully accurate.

To assert that "one can forget Windows entirely" is contradicted by many users' 
experiences to the contrary. F::Q has worked for me under Windows for many 
years (and on Mac before that).
⁣
David T.​

On Mar 20, 2023, 22:38, at 22:38, R Losey  wrote:
>I'm impressed that you got this running on the iMac; I only have this
>working on Linux (and one can forget Windows entirely).
>
>
>On Sun, Mar 19, 2023 at 4:51 PM G R Hewitt  wrote:
>
>> Hello everyone,
>> Gnucash 4.13
>> Finance Quote 1.54
>> MacPro 2010 High Sierra
>> iMac 2017 Ventura
>>
>> After hours of much aggravation - don't ask ' I eventually got
>Finance
>> Quote 1.54 to install, the 'Get Quotes' button was active and I was
>well
>> pleased with myself.
>>
>> Anyway, on pressing it I got the dismaying message:
>> 'Unable to retrieve quotes for these items: CURRENCY:EUR'
>>
>> I have searched for answers and found none.
>>
>> Can anyone point me in the right direction, please to solving this.
>>
>> Thanks in advance.
>> ___
>> 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.
>>
>
>
>-- 
>_
>Richard Losey
>rlo...@gmail.com
>Micah 6:8
>___
>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 problem MacOS High Sierra.

[John Ralls]

Please remember to copy the list on all replies.

No, what's expected is what I just got, 
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.

You should have a .cpan folder (the . hides it from Finder but you can say `ls 
~/.cpan` on the command line to see if it's there), and so you should be able 
to run 

ALPHAVANTAGE_API_KEY= 
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD

which should print EUR->USD = 1.072386

but may say "Urgh!  Nothing back\n" instead. Unfortunately I don't think it 
will do much for diagnostics beyond that.

Regards,
John Ralls

> On Mar 20, 2023, at 10:15 AM, G R Hewitt  wrote:
> 
> Hi John,
> Ha ha, you got me there, no I didn't, and should have.
> I now get:
> 1 EUR =  USD
> Is that what is expected?
> 
> Oddly enough, I was being lazy and tried to paste the code over the 
> highlighted '' and terminal wasn't having it and put it at the end of the 
> line,
> which, went sent, returned the same as the above but with my API code 
> appended to USA.
> 
> Just for fun, I sent your original code with the 'x' intact, and still 
> got:
> 1 EUR =  USD.
> 
> Puzzling.
> 
> 
> On Mon, 20 Mar 2023 at 16:12, john  wrote:
> Did you do the obvious (to me anyway) replacement of  in the example with 
> your key?
> 
> Regards,
> John Ralls
> 
>> On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:
>> 
>> Hi John,
>> I get this:
>> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
>> stock quotes with source 'alphavantage' or 'vanguard'; see
>>  https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
>> 
>> Thanks
>> 
>> On Sun, 19 Mar 2023 at 22:22, John Ralls  wrote:
>> What results when you try from the command line, e.g.
>>   ALPHAVANTAGE_API_KEY= 
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency EUR 
>> USD
>> ?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>> 
>> > On Mar 19, 2023, at 3:17 PM, G R Hewitt  wrote:
>> > 
>> > Hi John,
>> > Thanks for getting back.
>> > Yes I do, and I just checked, it is still there.
>> > 
>> > 
>> > On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:
>> > Do you have an alphavantage api key?
>> > 
>> > Regards,
>> > John Ralls
>> > 
>> > 
>> > > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
>> > > 
>> > > Hello everyone,
>> > > Gnucash 4.13
>> > > Finance Quote 1.54
>> > > MacPro 2010 High Sierra
>> > > iMac 2017 Ventura
>> > > 
>> > > After hours of much aggravation - don't ask ' I eventually got Finance
>> > > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
>> > > pleased with myself.
>> > > 
>> > > Anyway, on pressing it I got the dismaying message:
>> > > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
>> > > 
>> > > I have searched for answers and found none.
>> > > 
>> > > Can anyone point me in the right direction, please to solving this.
>> > > 
>> > > Thanks in advance.
>> > > ___
>> > > 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 problem MacOS High Sierra.

[R Losey]

I'm impressed that you got this running on the iMac; I only have this
working on Linux (and one can forget Windows entirely).


On Sun, Mar 19, 2023 at 4:51 PM G R Hewitt  wrote:

> Hello everyone,
> Gnucash 4.13
> Finance Quote 1.54
> MacPro 2010 High Sierra
> iMac 2017 Ventura
>
> After hours of much aggravation - don't ask ' I eventually got Finance
> Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> pleased with myself.
>
> Anyway, on pressing it I got the dismaying message:
> 'Unable to retrieve quotes for these items: CURRENCY:EUR'
>
> I have searched for answers and found none.
>
> Can anyone point me in the right direction, please to solving this.
>
> Thanks in advance.
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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 problem MacOS High Sierra.

[john]

Did you do the obvious (to me anyway) replacement of  in the example with 
your key?

Regards,
John Ralls

> On Mar 20, 2023, at 12:58 AM, G R Hewitt  wrote:
> 
> Hi John,
> I get this:
> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
> stock quotes with source 'alphavantage' or 'vanguard'; see
>  https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
> 
> Thanks
> 
> On Sun, 19 Mar 2023 at 22:22, John Ralls  > wrote:
>> What results when you try from the command line, e.g.
>>   ALPHAVANTAGE_API_KEY= 
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency EUR 
>> USD
>> ?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>> 
>> > On Mar 19, 2023, at 3:17 PM, G R Hewitt > > > wrote:
>> > 
>> > Hi John,
>> > Thanks for getting back.
>> > Yes I do, and I just checked, it is still there.
>> > 
>> > 
>> > On Sun, 19 Mar 2023 at 22:15, John Ralls > > > wrote:
>> > Do you have an alphavantage api key?
>> > 
>> > Regards,
>> > John Ralls
>> > 
>> > 
>> > > On Mar 19, 2023, at 2:50 PM, G R Hewitt > > > > wrote:
>> > > 
>> > > Hello everyone,
>> > > Gnucash 4.13
>> > > Finance Quote 1.54
>> > > MacPro 2010 High Sierra
>> > > iMac 2017 Ventura
>> > > 
>> > > After hours of much aggravation - don't ask ' I eventually got Finance
>> > > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
>> > > pleased with myself.
>> > > 
>> > > Anyway, on pressing it I got the dismaying message:
>> > > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
>> > > 
>> > > I have searched for answers and found none.
>> > > 
>> > > Can anyone point me in the right direction, please to solving this.
>> > > 
>> > > Thanks in advance.
>> > > ___
>> > > 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 problem MacOS High Sierra.

[G R Hewitt]

Hi John,
I get this:
ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
stock quotes with source 'alphavantage' or 'vanguard'; see
 https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US

Thanks

On Sun, 19 Mar 2023 at 22:22, John Ralls  wrote:

> What results when you try from the command line, e.g.
>   ALPHAVANTAGE_API_KEY=
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency
> EUR USD
> ?
>
> Regards,
> John Ralls
>
>
>
>
> > On Mar 19, 2023, at 3:17 PM, G R Hewitt  wrote:
> >
> > Hi John,
> > Thanks for getting back.
> > Yes I do, and I just checked, it is still there.
> >
> >
> > On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:
> > Do you have an alphavantage api key?
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> > >
> > > Hello everyone,
> > > Gnucash 4.13
> > > Finance Quote 1.54
> > > MacPro 2010 High Sierra
> > > iMac 2017 Ventura
> > >
> > > After hours of much aggravation - don't ask ' I eventually got Finance
> > > Quote 1.54 to install, the 'Get Quotes' button was active and I was
> well
> > > pleased with myself.
> > >
> > > Anyway, on pressing it I got the dismaying message:
> > > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> > >
> > > I have searched for answers and found none.
> > >
> > > Can anyone point me in the right direction, please to solving this.
> > >
> > > Thanks in advance.
> > > ___
> > > 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 problem MacOS High Sierra.

[John Ralls]

What results when you try from the command line, e.g.
  ALPHAVANTAGE_API_KEY= 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency EUR USD
?

Regards,
John Ralls




> On Mar 19, 2023, at 3:17 PM, G R Hewitt  wrote:
> 
> Hi John,
> Thanks for getting back.
> Yes I do, and I just checked, it is still there.
> 
> 
> On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:
> Do you have an alphavantage api key?
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> > 
> > Hello everyone,
> > Gnucash 4.13
> > Finance Quote 1.54
> > MacPro 2010 High Sierra
> > iMac 2017 Ventura
> > 
> > After hours of much aggravation - don't ask ' I eventually got Finance
> > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> > pleased with myself.
> > 
> > Anyway, on pressing it I got the dismaying message:
> > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> > 
> > I have searched for answers and found none.
> > 
> > Can anyone point me in the right direction, please to solving this.
> > 
> > Thanks in advance.
> > ___
> > 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 problem MacOS High Sierra.

[G R Hewitt]

Hi John,
Thanks for getting back.
Yes I do, and I just checked, it is still there.


On Sun, 19 Mar 2023 at 22:15, John Ralls  wrote:

> Do you have an alphavantage api key?
>
> Regards,
> John Ralls
>
>
> > On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> >
> > Hello everyone,
> > Gnucash 4.13
> > Finance Quote 1.54
> > MacPro 2010 High Sierra
> > iMac 2017 Ventura
> >
> > After hours of much aggravation - don't ask ' I eventually got Finance
> > Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> > pleased with myself.
> >
> > Anyway, on pressing it I got the dismaying message:
> > 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> >
> > I have searched for answers and found none.
> >
> > Can anyone point me in the right direction, please to solving this.
> >
> > Thanks in advance.
> > ___
> > 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 problem MacOS High Sierra.

[John Ralls]

Do you have an alphavantage api key?

Regards,
John Ralls


> On Mar 19, 2023, at 2:50 PM, G R Hewitt  wrote:
> 
> Hello everyone,
> Gnucash 4.13
> Finance Quote 1.54
> MacPro 2010 High Sierra
> iMac 2017 Ventura
> 
> After hours of much aggravation - don't ask ' I eventually got Finance
> Quote 1.54 to install, the 'Get Quotes' button was active and I was well
> pleased with myself.
> 
> Anyway, on pressing it I got the dismaying message:
> 'Unable to retrieve quotes for these items: CURRENCY:EUR'
> 
> I have searched for answers and found none.
> 
> Can anyone point me in the right direction, please to solving this.
> 
> Thanks in advance.
> ___
> 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.