[GNC] Price tool -- get price works for 3 mutual funds but not the rest.

Bill Swanson wcswanson at gmail.com
Wed Aug 22 17:41:10 EDT 2018


ISSUE SUMMARY:
GnuCash 2.6.12 (Using Sqlite for data)
Unable to retrieve quotes for these items:
  NASDAQ:ABSYX
  NASDAQ:JVMIX
  NASDAQ:IPAS
  NASDAQ:WSTL
  NASDAQ:LMSC
    ...

 But good quotes are received for :
ABCYX
JAENX
PTTPX

Running on Linux Mint (Mate) 18.3 Sylvia
Environment varibles:
[Variables]
# PATH is used to find the finance::quote utility functions
PATH={GNC_BIN};{PATH}
ALPHAVANTAGE_API_KEY=###################

>sudo cpan -D Finance::Quote
CPAN::SQLite not installed, trying to work without
Reading '/home/bill/.cpan/Metadata'
  Database was generated on Sat, 18 Aug 2018 13:17:03 GMT
Finance::Quote
-------------------------------------------------------------------------
    (no description)
    E/EC/ECOCODE/Finance-Quote-1.47.tar.gz
    /usr/local/share/perl/5.22.1/Finance/Quote.pm
    Installed: 1.47
    CPAN:      1.47  up to date
    Erik Colson (ECOCODE)
    eco at ecocode.net

gnc-fq-dump -v alphavantage ipas works when the code in
gnc-fq-dump is changed from:
# my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
my $ALPHAVANTAGE_API_KEY = '###########';

and it now works!
bill at bill-mint64 ~/Downloads/Gnucash/gnucash-2.6.12/src/quotes $  sudo perl
gnc-fq-dump -v alphavantage ipas
Finance::Quote fields Gnucash uses:
    symbol: ipas                 <=== required
      date: 08/22/2018           <=== required
  currency: USD                  <=== required
      last: 0.2201               <=\
       nav:                      <=== one of these
     price:                      <=/
  timezone:                      <=== optional

All fields returned by Finance::Quote for stock ipas

stock           field  value
-----           -----  -----
ipas            close: 0.2201
ipas         currency: USD
ipas       currency_set_by_fq: 1
ipas             date: 08/22/2018
ipas             high: 0.2400
ipas          isodate: 2018-08-22
ipas             last: 0.2201
ipas              low: 0.1813
ipas           method: alphavantage
ipas             open: 0.1999
ipas          success: 1
ipas           symbol: ipas
ipas           volume: 1739863

But from GnuCash I only get 3 updates for the entire list.

Suggestions?
-- 
Bill Swanson
207-2443946


More information about the gnucash-user mailing list