Pull Stock Market Data into Google Sheets

Researching specific stocks and pulling accurate up to date information can be tedious. Google Sheets cuts out a lot of the busy work and allows you to get the data you need in one convenient location.

With the Google Finance function, you can use Google Sheets to easily keep up with several different financial metrics. This video will show you how to pull real time and historical data directly into a Google Sheet.


{{ source }}

ImportHTML and Filter Views in Google Sheets

We’ve covered the importHTML function before, and it really is one of our favorite functions in Google Sheets. There is so much you can do with the function, but once you pair it with the new Filter Views you can accomplish even more.

The importHTML function allows you pull in live data from websites into a Sheet so you always have an updated set of data. If the function is pulling in more data than you need, you can always use Filter Views to streamline the process.