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

John Ralls jralls at ceridwen.us
Sun Feb 2 11:10:46 EST 2020



> 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