Price Retrieval Failure

David T. sunfish62 at yahoo.com
Tue Jan 23 12:06:34 EST 2018


Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the Alphavantage key, added the same key to /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q works at the command line:

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage AAPL
Finance::Quote fields Gnucash uses:
    symbol: AAPL                 <=== required
      date: 01/23/2018           <=== recommended
  currency: USD                  <=== required
      last: 178.6400             <=\       
       nav:                      <=== one of these
     price:                      <=/        
  timezone:                      <=== optional

I have restored the following two lines into the aforementioned lines to /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=************8SET

Unfortunately, I am getting the dreaded "There was an unknown error while retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.


More information about the gnucash-user mailing list