Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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)
Here is an AppleScript gist that will retrieve the value of just about any cryptocurrency and add it to Numbers. It uses the API at Cryptonator API endpoint.
To run this you must have the JSON Helper for AppleScriptrunning (free on the MacOS app store), as well as numbers open to a sheet titled "Overview" that contains a table called "Coin Values (USD)" which has the following format:
|SYMBOL|PRICE|LAST_UPDATED_DATE|
where SYMBOL is the ticker symbol for the currency you want to fetch ('BTC'). The Price and LAST_UPDATED_DATE columns will be filled in by the script.
A more concrete example:
|BTC|blank|blank|
|ETH|blank|blank|
|LTC|blank|blank|
will fetch BTC, ETH, LTC and fill in the price and last updated columns.
Hey, a picture is worth 1000 words:
You can edit the code to adjust the base currency, table names and such.
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
THIS IS PERFECT!
Thank you so much.
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.
Ooops,
must be "LTC-EUR" or "LTC-USD"
and
"ETH-EUR" or "ETH-USD"
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.
I figured it out. Just simple syntax error. Thanks!
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
Automated Bitcoin price in numbers
