Import Yahoo Finance Data Into Google Sheets

import data from Yahoo Finance into Google Sheets
Reading Time: 6 minutes

Overview of the tutorial
Here’s how you can import Yahoo Finance Data into Google Sheets in minutes:
1. Install Amigo Data extension in your Google Sheets.
2. Register on RapidAPI and get an API key for Yahoo Finance.
3. Get the endpoint for the data to import.
4. Launch Amigo Data and select Custom API.
5. Paste the endpoint URL and enter the headers.
6. Preview, then import.

Introduction

Yahoo Finance provides hours of live, daily market coverage, with expert analysis and real-time market data. Some of the offerings include market data on Cryptocurrencies, regular currencies, stocks and bonds, fundamental and options data, and market analysis and news. It’s the place for insight-driven investors, financial professionals and business leaders who take their money seriously.

You can import all this information as well as several others directly into Google Sheets, where you can then utilise the data for various purposes and in different ways such as making a report, creating a visual chart or graph for better insights, and so on.

Using Amigo Data, you can pull these data automatically and periodically with just a single setup. And not just that, you can receive alerts in your email or Slack channel snapshots of the imported data and reports of the data at regular intervals.

Below is a sample of exported Yahoo Finance data into Google Sheets

Sample of data exported from Yahoo Finance into Google Sheets

Let us learn how to import Yahoo Finance data into Google Sheets step by step.

How to import Yahoo Finance data into Google Sheets

Step 1: Install the Amigo extension in Google Sheets

We need a tool with which to pull data from Yahoo Finance to Google Sheets. For this, we’ll use Amigo Data, a simple but versatile Google Sheets extension that’s easy to use, rich in features, and gives you the ability to pull data from several different sources.

You can get it from the Google Workspace Marketplace here.

Install Amigo to import Yahoo Finance data to Google Sheets

Alternatively, you can open a Google Sheets document, then go to Extensions→Add-ons→Get add-ons. And search for Amigo Data and install.

Once the installation is complete, we can move on to the next step, which is getting the API key–which will be use import Yahoo Finance data into Google Sheets.

Step 2: Get the Yahoo Finance API key

In order to retrieve data from Yahoo Finance to Google Sheets, we’ll need what is called called an API key. It is a code used to identify and authenticate access.

Since Yahoo Finance has decommissioned its official API, we’ll use a third-party API RapidAPI–an API marketplace.

Follow the steps below to get an API key from RapidAPI.

1. Log in or sign up to RapidAPI.

2. Once you’re logged in, go to the Yahoo Finance API documentation page in RapidAPI. (You can also search for Yahoo Finance from the RapidAPI Hub and click the relevant result.)

3. Choose a subscription plan from the Pricing menu. Choose the Basic option. (You can always upgrate later.)

Choose a subscription plan to import Yahoo Finance data into Google Sheets

4. The API key will be generated once you’ve chosen a pricing option.

Getting the API key from RapidAPI - Yahoo Finance Google Sheets

Navigate back to Endpoints to see the API key. Note the key and keep it confidential.

Step 3: Select a data endpoint

On the left of the page is a list of all available categories of data that can be imported from Yahoo Finance to Google Sheets. Click any one of the endpoints.

For this tutorial, we’ll export the trending tickers data. So expand the market menu and click market/get-trending-tickers.

Change the region to any of the ones available: US, CA, DE, GB, IN, etc. We’ll just keep the default as it is, ie US. Then click Test Endpoint.

Getting the endpoint to import Yahoo Finance data into Google Sheets

On the right side of the screen, you’ll see a success message.

Click Code Snippets, and change the Programming language from (Node.js) Axios to Shell→cURL.

Getting the endpoint URL to import Yahoo Finance data into Google Sheets

Copy the URL. And note also the headers. These will be used to import Yahoo Finance data to Google Sheets.

Yahoo Finance endpoint URL - Yahoo Finance Google Sheets

Step 4: Import Yahoo Finance data into Google Sheets

We can now begin to import data from Yahoo Finance to Google Sheets using the API endpoint URL and headers obtained in the preceding step.

To import Yahoo Finance data into Google Sheets, follow the steps outlined below:

1. Open a new Google Sheets document and launch Amigo Data. Click Extensions→Amigo Data→Connect

2. From the list of sources, select Custom API.

3. For this particular API call, the request method is GET. So keep GET as the option, and under API URL, paste the endpoint URL from Code Snippets.

Entering the endpoint to pull Yahoo Finance data to Google Sheets

4. Expand the Details tab and enter the two headers. The characters to the left of the colon (“:”) is the Name and on the right is the Key. Enter both in different headers. Remember to exclude the inverted commas.

Entering the header names and values - on how to import data from Yahoo Finance into Google Sheets

5. After that is done, click PREVIEW.

The data are nested and so they need to be expanded and sorted into columns. So click the Flatten button. Flatten and expand all the nested datasets.

Preview of the data to be imported from Yahoo Finance into Google Sheets

Once all that is done, click the IMPORT button to import the data from Yahoo Finance to Google Sheets. The data will be imported into Google Sheets in a couple of seconds.

Data imported from Yahoo Finance into Google Sheets
Yahoo Finance data into Google Sheets imported data

Should you want to edit the data, you can do so from the View Reports menu.

  • Expand the menu
  • Select the report to edit under Your Reports
  • Click Edit Report and the PREVIEW
  • Once the editing is done, click UPDATE
  • Then finally click Save & Run

Setting refresh schedule to automatically update the data

To get the information updated periodically, click the report you want to update automatically, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.

Then click Save & Run.

Setting a refresh schedule for automatic update to automate Yahoo Finance data imports into Google Sheets

The Yahoo Finance data will now be updated regularly at the time and frequency that you’ve set.

Alerts via email or Slack

You can get the report sent to your email or a Slack channel if you want to.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Update of the Yahoo Finance data in Google Sheets received as an alert in email

Conclusion

You can import now import data from Yahoo Finance to Google Sheets, such as historical data, insider transactions information, earnings reports, market summary and so on with Amigo Data. You can get the endpoints for each of these by following the procedure mentioned in Step 3 and then easily pull Yahoo Finance data to Google Sheets following the procedures in part 4 of this article.

See also

There are plenty of other things that you can use Amigo Data for such as importing data to Google Sheets from Google Trends, Google Ads, Facebook Ads, Google Search Console and MySQL among others. You can check out our blog for tutorials on them.

Some other articles you may be interested in:

Export Facebook Ads Data to Google Sheets

How to connect Shopify to Google Sheets and export data

Import Data From Nasdaq To Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial