[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