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 <bsch...@asgard-systems.com> 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 <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.
