[GNC] Install Alphavantage Key

Peter Williamson pwandww at xtra.co.nz
Fri Nov 26 19:38:11 EST 2021


Hi everyone
Thanks for your assistance with setting up stock quotes.  I have now got stock prices downloaded for stocks listed on both the AU & NZ stock exchanges.  The method used is that described by Geoff.  For NZ share prices I used the NZ stock exchange as the single source provider.
Regards
Peter
> On 26/11/2021 13:04 Geoff <cleanoutmyshed at gmail.com> wrote:
> 
>  
> Hi Peter
> 
> As Eric said, you need to enter your key via:-
>   Edit / Preferences / Online Quotes
> 
> However I believe that Alpha Vantage no longer provide prices for 
> Australian securities.
> 
> I have been using the method below to reliably retrieve prices from the 
> Australian Securities Exchange (ASX) for a number of years.  I can't 
> help you with New Zealand.
> 
> Before doing anything in GnuCash, you should verify that the latest 
> version of the Perl Finance::Quote module (v1.51) is installed correctly:-
> http://finance-quote.sourceforge.net/
> 
> On Windows, you can do this from a Command prompt as follows:
>  >perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-dump" asx CBA
> 
> Which should result in something like this:-
> Finance::Quote fields Gnucash uses:
>      symbol: CBA                  <=== required
>        date: 11/26/2021           <=== recommended
>    currency: AUD                  <=== required
>        last: 96.1                 <=\
>         nav:                      <=== one of these
>       price: 96.1                 <=/
>    timezone:                      <=== optional
> 
> 
> Then you can open GnuCash and set up your portfolio as follows:-
> (1) Create your Securities and link them to the ASX via:-
>   Tools / Security Editor
> 
> (2) Create your Accounts (as Account Type of "Stock") and link them to 
> those Securities.
> 
> (3) Retrieve prices via:-
>   Tools / Price Database / GetQuotes
> 
> See the attached screenshot for a detailed working example.
> 
> Hope this helps.
> 
> Regards
> 
> Geoff
> =====
> 
> On 26/11/2021 8:48 am, Peter Williamson wrote:
> > Hi
> > I have installed and finance quote for Windows and on checking Gnucash Help, About I get Finance::Quote 1.51.
> > I now have a Source Advantage US key.
> > Please can someone tell me how to install this key to allow download of share prices from the Australian and New Zealand stock exchanges.
> > Peter
> > _______________________________________________
> > 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
> > 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.
> >


More information about the gnucash-user mailing list