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.
- Get the tool for importing data
- Get the API key
- Choose an endpoint
- Import the data to Google Sheets
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
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.
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.
3. Choose a subscription plan from the Pricing menu. Choose the Basic option. (You can always upgrate later.)
4. The API key will be generated once you’ve chosen a pricing option.
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.
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. And note also the headers. These will be used to import Yahoo Finance data to 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.
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 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.
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.
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.
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.
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.
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: