Hi,
I am trying to build a formula that uses some data pulled in from a webservice api.
This is the forumual
What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114"
I have tried the filterxml formula by entering
but all i get is an error.
Is there a way to do this.
Thanks
I am trying to build a formula that uses some data pulled in from a webservice api.
This is the forumual
Code:
=WEBSERVICE("https://api.coinmarketcap.com/v1/ticker/ethereum/")
What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114"
I have tried the filterxml formula by entering
Code:
=FILTERXML(B2,"//price_usd")
Is there a way to do this.
Thanks