create account

Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1 by legosnjoysticks

View this thread on: hive.blogpeakd.comecency.com
· @legosnjoysticks ·
$2.42
Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1
<!DOCTYPE html>

<p><center>https://steemitimages.com/DQmRDgrXKY2nLMRVb3mwwVEsFPJA1AtoCErLDFz3n1ZHh2y/Google%20Sheets%20Final.jpg</center></p>

<p>Google Sheets has a really great tool for importing data that you can use to analyze cryptocurrency trends and create graphs.</p>

<p>The feature I want to highlight today is the formula  <a href="https://support.google.com/docs/answer/3093339?hl=en">IMPORTHTML</a>. Below is an example of what the formula looks like. I will explain how to use it.
</p>
<p>IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)</p>

What does this formula do? It imports data from a webpage and displays it in a spreadsheet. Here's a simple example that will help you get the idea of what you can do with this powerful free tool. To begin find a website with data that you want to import. For this example I'm going to use a url that lists <a href="https://coinmarketcap.com/">cryptocurrency market capitalizations</a>.
<center>https://steemitimages.com/DQmS7CBY5wjPzGoC8ZTaTXAP3g3kYDL9P5vATk7J3Jhk2CY/site1.jpg</center>
</p>
Now that I have the data I want to analyze I am going to open <a href="https://www.google.com/sheets/about/">Google Sheets</a> and use the formula to import it. The formula will go into the first cell.
<center>https://steemitimages.com/DQmeDZv9NvMazn4MW7SoYzz3xG3CzexDNmhm2gGsgNU6qTt/Screenshot%202017-07-10%20at%209.08.08%20AM.png</center>
<p></p>
<p>Now I'm going to paste the formula into the cell. You need an = sign to let Google Sheets know you are using a formula. Replace the url below with the url of the page you wish to extract data from.
<p><b>Before</b></p>
<p>IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)</p>
<p><b>After</b></p>
<p>IMPORTHTML("https://coinmarketcap.com/","table",2)</p>
<p>Notice I changed the url and the table. You may have to use trial and error to find out the table with the data you wish to extract. In this case it is table 2. Below is what your formula should look like.</p>
<center>https://steemitimages.com/DQmXSdMEZYqgC1GUnRheLmnPtpW61YdaX3hF79TYg7myFc4/Screenshot%202017-07-10%20at%209.26.08%20AM.png</center>

</p>

<p>
Hit enter and your data should load into the spreadsheet.
<center>https://steemitimages.com/DQmVS1z4W8FAuuvCWoeqWq2wx33a9AiM96L8YrcAZmjnH4f/Screenshot%202017-07-10%20at%209.27.35%20AM.png</center>
</p>
<p></p>
<p>Now that you have your data, the next step will be to analyze it and create some graphs. Part two will address that coming soon. As you can see there is some nice potential with this free tool. This is a great for analyzing all types of data. I also use it for daily fantasy statistics from websites like ESPN and MLB.</p>
<p>
If you like this post feel free to follow me @legosnjoysticks.
</p>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 13 others
properties (23)
authorlegosnjoysticks
permlinkanalyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1
categorycryptocurrency
json_metadata{"tags":["cryptocurrency","bitcoin","money","ethereum","crypto"],"users":["legosnjoysticks"],"image":["https://steemitimages.com/DQmRDgrXKY2nLMRVb3mwwVEsFPJA1AtoCErLDFz3n1ZHh2y/Google%20Sheets%20Final.jpg","https://steemitimages.com/DQmS7CBY5wjPzGoC8ZTaTXAP3g3kYDL9P5vATk7J3Jhk2CY/site1.jpg","https://steemitimages.com/DQmeDZv9NvMazn4MW7SoYzz3xG3CzexDNmhm2gGsgNU6qTt/Screenshot%202017-07-10%20at%209.08.08%20AM.png","https://steemitimages.com/DQmXSdMEZYqgC1GUnRheLmnPtpW61YdaX3hF79TYg7myFc4/Screenshot%202017-07-10%20at%209.26.08%20AM.png","https://steemitimages.com/DQmVS1z4W8FAuuvCWoeqWq2wx33a9AiM96L8YrcAZmjnH4f/Screenshot%202017-07-10%20at%209.27.35%20AM.png"],"links":["https://support.google.com/docs/answer/3093339?hl=en","http://en.wikipedia.org/wiki/Demographics_of_India","https://coinmarketcap.com/","https://www.google.com/sheets/about/"],"app":"steemit/0.1","format":"markdown"}
created2017-07-10 13:41:00
last_update2017-07-10 13:41:00
depth0
children16
last_payout2017-07-17 13:41:00
cashout_time1969-12-31 23:59:59
total_payout_value1.961 HBD
curator_payout_value0.454 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,778
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,987,226
net_rshares665,958,211,762
author_curate_reward""
vote details (77)
@bart.tomas ·
Fantastic info. Wouldn't imagine myself something like that is possible .
properties (22)
authorbart.tomas
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t143224742z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 14:32:27
last_update2017-07-10 14:32:27
depth1
children1
last_payout2017-07-17 14:32:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length73
author_reputation26,475,691,120
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,992,301
net_rshares0
@legosnjoysticks ·
There are some great Google tools that people do not know about.
properties (22)
authorlegosnjoysticks
permlinkre-barttomas-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t143753791z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 14:37:54
last_update2017-07-10 14:37:54
depth2
children0
last_payout2017-07-17 14:37:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length64
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,992,877
net_rshares0
@chad1775 ·
This is some solid info here. Thanks so much for sharing. I don't know EXACTLY how I will use this yet, but I am certain I will. Thanks again!

