Ok. In terminal, have you set ALPHAVANTAGE_API_KEY using 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 <lellio...@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 <lellio...@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 <lellio...@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 <hell...@gmail.com >>>>>> <mailto:hell...@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 <lellio...@gmail.com >>>>>> <mailto:lellio...@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@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@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.
