Alphavantage quotes working through F::Q, not through Gnucash

Michael Fross michael at fross.org
Sun Nov 12 07:21:56 EST 2017


One thing to check is that perl is in the path so GNC can find the
executable.

Michael

On Sun, Nov 12, 2017 at 6:09 AM Dave H <hellvee at gmail.com> wrote:

> Hi Les,
>
> Have you tried running it with the -v (verbose) option to get a bit more
> information back ?
>
> Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
> after I first issue a "export ALPHAVANTAGE_AKI_KEY=################"
> command so you might find that's what is needed when running it directly.
> Remember the environment file you added the key to is used by GnuCash and
> presumably passes the api key into F::Q so if you run F:Q directly you have
> to let it know what your api key is ?
>
> Cheers Dave H.
>
>
> On 12 November 2017 at 20:28, Les <lelliott5 at gmail.com> wrote:
>
> > When I run the same command from my Linux Mint 18.2 I get
> >
> > Finance::Quote fields Gnucash uses:
> >     symbol: NYSE:TGT (deduced)   <=== required
> >       date: ** missing **        <=== recommended
> >   currency: ** missing **        <=== required
> >       last:                      <=\
> >        nav:                      <=== one of these
> >      price:                      <=/
> >   timezone:                      <=== optional
> >
> > ** This stock quote cannot be used by GnuCash!
> >
> > When I go to Price Editor and run Get Quotes I get a long list: "unable
> to
> > receive these quotes".
> >
> > When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> > directory".  When I try Get Quotes I get  "There was an unknown error
> while
> > retrieving the price quotes".
> >
> > So, I still have something missing.
> >
> > Les
> >
> >
> >
> > On 11/11/2017 10:21 PM, Robert Shimmin wrote:
> >
> >> Curious what I might be doing wrong.
> >>
> >> MacOS 10.11.6
> >> GnuCash 2.6.15
> >> F::Q 1.45
> >>
> >> After obtaining an API key, specifying it in the environment file, and
> >> adjusting each security that uses automatics quotes to get them through
> >> Alphavantage, if I use Price Editor > Get Quotes, I get an error,
> "Unable
> >> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc." (long
> list
> >> of symbols, list extends off the bottom of my screen, maybe I've set up
> >> too
> >> many securities for online quoting. If the error message concludes with
> >> whether I'd like to continue anyway with the quotes that could be
> >> obtained,
> >> the buttons are off the bottom of my screen and I don't actually get the
> >> choice.
> >>
> >> However, I must have set up things mostly right, because when testing it
> >> from the text helper utility, I'm getting alphavantage data back from
> F::Q
> >>
> >> $ ./gnc-fq-dump alphavantage NYSE:TGT
> >> Finance::Quote fields Gnucash uses:
> >>    symbol: NYSE:TGT
> >>    date: 11/10/2017
> >>    currency: USD
> >>    last: 61.4000
> >>    nav:
> >>    price:
> >>    timezone:
> >>
> >> Any thoughts as to what I'm doing wrong? Is there a practical limit to
> how
> >> many securities can use online quoting through alphavantage?
> >> _______________________________________________
> >> 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.
>


More information about the gnucash-user mailing list