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 <bsch...@asgard-systems.com> 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 <hell...@gmail.com> 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 <hell...@gmail.com> 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=xxxx
.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 = <unknown> 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 <gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org> on
behalf of John Ralls <jra...@ceridwen.us>
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt <hewit...@gmail.com>
Cc: GNU Cash User <gnucash-user@gnucash.org>
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=xxxx
.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 <hewit...@gmail.com> wrote:
Hi John,
Ha ha, you got me there, no I didn't, and should have.
I now get:
1 EUR = <unknown> USD
Is that what is expected?
Oddly enough, I was being lazy and tried to paste the code over the highlighted
'xxxx' 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 'xxxxx' intact, and still got:
1 EUR = <unknown> USD.
Puzzling.
On Mon, 20 Mar 2023 at 16:12, john <jra...@ceridwen.us> wrote:
Did you do the obvious (to me anyway) replacement of xxxx in the example with
your key?
Regards,
John Ralls
On Mar 20, 2023, at 12:58 AM, G R Hewitt <hewit...@gmail.com> 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 <jra...@ceridwen.us> wrote:
What results when you try from the command line, e.g.
ALPHAVANTAGE_API_KEY=xxxx
/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 <hewit...@gmail.com> 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 <jra...@ceridwen.us> wrote:
Do you have an alphavantage api key?
Regards,
John Ralls
On Mar 19, 2023, at 2:50 PM, G R Hewitt <hewit...@gmail.com> 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.
_______________________________________________
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.
