Retrieving BTC (Bitcoin) Quotes

ehmar at 2xwave.com ehmar at 2xwave.com
Tue May 16 17:26:39 EDT 2017


On 05/16/2017 05:01 PM, John Ralls wrote:
>> On May 16, 2017, at 1:35 PM, ehmar at 2xwave.com wrote:
>> 
>> I was wondering how to retrieve quotes using the Security & Price 
>> Editor for bitcoin (BTC).
>> 
>> I've found that Yahoo now reports the BTC price in USD at 
>> https://finance.yahoo.com/quote/BTCUSD=X
>> 
>> I also found that the csv download works at 
>> http://download.finance.yahoo.com/d/quotes.csv?s=BTCUSD%3DX&f=nab (Is 
>> this how GnuCash retrieves it's Yahoo quotes?)
>> 
>> I've tried multiple times to setup a FUND, AMEX, NASDAQ, & NYSE for 
>> "BTCUSD=X", but can't get the Price Editor to download a price (from 
>> Yahoo USA).
>> 
>> Is there something preventing me from querying Yahoo for the BTCUSD 
>> price?
>> Is the equal sign "=" valid in GnuCash for a symbol/abbreviation?
>> I've also tried BTXUSD%3DX (like the csv download link above) with no 
>> success?
>> 
>> Unable to retrieve quotes for these items:
>>  FUND:BTCUSD=X
>> 
>> Does anyone have any ideas?
>> 
>> I'm running Version 2.6.15 rev 1ef17e6+ on 2016-12-21 on Debian Linux 
>> 9
> 
> The "type" doesn't matter. The way to test these things is gnc-fq-dump, 
> and here's what it says:
> src/quotes/gnc-fq-dump -v yahoo btcusd=x
> Finance::Quote fields Gnucash uses:
>     symbol: btcusd=x             <=== required
>       date: 05/15/2017           <=== recommended
>   currency: ** missing **        <=== required
>       last: 1726.0900            <=\
>        nav:                      <=== one of these
>      price: 1726.0900            <=/
>   timezone:                      <=== optional
> 
> ** This stock quote cannot be used by GnuCash!
> Oddly, src/quotes/gnc-fq-dump yahoo btceur=x
> Finance::Quote fields Gnucash uses:
>     symbol: btceur=x             <=== required
>       date: 05/16/2017           <=== recommended
>   currency: EUR                  <=== required
>       last: 1593.9929            <=\
>        nav:                      <=== one of these
>      price: 1593.9929            <=/
>   timezone:                      <=== optiona
> 
> Regards,
> John Ralls
> 

Thanks for the help,

So is it a perl issue with Finance::Quote? Or is it the way Yahoo is 
writing the csv file?

I'll keep digging into it.

Thanks again,

Mario


More information about the gnucash-user mailing list