[GNC] Finance Quote problem MacOS High Sierra.

John Ralls jralls at ceridwen.us
Mon Mar 20 23:52:45 EDT 2023


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.
>> > 



More information about the gnucash-user mailing list