Thought I'd ask the professionals here some spreadsheet questions regarding IMPORTDATA, IMPORTHTML, etc... for a small side project I'm working on.
Goal: -Make a spreadsheet of crypto holdings that can update automatically by gathering API web data.
What I've got so far:-A spreadsheet with categories such as:
Asset, Holdings, Total Distribution, Holding Percentage, USD Price, USD Total Value, BTC Price, BTC Total ValueWhat I need help with:-Importing data from web sources into specific cells of my spreadsheet that, in turn, automatically updates as the pulled information updates.
An Example:Say I own XCP-Counterparty. I want to populate a cell in my spreadsheet under "Total Distribution" with the data provided by this feed:
http://xcp.blockscan.com/api2.aspx?module=supply&asset=XCP HOW DO I DO THAT?
I can get the feed to load by using this command:
=IMPORTDATA("http://xch.blockscan.com/api2.aspx?module=supply&asset=XCH")
which gets me this:
{
"status": "success",
"message": "XCP",
"result": "2647299.0783785"
}
But I can't just simplify it to show only the resulting number under
"result": "2647299.0783785"
Grabbing web data from multiple sources:-I'd also like to do the same trick to load data from
http://coinmarketcap.com/currencies/counterparty/ for cells in the spreadsheet under "USD Price" and "BTC Price". I figure that if someone can walk me through the steps in the example above I can curtail that knowledge into grabbing other data to auto-populate this spreadsheet.
Any help would be great, I appreciate it in advance!
Cheers,
LiteBit