Analyze Cryptocurrency with an Awesome Feature of Google Sheets Part 1

in cryptocurrency •  2 years ago 

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

The feature I want to highlight today is the formula IMPORTHTML. Below is an example of what the formula looks like. I will explain how to use it.

IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)

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 cryptocurrency market capitalizations.

Now that I have the data I want to analyze I am going to open Google Sheets and use the formula to import it. The formula will go into the first cell.

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.

Before

IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)

After

IMPORTHTML("https://coinmarketcap.com/","table",2)

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.

Hit enter and your data should load into the spreadsheet.

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.

If you like this post feel free to follow me @legosnjoysticks.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Woah, how have I never heard about this? That's so useful for analysing every currency

·

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.

·
·

Nice one mate I've followed your channel to check that out :)

·
·
·

Thank you!

👊😎

thanks for the tips!

·

Your welcome!

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!

·

Your welcome!

Wow

Fantastic info. Wouldn't imagine myself something like that is possible .

·

There are some great Google tools that people do not know about.

This post received a 3.2% upvote from @randowhale thanks to @legosnjoysticks! For more information, click here!

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!
Thanks, really!

·

Thank you! I will be posting part 2 tomorrow.

Congratulations @legosnjoysticks! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

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

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!