[GNC] Finance Quote problem MacOS High Sierra.

Tue Mar 21 11:17:38 EDT 2023

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.com at gnucash.org> on behalf of John Ralls <jralls at ceridwen.us>
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt <hewittgr at gmail.com>
Cc: GNU Cash User <gnucash-user at 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 <hewittgr at 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 <jralls at 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 <hewittgr at 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 <jralls at 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 <hewittgr at 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 <jralls at ceridwen.us> wrote:
>> > Do you have an alphavantage api key?
>> >
>> > Regards,
>> > John Ralls
>> >
>> >
>> > > On Mar 19, 2023, at 2:50 PM, G R Hewitt <hewittgr at 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 at 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 at 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.