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

Les lelliott5 at gmail.com
Sun Nov 12 12:10:28 EST 2017 

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