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 <[email protected]> on behalf of Bruce Schuck <[email protected]> Sent: Tuesday, March 21, 2023 10:30 PM To: John Ralls <[email protected]>; David H <[email protected]> Cc: GNU Cash User <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 >> <[email protected]> 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 >> <[email protected]> on behalf of >> John Ralls <[email protected]> >> Sent: Tuesday, March 21, 2023 12:52 AM >> To: G R Hewitt <[email protected]> >> Cc: GNU Cash User <[email protected]> >> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: >>>>> Do you have an alphavantage api key? >>>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>>> >>>>>> On Mar 19, 2023, at 2:50 PM, G R Hewitt <[email protected]> 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 >>>>>> [email protected] >>>>>> 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 >> [email protected] >> 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 >> [email protected] >> 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 [email protected] 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 [email protected] 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.
