Alphavantage quotes working through F::Q, not through Gnucash
Les
lelliott5 at gmail.com
Sun Nov 12 09:10:38 EST 2017
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