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.
