Price Retrieval Failure

[David Carlson]

D

Some of that information is already available.  I know that the F::Q
version appears in the console if GnuCash is started from the command
line.  There are also instructions somewhere in the WIKI (I think) to run
F::Q as a stand-alone.  Perhaps the answer is to have better documentation
(which is dear to the hearts of some of us ;-) )

David C

On Tue, Jan 23, 2018 at 9:01 PM, D via gnucash-user <
gnucash-user at gnucash.org> wrote:

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