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

[Bill Swanson]

Many thanks for the Yahoo as Jason. It works!

btw Capitalization in this command makes no difference:
sudo perl gnc-fq-dump -v alphavantage IPAS

Bill



On Thu, Aug 23, 2018 at 3:41 PM brad <bradhaack at fastmail.us> wrote:

> Try Yahoo as JSON for the quote source.
>
> On 08/22/2018 03:41 PM, Bill Swanson wrote:
> > 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