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