Done in less than 5 minutes
Topic: Creating a Cryptocurrency Holdings spreadsheet in Google Docs (Sheets) (Read 2545 times)
October 30, 2014, 11:34:22 AM
Ah.. it's JSON. Thanks.
Done in less than 5 minutes
Done in less than 5 minutes
October 30, 2014, 10:55:41 AM
using googles search engine helps..
type in "google spreadsheet import json" and you get results like
https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a
type in "google spreadsheet import json" and you get results like
https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a
October 30, 2014, 09:52:27 AM
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 Value
What 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:
which gets me this:
But I can't just simplify it to show only the resulting number under
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
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 Value
What 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:
Code:
=IMPORTDATA("http://xch.blockscan.com/api2.aspx?module=supply&asset=XCH")Code:
{
"status": "success",
"message": "XCP",
"result": "2647299.0783785"
}But I can't just simplify it to show only the resulting number under
Code:
"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
Jump to: