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.
