Add a value to Numbers spreadsheet with a web service call

Unlike Excel Numbers does not have UDF (user defined functions).

However, you can retrieve values from the website using a short script like the one before.

1. Copy-paste script below into Script Editor (in Applications > Utilities folder).
2. May sure Script Editor.app is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
3. Change the document, sheet, and table names in the first few lines to match your setup.
4. With the document open click the 'run' button in Script Editor.

SG

set theSymb to "ETH"

set d to "MyDocumentName.numbers"

set s to "MySheetName"

set t to "MyTableName"

set tgtCell to "A1"

set theURL to "https://min-api.cryptocompare.com/data/pricemulti?fsyms=" & theSymb & "&tsyms=USD,USD"

set thePrice to do shell script "curl -s " & quoted form of theURL

set thePrice to thePrice's last word

tell application "Numbers" to tell document d's sheet s's table t

set celltgtCell'svalue to thePrice

end tell

Nerves82 wrote:

Wow, what a great answer! This was better then I was honestly hoping for. So for this script to run, will Script Editor need to be open and run this script every time to update that value or is there a way to embed it into the spreadsheet?

You can't "embed" a script into the document. But you can put it in the menu or into an "Automator Service" to which you can attach a keyboard shortcut.

There are ways to have a script run automatically at regular time intervals but I don't recommend that as it tends to get a little "clunky" and potentially interfere with other things you are doing on your computer.

SG