[GNC] Automatic Retrieval of Quotes not working for Exchange Traded Funds (ETFs)

Peter Marshall peterfmarshall at icloud.com
Mon Feb 3 18:01:12 EST 2020


Woohoo!  That is what I needed.  Thanks so much for your help.  Somehow I missed that in the documentation for setting up the Finance::Quote.  It’s interesting that it worked without that API key for non-ETF securities.

> On Feb 2, 2020, at 9:10 AM, John Ralls <jralls at ceridwen.us> wrote:
> 
> 
> 
>> On Feb 2, 2020, at 3:31 AM, Peter Marshall via gnucash-user <gnucash-user at gnucash.org> wrote:
>> 
>> Automatic Retrieval of Quotes using the Finance::Quotes module is not working for Exchange Traded Funds (ETFs).  For example, I have setup a Security record for an ETF with:
>> 
>>  Security Information
>> 	Full name:	Vanguard Mega Cap Growth ETF
>> 	Symbol/abbreviation:	MGK
>> 	Display symbol:	MGK
>> 	Type:	NYSE
>> 	ISIN, CUSIP or other code:
>> 	Fraction traded:	1/10000
>>  Quote Source Information
>> 	√ Get Online Quotes
>> 	√ Single:	Alphavantage, US
>> 	Timezone:	America/New_York
>> 
>> I’ve also setup a Security record for a traditional stock with:
>> 
>>  Security Information
>> 	Full name:	Tesla Inc.
>> 	Symbol/abbreviation:	TSLA
>> 	Display symbol:	TSLA
>> 	Type:	NASDAQ
>> 	ISIN, CUSIP or other code:
>> 	Fraction traded:	1/10000
>>  Quote Source Information
>> 	√ Get Online Quotes
>> 	√ Single:	Alphavantage, US
>> 	Timezone:	America/New_York
>> 
>> When I go to the Price Database interface and use the Get Quotes action, I get an error message:
>> 
>>  Unable to retrieve quotes for these items:
>> 	NYSE:MGK
>>  Continue using only the good quotes?
>> 
>> The problem doesn’t seem to be with Alphavantage.  I can use their API and successfully pull a quote for any ETF.  Any idea how to get ETF price quotes in gnucash?
> 
> Did you configure your Alphavantage API key into GnuCash's preferences according to https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F?
> 
> Regards,
> John Ralls
> 
> 



More information about the gnucash-user mailing list