STEEM ON!
properties (22)
authorchad1775
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t135256614z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:53:00
last_update2017-07-10 13:53:00
depth1
children1
last_payout2017-07-17 13:53:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length153
author_reputation47,143,297,400
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,988,384
net_rshares0
@legosnjoysticks ·
Your welcome!
properties (22)
authorlegosnjoysticks
permlinkre-chad1775-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t135953466z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:59:54
last_update2017-07-10 13:59:54
depth2
children0
last_payout2017-07-17 13:59:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length13
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,989,059
net_rshares0
@crypt0b0b ·
👊😎
properties (22)
authorcrypt0b0b
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t134224462z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:42:24
last_update2017-07-10 13:42:24
depth1
children0
last_payout2017-07-17 13:42:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2
author_reputation42,343,300,476
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,987,373
net_rshares0
@heavey ·
$0.05
Woah, how have I never heard about this? That's so useful for analysing every currency
👍  
properties (23)
authorheavey
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t135008968z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:50:09
last_update2017-07-10 13:50:09
depth1
children3
last_payout2017-07-17 13:50:09
cashout_time1969-12-31 23:59:59
total_payout_value0.037 HBD
curator_payout_value0.011 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length86
author_reputation6,059,193,153,550
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,988,091
net_rshares13,778,683,326
author_curate_reward""
vote details (1)
@legosnjoysticks ·
It really is useful. Once you get the hang of it, the formula is really easy to use. Make sure you check out part 2 tomorrow where I show you how to analyze the data and format it. There are some quirks to it.
properties (22)
authorlegosnjoysticks
permlinkre-heavey-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t135842200z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:58:42
last_update2017-07-10 13:58:42
depth2
children2
last_payout2017-07-17 13:58:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length209
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,988,942
net_rshares0
@heavey ·
$0.05
Nice one mate I've followed your channel to check that out :)
👍  
properties (23)
authorheavey
permlinkre-legosnjoysticks-re-heavey-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t170152713z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 17:01:51
last_update2017-07-10 17:01:51
depth3
children1
last_payout2017-07-17 17:01:51
cashout_time1969-12-31 23:59:59
total_payout_value0.037 HBD
curator_payout_value0.012 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length61
author_reputation6,059,193,153,550
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,007,933
net_rshares14,108,711,669
author_curate_reward""
vote details (1)
@millionaireman ·
Wow
properties (22)
authormillionaireman
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t135421515z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:54:39
last_update2017-07-10 13:54:39
depth1
children0
last_payout2017-07-17 13:54:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length3
author_reputation117,967,870,966
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,988,547
net_rshares0
@mrakun777 ·
thanks for the tips!
properties (22)
authormrakun777
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t134237101z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:42:39
last_update2017-07-10 13:42:39
depth1
children1
last_payout2017-07-17 13:42:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length20
author_reputation125,635,124,190
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,987,393
net_rshares0
@legosnjoysticks ·
Your welcome!
properties (22)
authorlegosnjoysticks
permlinkre-mrakun777-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t134809053z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 13:48:09
last_update2017-07-10 13:48:09
depth2
children0
last_payout2017-07-17 13:48:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length13
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,987,926
net_rshares0
@randowhale ·
This post received a 3.2% upvote from @randowhale thanks to @legosnjoysticks!  For more information, [click here](https://steemit.com/steemit/@randowhale/introducing-randowhale-will-you-get-the-100-vote-give-it-a-shot)!
properties (22)
authorrandowhale
permlinkre-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t144702
categorycryptocurrency
json_metadata"{"format": "markdown", "app": "randowhale/0.1"}"
created2017-07-10 14:47:03
last_update2017-07-10 14:47:03
depth1
children0
last_payout2017-07-17 14:47:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length219
author_reputation47,657,457,485,459
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,993,942
net_rshares0
@shaden ·
Now this is a great tip! I can see myself using this on a regular basis, not only on crypto but also on other things.

I would like to see more content like this, so keep them comming!
<b>Thanks, really!</b>
properties (22)
authorshaden
permlinkre-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t144921063z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 14:49:21
last_update2017-07-10 14:49:21
depth1
children1
last_payout2017-07-17 14:49:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length207
author_reputation4,419,766,445,003
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,994,181
net_rshares0
@legosnjoysticks ·
Thank you! I will be posting part 2 tomorrow.
properties (22)
authorlegosnjoysticks
permlinkre-shaden-re-legosnjoysticks-analyze-cryptocurrency-with-an-awesome-feature-of-google-sheets-part-1-20170710t145455120z
categorycryptocurrency
json_metadata{"tags":["cryptocurrency"],"app":"steemit/0.1"}
created2017-07-10 14:54:54
last_update2017-07-10 14:54:54
depth2
children0
last_payout2017-07-17 14:54:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length45
author_reputation163,912,274,144
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id7,994,796
net_rshares0
@steemitboard ·
Congratulations @legosnjoysticks! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](http://steemitboard.com/@legosnjoysticks) Award for the number of upvotes received

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click [here](https://steemit.com/@steemitboard)

If you no longer want to receive notifications, reply to this comment with the word `STOP`

> By upvoting this notification, you can help all Steemit users. Learn how [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-legosnjoysticks-20170710t161906000z
categorycryptocurrency
json_metadata{"image":["https://steemitboard.com/img/notifications.png"]}
created2017-07-10 16:19:06
last_update2017-07-10 16:19:06
depth1
children0
last_payout2017-07-17 16:19:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length709
author_reputation38,975,615,169,260
root_title"Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,003,464
net_rshares0