Alphavantage quotes working through F::Q, not through Gnucash
Les
lelliott5 at gmail.com
Sun Nov 12 07:32:38 EST 2017
I have had GC installed on my Mac for a very long time, and until Yahoo
pulled the plug everything worked great! So, I would have to believe
that Perl is already in the path. The only changes I have made were to
add the Alphavantage key to the end of the environment file and updating
GC to 2.6.18 after upgrading MacOS to 10.13.
But I will check since I don't recall ever running F:Q in the terminal
before. How would I check the path?
Thanks,
On 11/12/2017 06:21 AM, Michael Fross wrote:
> 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
> <mailto: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
> <mailto: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 <mailto: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 <mailto: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 <mailto: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