Alphavantage quotes working through F::Q, not through Gnucash
Les
lelliott5 at gmail.com
Sun Nov 12 15:33:50 EST 2017
After the release of F:Q 1.47, I was able to update to in on my LInux
Mint 18.2 and now I am able to update stocks and currencies via Price
Editor's Get Quotes!
Now waiting for F:Q 1.47 to migrate to my Mac where running the script I
get FQ is up to date at 1.45.
Three chears for Eric!
On 11/12/2017 11:24 AM, D wrote:
>
> Ok. In terminal, have you set ALPHAVANTAGE_API_KEYusing an export
> command? That must be set *in the terminal session* in order to
> retrieve quotes in terminal.
>
> David
>
> On November 12, 2017, at 10:10 PM, Les <lelliott5 at gmail.com> wrote:
>
> >Yes, that is the path I used. In the terminal, I changed to the path
> >you indicated and now that part works but does not return any useful
> >data (No price quote, date or currency).
> >But progress just the same. Thanks David.
> >On 11/12/2017 08:33 AM, David T. wrote:
> >> I’ll assume that you mean
> /Applications/Gnucash.app/Contents/Resources/environment (note the
> lower case ‘e’; case matters in MacOS). If not, then that will be the
> problem.
> >>
> >> To run gnc-fq-dump, you need to be in
> /Applications/Gnucash.app/Contents/Resources/bin
> >>
> >> David
> >>
> >>> On Nov 12, 2017, at 7:10 PM, Les <lelliott5 at gmail.com> wrote:
> >>>
> >>> I added Alphavantage API key to the end of
> /Applications/Gnucash.app/Contents/Resources/Environment, which is
> where I was informed it needed to be. Is this no correct?
> >>>
> >>> As for command line, I have tried running changing directories to
> /Applications/Gnucash.app .
> >>>
> >>>
> >>> On 11/12/2017 07:30 AM, David T. wrote:
> >>>> My question to both Les and Robert is *which* environment file
> have you updated? ~/.bash_profile, or
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?
> >>>>
> >>>> F::Q will not work in the Mac bundle with Alphavantage if you
> modify ...bash_profile (but will work at the command line), and vice
> versa.
> >>>>
> >>>> Les, also, from what folder are you trying to run gnc-fq-dump?
> You need to be inside the Gnucash bundle for it to work.
> >>>>
> >>>> David
> >>>>
> >>>>
> >>>>> On Nov 12, 2017, at 5:32 PM, Les <lelliott5 at gmail.com> wrote:
> >>>>>
> >>>>> 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.
> >>>>>>
> >>>>> _______________________________________________
> >>>>> 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