Alphavantage quotes working through F::Q, not through Gnucash
Les
lelliott5 at gmail.com
Sun Nov 12 07:22:55 EST 2017
I did an export and tried running F:Q in the terminal with the -v and
still get "no such file or directory".
On 11/12/2017 05:08 AM, Dave H 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
> <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
> <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