Alphavantage not an option in unknown online source list
Elias K Gardner
zorkerz at gmail.com
Mon Jan 1 17:56:37 EST 2018
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.
>>>>
>>>
>>>
>
More information about the gnucash-user
mailing list