> On Nov 19, 2017, at 9:14 AM, Frank Saporito <[email protected]> > wrote: > > I have been working on this problem for several days and reluctantly have to > bother the mailing list members for help. > > I followed the instructions on: > > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F > <https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F> > > I have an alphavantage API key > I have Finance::Quote ver 1.47 > I run GnuCash in CentOS 6 (not that it matters) > I have update appended /etc/gnucash/environment as follows: > ALPHAVANTAGE_API_KEY= (my api key) > I restarted GnuCash > I changed the securities to get online quotes from alphavantage > > Even so, GnuCash price editor is unable to retrieve quotes. > > I believe that, despite the correct API key (I tested it via a LO Calc) > identified in the environment file, it is not being accepted by GnuCash > based on the return for the gnc-fq-dump below: > > # gnc-fq-dump -v alphavantage T > Finance:: Quote fields Gnucash uses: > symbol: T (deduced) <=== required > date: ** missing ** <=== required > currency: ** missing ** <=== required > last: <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by gnucash!! > > > All fields returned by Finance::Quote for stock T > > stock field value > ----- ----- ----- > T errormsg: Expected ALPHAVANTAGE_API_KEY to be set; get an API > key at https://www.alphavantage.co > T last: **missing** > T nav: **missing** > T price: **missing** > T success: 0 > > I have checked the environment file numerous times. Gedit was used to > update the environment file. > > Any suggestions would be greatly appreciated. >
The environment file only works when Finance::Quote is called from the GnuCash GUI. You need to set ALPHAVANTAGE_API_KEY as a shell environment variable for gnc-fq-dump to see it. I've added a bullet to the FAQ item explaining this. Regards, John Ralls _______________________________________________ gnucash-user mailing list [email protected] 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.
