Quick Guide
How to import data from Nasdaq to Google Sheets:
Step 1: Install the Amigo Data add-on
Step 2: Get the Nasdaq API key
Step 3: Choose an endpoint of data to import
Step 4: Enter the endpoint in Amigo Data
Step 5: Preview the data and import
There are plenty of data that we can retrieve from Nasdaq and import the data from Nasdaq to Google Sheets. We can retrieve these data with Nasdaq API and pull the data to Google Sheets using Amigo, a Google Sheets extension for data integration and automation.
In the snippet below, we have retail trading activity tracker data exported from Nasdaq Data Link to Google Sheets.
So we’re going to learn how to import data from Nasdaq to Google Sheets using Nasdaq API.
How to import data from Nasdaq to Google Sheets
Here’s a step-by-step guide to import Nasdaq data to Google Sheets.
Step 1: Install the Amigo Data add-on
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace to import data from Nasdaq to Google Sheets.
Alternatively, you can get it from Google Sheets itself.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install it.
Step 2: Get the Nasdaq Data Link API key
We need an API key to retrieve data from Nasdaq Data Link and import data from Nasdaq to Google Sheets. Getting a key is a simple process.
- Sign up on Nasdaq Data Link, if you don’t already have an account.
- Fill in the details and create an account.
- Upon creation of the account, you’ll receive a welcome message along with the Nasdaq Data Link API key.
- Note the key and click the continue button. This key will be used to pull financial data from Nasdaq Data Link to Google Sheets.
- You can also the Nasdaq Data Link API key on the Account Settings page.
Step 3: Choose an endpoint of data to import
Although there are hundreds of financial and economic data that we can retrieve from Nasdaq Data Link, most of them are not available for free but a sample is available. So, for demonstration purposes, we’ll import a dataset that doesn’t require a subscription.
Navigate to the Nasdaq Data Link catalog and search for the data of your interest. Select the data of your choice from the left panel or use the search box to search for the data to retrieve.
Let’s import OPEC’s crude oil price data from Nasdaq to Google Sheets.
Search for OPEC and click the first result.
Underneath the description is a label “FREE” indicating that it can be imported without a subscription.
Click on it and on the next page, click EXPAND.
On the next page, we’ll see a chart showing the price of crude oil from 2003 up to the present. Since we do not need to import all the available data, we’ll change some of the parameters.
Change the time period from “max” to “6M” and frequency from “default” to “weekly” – to get the weekly price data for the last six months.
Then click the json option under API on the right side of the screen. The URL for the specified data will be displayed on the screen.
This is the endpoint we’ll use to import the data to Google Sheets. Copy it.
For certain types of data, there will be a “Download” button. Click on that to find the endpoint URL.
Step 4: Import the data from Nasdaq to Google Sheets
Follow the steps below to import the data to Google Sheets using Amigo Data.
- Go back to Google Sheets and launch Amigo Data to pull the data from Nasdaq Data Link to Google Sheets.
- Select Custom API from the list of sources.
- Then in the API URL bar, paste the endpoint
- Click the PREVIEW button to retrieve and preview the data.
- Flatten the nested datasets. And then click the IMPORT button.
- The data from Nasdaq Data Link will be imported into Google Sheets in a moment. Shown below is a snippet of the imported data.
Other endpoints
By following steps 3 and 4, we can import several other types of data from Nasdaq to Google Sheets. Below are a few examples.
Endpoint for Bitfinex exchange rates datapoint:
https://data.nasdaq.com/api/v3/datasets/BITFINEX/LUNAF0USTF0.json?api_key=YOURAPIKEY
Tesla ticker price:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date=2022-10-06&ticker=TSLA&api_key=YOURAPIKEY
Facebook’s stock details:
https://data.nasdaq.com/api/v3/datasets/WIKI/FB.json?api_key=YOURAPIKEY
For more examples and detailed information, visit the Nasdaq API documentation page.
For financial data API, visit this: https://data.nasdaq.com/tools/api
Pull data from Nasdaq to Google Sheets automatically
To retrieve the data and update the imported data automatically at regular intervals, set a refresh schedule.
To set a refresh schedule for imported data, click the report, 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 so that you do not even have to open the spreadsheet to keep track of what’s happening.
To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.
Conclusion
It is a simple process to import API data from Nasdaq to Google Sheets using Amigo Data. And with Amigo Data, importing is not the end of it; in fact, it’s just the beginning. The imported data are constantly updated so that you have the latest data at your fingertips.
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, US Patent and Trademark Office, AccuWeather, Coingecko and Yahoo Finance among others. You can check out our blog for tutorials on them.
Some related articles you may find useful:
Import Yahoo Finance data to Google Sheets