Price Retrieval Failure

[D]

Derek,

I did edit the environment file.

This experience makes it clear to me that it would be nice if Gnucash had some way of showing F::Q information to the end user, like a screen showing the version installed, and maybe having buttons to trigger the various gnc- scripts and show the output. This would make debugging just a tad easier... (Note that I am not asking for better error messages, which certainly would be nice, but not likely, since finance quote isn't Gnucash).

David



On January 23, 2018, at 11:22 PM, Derek Atkins <derek at ihtfp.com> wrote:

Did you update the environment file again after the upgrade? The update 
process overwrites that file.

-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user 
<gnucash-user at gnucash.org> wrote:

> 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.
>
>
>
> _______________________________________________
> 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.