[GNC] Online Quotes

John Ralls jralls at ceridwen.us
Thu Jul 23 16:52:40 EDT 2020



> On Jul 23, 2020, at 12:23 AM, Alex Dorsch <alex.dorsch at posteo.net> wrote:
> 
> 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.

Neither GnuCash nor Finance::Quote can magic up a response for a query that the website doesn't understand. Both of those queries on the respective websites produce "not found" errors. 

That aside, GnuCash is an accounting program. While it has limited features to account for investments it is not in any way a portfolio tracking program. Sorry.

Regards,
John Ralls



More information about the gnucash-user mailing list