Alphavantage not an option in unknown online source list

[David Carlson]

Elias,

Have you rechecked your gnucash environment file for spelling, leading
comment characters, etc?

You did have admin rights when you edited it?

Did you quit gnucash before editing it?

David C

On Jan 1, 2018 4:56 PM, "Elias K Gardner" <zorkerz at gmail.com> wrote:

Ok took me awhile to realize I needed to be in /usr/bin and run 'export
ALPHAVANTAGE_API_KEY=##############' first. Then it appears 'perl
gnc-fq-dump -v alphavantage AMZN' works returning this:
"Finance::Quote fields Gnucash uses:
    symbol: AMZN                 <=== required
      date: 12/29/2017           <=== recommended
  currency: USD                  <=== required
      last: 1169.4700            <=\
       nav:                      <=== one of these
     price:                      <=/
  timezone:                      <=== optional

All fields returned by Finance::Quote for stock AMZN

stock           field  value
-----           -----  -----
AMZN            close: 1169.4700
AMZN         currency: USD
AMZN       currency_set_by_fq: 1
AMZN             date: 12/29/2017
AMZN             high: 1184.0000
AMZN          isodate: 2017-12-29
AMZN             last: 1169.4700
AMZN              low: 1167.5000
AMZN           method: alphavantage
AMZN             open: 1182.3500
AMZN          success: 1
AMZN           symbol: AMZN
AMZN           volume: 2625283"

So does this mean that gnucash is somehow not able to access my
alphavantage API key?


On Mon, Jan 1, 2018 at 4:24 PM Fross, Michael <michael at fross.org> wrote:

> ​Hi Elias,
>
> Take GNUCash out of the equation.  If you run :
>
> perl gnc-fq-dump -v alphavantage AMZN
>
> That should tell you if F:Q can get to alphavantage.
>
> I'm not sure if that will be in your path so you might have to find
> gnc-fq-dump.
>
> If that works or not it will help to narrow it down.
>
> Michael
>
> On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zorkerz at gmail.com> wrote:
>
>> Ah so it is. When I set it to "Yahoo as json" and get quotes it says
>> unable to retrieve quotes. Definitely no Alphavantage source. Version 1.47
>> is the newest version of Finance:Quote. I've tried to update it separately
>> per the wiki and it says I have the newest version.
>>
>> On Mon, Jan 1, 2018 at 2:13 PM David Carlson <david.carlson.417 at gmail.com>
>> wrote:
>>
>>> I think Yahoo_json is under the Single source tab in the get quotes
>>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>>> the second choice under Other.  I have not investigated updating
>>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>>> needs to be updated separately from GnuCash.
>>>
>>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zorkerz at gmail.com>
>>> wrote:
>>>
>>>> Thanks Michael, yahoo_json does not show up in my unknown sources
>>>> either. I
>>>> wonder if that is related to my problem.
>>>>
>>>> On Mon, Jan 1, 2018 at 1:17 PM Fross, Michael <michael at fross.org>
>>>> wrote:
>>>>
>>>> > While this doesn't answer your question, I switched to Alphavantage
>>>> > without issue, but then switched to yahoo_json as it's much faster.  I
>>>> > assume it will go away at some point and I'll have to switch back to
>>>> > Alphavantage.
>>>> >
>>>> > I'm currently running on Windows and it's available in unknown
>>>> sources so
>>>> > I'm not much help there.
>>>> >
>>>> > Michael
>>>> >
>>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zorkerz at gmail.com>
>>>> > wrote:
>>>> >
>>>> >> Hey there. I've followed the directions on the wiki for switching my
>>>> >> online
>>>> >> quotes from Yahoo! to Alphavantage but in the security editor
>>>> alphavantage
>>>> >> does not show up under unknown sources. What have I done wrong?
>>>> >>
>>>> >> I got an Alphavantage API key and I added
>>>> >> ALPHAVANTAGE_API_KEY=##############
>>>> >> (with the actual key instead of #s) to my environment file
>>>> >> (/etc/gnucash/environment).
>>>> >> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>>>> >>
>>>> > _______________________________________________
>>>> >> 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.
>>>>
>>>
>>>
>