[GNC] Install Alphavantage Key
Geoff
cleanoutmyshed at gmail.com
Thu Nov 25 19:04:30 EST 2021
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.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_ASX_quotes.jpg
Type: image/jpeg
Size: 675664 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20211126/e4dae9da/attachment-0001.jpg>
More information about the gnucash-user
mailing list