[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