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

[Dave H]

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> 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
>> 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.
>