Bitcoin Forum
May 28, 2024, 06:51:50 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Creating a Cryptocurrency Holdings spreadsheet in Google Docs (Sheets)  (Read 2545 times)
LiteBit (OP)
Legendary
*
Offline Offline

Activity: 1133
Merit: 1050


View Profile
October 30, 2014, 01:52:27 PM
 #1

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:
Code:
=IMPORTDATA("http://xch.blockscan.com/api2.aspx?module=supply&asset=XCH")
which gets me this:
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
franky1
Legendary
*
Offline Offline

Activity: 4228
Merit: 4501



View Profile
October 30, 2014, 02:55:41 PM
 #2

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

I DO NOT TRADE OR ACT AS ESCROW ON THIS FORUM EVER.
Please do your own research & respect what is written here as both opinion & information gleaned from experience. many people replying with insults but no on-topic content substance, automatically are 'facepalmed' and yawned at
LiteBit (OP)
Legendary
*
Offline Offline

Activity: 1133
Merit: 1050


View Profile
October 30, 2014, 03:34:22 PM
 #3

Ah.. it's JSON. Thanks.

Done in less than 5 minutes  Wink
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!