Price Retrieval Failure

[D]

Thanks. As I noted originally, my file was correctly configured and retrieving quotes from Alphavantage before the upgrade. Regardless, I had double checked that as well. 

Did you know that you can display the quote source for your securities on the main securities page? I didn't, before this.

David

On January 23, 2018, at 10:25 PM, david amaral <dejamaral at yahoo.com> wrote:

Verify security editor for your investments have get quotes checked and AlphaVantage  listed as source for each entry.



From: David T. via gnucash-user <gnucash-user at gnucash.org>
To: Gnucash Users <gnucash-user at gnucash.org> 
Sent: Tuesday, January 23, 2018 10:07 AM
Subject: Price Retrieval Failure


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.

_______________________________________________

gnucash-user mailing list

gnucash-user at gnucash.org

https://lists.gnucash.org/mailman/listinfo/gnucash-user

-----

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.