Import Morningstar Data To Google Sheets

Reading Time: 4 minutes

Morningstar is a financial services firm that provides an array of investment research and investment management services. It compiles and analyzes fund, stock, and general market data.

In this article, we will learn how to import Morningstar Data to Google Sheets with Morningstar API using Amigo, a Google Sheets extension. We can import various kinds of financial market data like market summaries, movers, stock financials, and many more.

The snippet below shows the real-time stock of Tesla imported into Google Sheets using Morningstar API.

To import stock data with Morningstar API, we will follow the steps below:

How to import Morningstar data to Google Sheets

Here’s the step-by-step guide to import Morningstar data to Google Sheets.

Install the Amigo extension

Install the Amigo Google Sheets add-on from the Google Workspace Marketplace.

Click here to install.

Install Amigo to import Morningstar data to Google Sheets

Alternatively, you can get it from Google Sheets.

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

Generate the Morningstar API key

We’ll use a third-party Morningstar API on RapidAPI. It’s much easier to use than the official one but not much less useful.

Sign up or log in to RapidAPI.

RapidAPI page to sign up

Once you’re logged in, go to the MS Finance API documentation in RapidAPI. This is the Morningstar API we’ll use to import stock data to Google Sheets.

Morningstar API documentation

Choose a subscription plan from the Pricing menu to use the Morningstar API. We’ll choose the Basic plan for the purpose of this tutorial.

Subscribe to a plan to use the Morningstar API

On subscribing to a plan, an API key will be generated which will allow us to access the Morningstar API and retrieve Morningstar data.

Click on the Endpoints and scroll down a bit. You will find your API key under the Header Parameters.

RapidAPI key

Choose an endpoint

On the left of the Morningstar API documentation page, you’ll find the list of all data endpoints.

Morningstar API data endpoints

Expand any of the data categories and click the endpoints of the data to retrieve from Morningstar and import to Google Sheets.

For this tutorial, we will import global indices data with the get-global-indices endpoint under the market section. With this endpoint, we can import daily data of all the major global indices.

Choosing a Morningstar API endpoint

This endpoint requires no additional parameters. So we’ll go ahead and click “Test Endpoint” to run the query.

Running the Morningstar API query

The success message indicates that the API is functioning correctly.

The API is working well

The Morningstar API endpoint URL as well as the API headers can be found under Code Snippets.

Change the language from (Node.js) Axios to Shell -> cURL from the dropdown menu.

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note the headers. This is the endpoint URL we’ll use to import Morningstar data to Google Sheets.

Morningstar API URL and headers

Import the Morningstar data to Google Sheets

Go back to Google Sheets and launch the Amigo extension.

Launch Amigo to import Morningstar data to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the Morningstar API endpoint URL in the API URL bar.

Pasting the endpoint

Then expand the Details tab and enter the headers mentioned in the code snippets.

Name: X-RapidAPI-Host, Value: ms-finance.p.rapidapi.com

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Morningstar API headers

Click the PREVIEW button to retrieve the Morningstar data and preview the data.

Flatten the data points and then click IMPORT.

Preview of the Morningstar data to import to Google Sheets

A snippet of the imported data.

Snippet of imported into Google Sheets from Morningstar

You can likewise import other types of Morningstar data using MS Finance API. To explore more, go through the documentation.

After importing the data, you can set a refresh schedule so that the data are updated automatically at regular intervals. To learn how to set a refresh schedule, follow this link.

Amigo extension can connect Google Sheets to multiple sources and allows you to import data automatically. It’s a convenient and versatile tool to import and export data to Google Sheets. It can save you a lot of time and effort. To learn more about other various kinds of data that can be imported to Google Sheets, visit our blog.

Some related articles you may be interested in:

Import Webull Data To Google Sheets

Automate Trading View Data Imports To Google Sheets

Automate Coinranking Data Imports To Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial