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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice one mate I've followed your channel to check that out :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
👊😎
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks for the tips!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Your welcome!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Your welcome!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Fantastic info. Wouldn't imagine myself something like that is possible .
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
There are some great Google tools that people do not know about.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post received a 3.2% upvote from @randowhale thanks to @legosnjoysticks! For more information, click here!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you! I will be posting part 2 tomorrow.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit