Import Data From Nasdaq To Google Sheets

How to import data from Nasdaq to Google Sheets
Reading Time: 4 minutes

Quick Guide
A step-by-step guide on how to import data from Nasdaq to Google Sheets:
Step 1: Install the Amigo Data add-on
Step 2: Get 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 from Nasdaq that we can import to Google Sheets–and it involves only a few steps. So we’re going to learn how to import data from Nasdaq to Google Sheets using the Amigo Data Google Sheets extension.

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. Click here.

Alternatively, you can get it from Google Sheets itself.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Step 2: Get the Nasdaq API key

We need an API key to import data from Nasdaq to Google Sheets. Getting a key is a simple process, however.

Upon creation of the account, you’ll receive a welcome message along with the API key

Nasdaq API key

Note the key and click the continue button.

You can also find the API key on the Account Settings page.

API key in the Account Settings page

Step 3: Choose an endpoint of data to import

Although there are thousands of datasets, most of them are not available for free. So, for demonstration purposes, we’ll import a dataset that doesn’t require a subscription.

Navigate to the Nasdaq Data Link homepage and search for the data of your interest. Let’s import OPEC’s crude oil price data from Nasdaq to Google Sheets.

Search for OPEC and click the first option.

OPEC dataset to in Nasdaq

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

Expanding the dataset

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.

Changing the parameters to import data form Nasdaq to Google Sheets

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.

The endpoint URL of the dataset

This is the endpoint we’ll use to import the data to Google Sheets. Copy it.

Step 4: Import the data from Nasdaq to Google Sheets

Now, to connect 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
Launching Amigo Data in Google Sheets
  • Select Custom API from the list of sources
  • Then in the API URL bar, paste the endpoint
  • Click the PREVIEW button and flatten the data points
  • Finally click the IMPORT button

The data from Nasdaq will be imported into Google Sheets in a moment.

Shown below is a snippet of the imported data.

Snippet of the data imported from Nasdaq to Google Sheets

Should you want to make changes to the way and the kinds of data imported and updated, 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

Other endpoints

By repeating 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

Setting refresh schedule

To get the information updated periodically, 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:

https://blog.tryamigo.com/import-data-from-binance-to-google-sheets/

https://blog.tryamigo.com/import-coinbase-data-to-google-sheets/

https://blog.tryamigo.com/import-bscscan-data-to-google-sheets/