I was following the thread regarding having Numbers pull values of BTC and Altcoins from the Web. The only things that works is using the currency function.
CURRENCY("BTC","USD",0)
Using the Stock function, gives a syntax error.
STOCK "ETH-USD", "PRICE")
Does anyone have a workable solutions for Altcoins?
=STOCK("ETH-USD",price)
works fine here.
I think you got the syntax error because you left out the opening ( .
Also, if your region uses , as a decimal separator then you need to use ; instead of , in the formula.
SG
=STOCK("ETH-USD",price)
works fine here.
I think you got the syntax error because you left out the opening ( .
Also, if your region uses , as a decimal separator then you need to use ; instead of , in the formula.
SG
That was indeed it. Thank you so much.
Automated Bitcoin price in numbers
