[GNC] Online Quotes

[Colin]

Hi Alex,

I just set up a test stock in GnuCash with the stock you listed. Yahoo JSON
worked - but you have to use their ticker symbol ("GIVN.SW"). You can find
this on the Yahoo Finance website.

Incidentally, in the Security Editor where Alphavantage is listed, it says
"US" after it, which suggests it only works with US-based items. I use
Yahoo-JSON for all my own assets. It's been reliable, accurate and covers
everything I've needed so far - including cryptocurrency. Now I know it
includes international stocks too.

In GnuCash go to Tools - Security Editor and choose New to add your stock,
or Edit if it already exists. The bottom half of the pop-up window is for
quote information. After selecting "Get Online Quotes", in the Single quote
source section, choose the dropdown. You'll find Yahoo JSON at the bottom
of that list.

Best,
Colin

Date: Thu, 23 Jul 2020 09:23:56 +0200
> From: Alex Dorsch <alex.dorsch at posteo.net>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Online Quotes
> Message-ID:
>         <4be1eabd21d0e2ad2f7bb7c060291d54959370b2.camel at posteo.net>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi,
>
> I'm having trouble getting online quotes for share prices in Gnucash.
>
> I'm fiddeling around with finance::quote
>
> While this works:
>
> $ ALPHAVANTAGE_API_KEY=<my_key> gnc-fq-dump alphavantage googl
> Finance::Quote fields Gnucash uses:
>     symbol: googl                <=== required
>       date: 07/22/2020           <=== recommended
>   currency: USD                  <=== required
>       last: 1564.8500            <=\
>        nav:                      <=== one of these
>      price:                      <=/
>   timezone:                      <=== optional
>
> Everything that's not listed in the US does not:
>
> $ gnc-fq-dump sixshares CH0010645932
> Finance::Quote fields Gnucash uses:
>     symbol: CH0010645932         <=== required
>       date: ** missing **        <=== recommended
>   currency: ** missing **        <=== required
>       last: **missing**          <=\
>        nav: **missing**          <=== one of these
>      price: **missing**          <=/
>   timezone:                      <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> $ gnc-fq-dump yahoo_json GB00B24CGK77.L
> Use of uninitialized value $json_name in concatenation (.) or string at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 132.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 156.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Finance::Quote fields Gnucash uses:
>     symbol: GB00B24CGK77.L       <=== required
>       date: 07/23/2020           <=== recommended
>   currency: ** missing **        <=== required
>       last: **missing**          <=\
>        nav: **missing**          <=== one of these
>      price: **missing**          <=/
>   timezone:                      <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> I would be very glad to receive some help. I've been looking around for
> portfolio tracking software on linux (jstock, several web based
> products, etc.) and haven't found anything satisfactory.
>
> I'd be really happy if I could use Gnucash for all my financial
> managing needs, but at this point I find it quite cumbersombe.
>
> Best regards,
>
> Alex
>
>
>