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
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
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.
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.
- Sign up to RapidAPI
- 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.)
- 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.
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.
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.
Copy the URL. And note also the headers.
Step 4: Importing the data from Yahoo Finance into Google Sheets
We can now begin importing Yahoo Finance data into Google Sheets.
- Open a new Google Sheets document and launch Amigo Data
- From the list of sources, select Custom API.
- Keep GET as the option, and under API URL, paste the URL you’ve copied from Code Snippets.
- Keep the Authentication as None.
- 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.
- 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.
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.
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 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.
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: