Hi Adrian, I'm afraid I have no idea if AlphaVantage can now or has ever been able to supply prices for stocks on the London Stock Exchange. It would be good to know an example stock?
Maybe some-one else can help? I have never been able to figure out a way to get prices for stocks on the Australian Stock Exchange either. Using the yahoo_json .AX suffix doesn't seem to work for AlphaVantage. If there is a way to do either of these things, it would be good to know and I could document it in the wiki. Regards, Chris Good Message: 11 Date: Tue, 7 Jul 2020 14:58:27 +0100 From: Adrian Holbrook <adrian.holbr...@gmail.com> To: Chris Good <goodchri...@gmail.com> Cc: GnuCash User Mailing List <gnucash-user@gnucash.org> Subject: Re: [GNC] Alpha Vantage problems Message-ID: <CALZ=gtdacqubw7c8morqqq2msssrhfmm9zrx26pd8mmvzx2...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" 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 <goodchri...@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.holbr...@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 <goodchri...@gmail.com> wrote: >> >>> Message: 3 >>> Date: Tue, 7 Jul 2020 07:58:33 +0100 >>> From: Adrian Holbrook <adrian.holbr...@gmail.com> >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Alpha Vantage problems >>> Message-ID: >>> <CALZ=gTfie0bn2Nbgbvkvw8Wn6O3oS+nxisihEtB2BvU+mZHm= >>> a...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.