Quantcast

Retrieving BTC (Bitcoin) Quotes

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Retrieving BTC (Bitcoin) Quotes

ehmar
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

Thanks
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Retrieving BTC (Bitcoin) Quotes

John Ralls-2

> On May 16, 2017, at 1:35 PM, [hidden email] 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

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Retrieving BTC (Bitcoin) Quotes

ehmar
In reply to this post by ehmar
On 05/16/2017 05:01 PM, John Ralls wrote:

>> On May 16, 2017, at 1:35 PM, [hidden email] 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
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Retrieving BTC (Bitcoin) Quotes

John Ralls-2

> On May 16, 2017, at 2:26 PM, [hidden email] wrote:
>
> On 05/16/2017 05:01 PM, John Ralls wrote:
>>> On May 16, 2017, at 1:35 PM, [hidden email] 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.
>

It's Yahoo. They're not providing a currency for BTCUSD.

Regards,
John Ralls


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Retrieving BTC (Bitcoin) Quotes

farleykj
So maybe a way around this would be to write a quick bit of Perl code to retrieve the quotes for Bitcoin in Euros and a quote for EUR to USD, and return the calculated result? I'd imagine the resultant quote would be very ephemeral, since both quotes are constantly changing, but there you go.
Ken Farley
Loading...