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 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.
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.
click here!This post received a 3.2% upvote from @randowhale thanks to @legosnjoysticks! For more information,
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) :
<p dir="auto"><a href="http://steemitboard.com/@legosnjoysticks" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link"><img src="https://images.hive.blog/768x0/https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png" srcset="https://images.hive.blog/768x0/https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png 1x, https://images.hive.blog/1536x0/https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png 2x" /> Award for the number of upvotes received <p dir="auto">Click on any badge to view your own Board of Honor on SteemitBoard.<br /> For more information about SteemitBoard, click <a href="https://steemit.com/@steemitboard" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">here <p dir="auto">If you no longer want to receive notifications, reply to this comment with the word <code>STOP <blockquote> <p dir="auto">By upvoting this notification, you can help all Steemit users. Learn how <a href="https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">here!