Import Yahoo Finance Data Into Google Sheets

Import Yahoo Finance Data Into Google Sheets
Reading Time: 5 minutes

Overview of the tutorial
Here’s how you can import Yahoo Finance Data into Google Sheets in minutes:
1. Install Amigo Data in your Google Sheets
2. Register on RapidAPI and get an API key for Yahoo Finance
3. Generate an endpoint for the data to be imported
4. Launch Amigo Data in Google Sheets→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 information 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 set up. 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 me show you how you can import Yahoo Finance data into Google Sheets step by step.

Step 1: Getting the tool to import the data

We need a tool with which to import Yahoo Finance data into 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.

Get Amigo Data from Google Marketplace

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.

Step 2: Getting the API key

In order to access the Yahoo Finance database, we’ll need a key called the 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. Sign up to RapidAPI
  2. Once you’re logged in, go to the Yahoo Finance API documentation page in RapidAPI and choose a subscription plan from the Pricing menu. Choose the Basic option. (You can search for Yahoo Finance and click the first result.)
Choose a subscription plan
  1. The API key will be generated once you’ve chosen a pricing option. Navigate back to Endpoints to see the API key. Note that and keep it confidential.
Getting the API key from RapidAPI

Step 3: Choosing an endpoint

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, 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. Copy the URL excluding the apostrophes.

Getting the endpoint URL

Copy the URL. And note also the headers.

API URL and headers for the endpoint

Step 4: Importing the data from Yahoo Finance into Google Sheets

We can now begin importing Yahoo Finance data into Google Sheets.

  1. Open a new Google Sheets document and launch Amigo Data

Extensions→Amigo Data→Connect

  1. From the list of sources, select Custom API.
  2. Keep GET as the option, and under API URL, paste the URL you’ve copied from Code Snippets.
  3. Keep the Authentication as None.
  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.
  5. After that is done, click PREVIEW.

The preview data is cluttered and unorganised. So make sure to organise the information you don’t require by clicking the FLATTEN button. And delete the information you don’t want to import.

Once all that is done, click the IMPORT button. 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 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

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 received as alert in email

Conclusion

You can import any Yahoo Finance data into 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.

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:

https://blog.tryamigo.com/export-data-from-snowflake-to-google-sheets/

https://blog.tryamigo.com/importing-postgresql-data-to-google-sheets/

https://blog.tryamigo.com/export-razorpay-data-to-google-sheets/