Alphavantage not working in gnucash 2.6.17

John Ralls jralls at ceridwen.us
Tue Nov 28 14:01:28 EST 2017



> On Nov 28, 2017, at 9:30 AM, Patrick Alken <alken at colorado.edu> wrote:
> 
> I always start it from the command line. The --debug option didn't show anything in the log file related to quotes
> 
> On 11/28/2017 10:27 AM, John Ralls wrote:
>> 
>>> On Nov 28, 2017, at 8:46 AM, Patrick Alken <alken at colorado.edu> wrote:
>>> 
>>> My OS is Ubuntu linux 17.10
>>> 
>>> and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok from the commandline with alphavantage)
>>> 
>>> On 11/28/2017 07:50 AM, John Ralls wrote:
>>>>> On Nov 27, 2017, at 9:57 PM, Patrick Alken <alken at colorado.edu> wrote:
>>>>> 
>>>>> Apologies if this has already been asked, but I couldn't find this exact
>>>>> issue in the recent mailings.
>>>>> 
>>>>> I have:
>>>>> 
>>>>> gnucash: 2.6.17
>>>>> 
>>>>> F::Q: 1.47
>>>>> 
>>>>> My F::Q works from the command line:
>>>>> 
>>>>> ----------
>>>>> 
>>>>> $ gnc-fq-dump alphavantage CSCO
>>>>> Finance::Quote fields Gnucash uses:
>>>>>     symbol: CSCO                 <=== required
>>>>>       date: 11/27/2017           <=== recommended
>>>>>   currency: USD                  <=== required
>>>>>       last: 36.8700              <=\
>>>>>        nav:                      <=== one of these
>>>>>      price:                      <=/
>>>>>   timezone:                      <=== optional
>>>>> ----------
>>>>> 
>>>>> However inside gnucash price editor I still get the "unknown error when
>>>>> retrieving price quotes".
>>>>> 
>>>>> I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
>>>>> the security editor. However the price editor still gives me the same
>>>>> error (unknown error).
>>>>> 
>>>>> gnucash --debug shows nothing related to quotes. I only get lines like this:
>>>>> 
>>>>> ----
>>>>> 
>>>>> * 22:34:53  INFO <gnc.account> [xaccAccountGetBalanceInCurrency]  baln=0/1
>>>>> * 22:34:53  INFO <gnc.account> [xaccAccountGetBalanceInCurrency]  baln=0/100
>>>>> * 22:34:53  INFO <gnc.account> [xaccAccountGetBalanceInCurrency]  baln=0/100
>>>>> * 22:34:53  INFO <gnc.account> [xaccAccountGetBalanceInCurrency]  baln=0/100
>>>>> 
>>>>> ----
>>>>> 
>>>>> Can anyone advise how to diagnose the issue?
>>>> What OS and how did you install F::Q?
>> 
>> Do you normally start GnuCash from the command line? If not, does quote retrieval work if you do?


Right. To get debug messages from the price import code run `gnucash -log gnc.scm=debug`. I don't know if that will yield anything useful.

You might also see if `echo "(alphavantage CSCO)" | gnc-fq-helper` yields any errors.

Regards,
John Ralls



More information about the gnucash-user mailing list