Alphavantage quotes working through F::Q, not through Gnucash

[David T.]

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.