The Apple Numbers Application - Cell data from URL

A script like this works here. Change the names in the first four lines to suit.

Copy-paste into Script Editor. Also make sure Script Editor is checked at System Preferences > Security & Privacy > Privacy > Accessiblity.

With the document open click the triangle 'run' button to retrieve the price.

You could put this script in a menu and attach it to a keyboard shortcut. But note that you have to trigger it manually. If you need constant updating you might be better off with Google Sheets.

SG

set docName to "Untitled.numbers"

set shtName to "Sheet 1"

set tblName to "Table 1"

set cellName to "A1"

set jsnData to do shell script "curl -s " & "https://api.coinmarketcap.com/v1/ticker/bitcoin/"

set text item delimiters to "price_usd"

set usdPrice to jsnData's text item 2's word 1 as number

tell application "Numbers" to set documentdocName'ssheetshtName'stabletblName'scellcellName'svalue to usdPrice

Yes, in general it's possible to retrieve data from a url and populate cells in Numbers, via a script. But, as Ian points out, specifics are needed (what url, what data) before anyone here can post a useful response.

SG

The price can easily be retrieved with a 4-line script. But you don't say where you want to put it.

SG

peterpotboiler wrote:

Into a cell in a Numbers spreadsheet.

Hi Peter,

What cell? What table? What sheet? What document?

SG

Hi Peter,

What are you trying to do?

Please reply with:

• your version of Numbers (Menu > About Numbers);
• your Operating system (Menu > Apple > About this Mac);
• your overall aim;
• a screenshot of where you are up to;
• the formula that you are using.

More information will lead to a solution 😉.

Regards,

Ian.

Hi Peter,

• your overall aim;

To create a Numbers sheet which has a LIVE data feed from a website URL

Just guessing, but perhaps you want one of the Financial functions?

I don't think that they are live in Numbers 4.3.1

For example, STOCK

Please correct me if I have not understood your aim.

Regards,

Ian.

Thank you a lot for this.

I just have a small problem.

The script doesn't let me class usdprice as a number, I have to input as a text.

Whenever the number as more than 1 decimal number, numbers app doesn't put the dot anywhere, just appears an enormous number that doesn't have anything to do with the price I want.

I never programmed in my life, I am just testing to change the logic of the language to see if it works.

Thank you in advance for any help.

Perhaps your Mac is set to a region that uses , as the decimal separator? If so you could try temporarily changing to US region to so if that is the problem.

SG