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