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 <bradha...@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) > > e...@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@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.