I am looking for a simple way to import the current Bitcoin value into a Numbers sheet.
Google sheets handles this quickly and efficiently by using this formula:
=GoogleFinance("CURRENCY:BTCUSD")
This is exactly what I need - but for Numbers.
The data could come from any of a number of sources such as https://api.bitcoinaverage.com/ticker/USD/last.
Thanks for your help!
MacBook Pro (Retina, 15-inch, Early 2013), OS X Mountain Lion (10.8.4)
Barry wrote:
STOCK(symbol,attribute)
"symbol" means the exchange ticker symbol for the security. Most are three letter or four letter strings in CAPS. The symbol must be enclosed in double quotes. And there must be only one symbol in the function's arguments.
Hi Barry, as Colinowww points out above, it seems the STOCK formula can also be used with two crypto currencies, by separating them with a dash, for example:
=STOCK("BTC-USD",price)
This works, but returns a slightly different result than:
=CURRENCY("BTC","USD",price)
I've yet to work out why the difference in results. It may be because Yahoo is pulling this data from 2 different sources.
Also the CURRENCY formula doesn't work with alt currencies, ETH for example (the second largest crypto currency after BTC), so I am hoping that the STOCK formula result is correct. It does seem to be closer to the close of prior day if I check on a few exchanges.
Literally none of these solutions work for me. I receive a syntax error on every possible method I can try. Has something changed or is there an option I've not selected? Help would be appreciated.
"Hi Barry, as Colinowww points out above…"
Thanks for the update, JD. I stand corrected.
Regards,
Barry
Thanks for that.
Note that in the latest versions of Numbers you can now retrieve stock and currency data via formula, similar to Google sheets.
The data comes from Yahoo! Finance. So for Bitcoin you could do something like this:
=CURRENCY("BTC","USD",price)
SG
Hi Barry,
Yes, that worked changing to Stock; however, it will not read the price attribute for some reason. BTC works great, but trying to also add Ethereum and Litecoin. Any ideas?
I was having many issues but you just need to type everything out. Try this, =STOCK "BTC-USD", "PRICE")
this works with the rest of the cryptocurrencies as well, so for ETH, LTC, TRX, etc.
=STOCK "ETH-USD", "PRICE")
=STOCK "TRX-USD", "PRICE")
you can even try copy and pasting one of the lines above and see what happens.
there is no way built into Numbers to grab information from a website and place it into a cell. (googlesheets has a function built in that will only ever work on googlesheets.)
You can write an applescript to go get the information and enter it into a cell for you, thats the only option i know of.
Jason
=CURRENCY("BTC","USD",price)
This is perfect!!!
Thanks SGIII
"=CURRENCY("BTC","USD",price)"
I've used it for BTC and it's ok, but don't get ETH or others cryptos. Anybody knows a way to do this?
Check for the symbol on Yahoo! Finance. If there is one and you can get the quote on Yahoo! Finance then you can try the same symbol in Numbers.
SG
Tried (ETHUSD=X) and ETHUSD=X as in Yahoo Finance - didn't work
Hi skootle,
It could be the difference in syntax in your formula compared the syntax used in SG's formula.
Regards,
Barry
Found how to get around this:
just click "Edit as Formula" and type
"LTCEUR" or "LTCUSD" for Litecoin
and
"ETHEUR" or "ETHUSD" for Ether
Worked for me.
format working for me is:
CURRENCY("BTC","USD",price)
but then I tried with LTC instead of BTC and no result, so that means Yahoo doesn't provide data for LTC unfortunately.
Automated Bitcoin price in numbers
