Import Yahoo Finance data to Google Sheets

If you are a savvy investor, it’s likely you follow the stock market on sites like Yahoo Finance.

Problem: To do a proper analysis of the data, you need to extract Yahoo Finance information into a spreadsheet. But are you still using copy/paste? No way! Let’s learn how to scrape Yahoo Finance with no technical knowledge.

Solution: Easily extract company information such as dividend, dividend yield, EPS, regular market price and many more from Yahoo Finance into a spreadsheet without any technical knowledge using our template to scrape Yahoo Finance and the ImportFromWeb add-on. We have configured more than more than 200 data points !

How it works

It uses the ImportFromWeb add-on that we built.

ImportFromWeb provides a simple function to extract data from any websites. You just need to find the urls of the pages you want to load and tell ImportFromWeb about the location of the elements you want to extract from those pages.

Copy the Yahoo Finance Scraper template

To properly set yourself up to extract hundreds of data points from Yahoo Finance, the first thing you need to do is get and copy the template of our Yahoo Finance Scraper:

Get the template

Install the add-on

Then, install the tool into your Google Sheets from the Google Workspace Marketplace following the step-by-step instructions indicated by the add-on. This is an easy process that just takes a minute and enables you to easily extract a high-volume of data from Yahoo Finance and most other websites.

From there, you can access the tool by opening the menu “Extensions” and activating ImportFromWeb within the spreadsheet.

Play with the Yahoo Finance Scraper

Our Yahoo Finance template is easy-to-use and ready to fetch data from all types of financial assets (stocks, ETFs, crypto)

The only thing you need to do is to specify the Yahoo Finance URLs of the assets you want to retrieve data from (up to 50 URLs) and define the data you want to import from those URLs, refering to our Glossary with +200 built-in selectors.

In a few seconds, you will see all the indicators for each stock value appear in the spreadsheet!

Yahoo Finance indicators you can extract with our scraper

When we say that you can extract more than 200 of data points from Yahoo Finance with our scraper, we are serious! Here you have a list of the different data points you can retrieve.

Did you find this tool useful?

Has it helped you to create your own Finance dashboards? We’d love to hear all of your feedback so that we can keep providing the best information on web scraping.