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.
