Alphavantage quotes working through F::Q, not through Gnucash
David T.
sunfish62 at yahoo.com
Sun Nov 12 09:33:29 EST 2017
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