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

D sunfish62 at yahoo.com
Sun Nov 12 12:24:18 EST 2017


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 <lelliott5 at 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 <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