[GNC] Alpha Vantage problems

Adrian Holbrook adrian.holbrook at gmail.com
Tue Jul 7 09:58:27 EDT 2020


Thanks fo the advice. I was going to download the alpphvantage addon for
Excel but instead used gnc-fq-dump. I can get all the NYSE stocks but
nothing off the LSE using the suffix .L. Fails every time;.


Adrian


On Tue, Jul 7, 2020 at 12:01 PM Chris Good <goodchris96 at gmail.com> wrote:

> Hi Adrian, how are you getting quotes from excel? Have you got your
> alphavantage API key specified in GnuCash preferences?
>
> I suggest the next stage would be to test each of the stocks you want to
> use Alphavantage for, with gnc-fq-dump.
>
> Regards, Chris Good
>
> On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, <adrian.holbrook at gmail.com>
> wrote:
>
>> Thanks Chris, I think my installation of Finance;;Quote is working fine
>> as I get quotes from other sources such as Morningstar and Yahoo JSON
>> without any problem. I think it must be an Alphavantage problem and the
>> next stage is to try and get quotes using excel and see if that works.  In
>> the short term I have changed my source to Yahoo JSON and that is working.
>> I would just like to be able to get Alphavantage working as well so that if
>> one fails I have a backup source.
>>
>> Regards
>>
>> Adrian
>>
>>
>>
>> On Tue, Jul 7, 2020 at 9:10 AM Chris Good <goodchris96 at gmail.com> wrote:
>>
>>> Message: 3
>>> Date: Tue, 7 Jul 2020 07:58:33 +0100
>>> From: Adrian Holbrook <adrian.holbrook at gmail.com>
>>> To: gnucash-user at gnucash.org
>>> Subject: [GNC] Alpha Vantage problems
>>> Message-ID:
>>>         <CALZ=gTfie0bn2Nbgbvkvw8Wn6O3oS+nxisihEtB2BvU+mZHm=
>>> A at mail.gmail.com>
>>> Content-Type: text/plain; charset="UTF-8"
>>>
>>> I have been using Alphvantage for about a year now to get quotes without
>>> any
>>> problems - I had to add in the 15 second delay that was suggested to
>>> stop it
>>> failing - but since then it has been 100% reliable. I normally download
>>> around 50 prices at a time about once a week. The last successful
>>> download
>>> was on June 12th and since then all attempts have failed.
>>>
>>> All my shares are on the LSE. I have not checked trying to get quotes
>>> from
>>> NYSE but that would be my next test.
>>> I am using Gnucash 4.0 and Finance::Quote 1.49
>>>
>>> Regards
>>>
>>> Adrian
>>>
>>> Hi Adrian,
>>>
>>> Please follow instructions at
>>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
>>>
>>> Regards, Chris Good
>>>
>>>


More information about the gnucash-user mailing list