Get Real-Time Stock Data In Google Sheets Using Marketstack API

Get the Amigo Data add-on from Google Workspace Marketplace.

Click here to install.

There are several stock quotes API that let us import real-time stock data into Google Sheets. We’ll use the Marketstack API.

Go to Marketstack API documentation and click “GET API KEY”.

Fill in the details and click “Sign Up”.

After successfully signing up, you will be redirected to a new page where you can see your API access key. This is the key we’ll use to get real-time stock data in Google Sheets.

Navigate to the Documentation page by clicking Documentation 

On the left side, under the Features section, choose any of the categories of stock data to import to Google Sheets. We’ll choose End-of-day Data. 

Note: Some of these data are restricted to the paid plans. So if you’re on the free plan, then you won’t be able to access them.

An example endpoint URL is given with Apple ticker symbol as the default.

We can modify the URL using any or all of the objects under HTTP GET Request Parameters.

We can append the query parameters either in the endpoint URL or enter them in the “Query” field in Amigo (on this later).

For example, to fetch Apple EOD data from 1 Dec 2022 to 31 Dec 2022, we’ll modify the URL as follows.

http://api.marketstack.com/v1/eod?access_key=YOUR_ACCESS_KEY&symbols=AAPL&date_from=2022-12-01&date_to=2022-12-31

To add additional parameters, use the ampersand and append the parameter names and their values.

Having got the endpoint URL and modified it with our preferred values, we can now begin to import the stock data from Marketstack to Google Sheets.

Open a new spreadsheet and launch Amigo Data.

Select Custom API from the list of sources.

Enter the stock API endpoint URL API URL field.

In the Details section, delete the access_key as it contains a dummy API key placeholder and add your stock API key obtained from Marketstack.

We need to add the original API key to make a valid request.  Click on the “+Query” option

Enter the “access_key” as the name and your API key in the value section. Click “+ADD QUERY”

Instead of appending the parameters in the URL, we can enter them here as queries. Enter the parameter name and the values and click “Add Query”.

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

Then flatten and expand the dataset so that they are organized suitably. Once that is done, click the IMPORT button.

A few moments later, you’ll have a spreadsheet populated with the data from Marketstack with the high, close, volume, etc.

Shown below is a snippet of the real-time stock data in Google Sheets.

You can likewise import dozens of other types of data using the Marketstack real-time stock data API. Following are some other examples.

Real-time stock quotes API endpoint

https://api.marketstack.com/v1/intraday?access_key=YOUR_ACCESS_KEY&symbols=AAPL&interval=1min

This end-point gives you real-time updates about the Apple stock. The key-value pair is separated by “&” sign. In the symbols parameter, you can add a symbol of any stock to fetch the data of that particular stock. You can also set the interval (1min, 5min, or 10min) as per your requirements by simply changing the numeric value. 

You can track multiple stocks by adding the tickers you want to track in the symbols parameter separating the tickers by commas.

Note: Replace YOUR_ACCESS_KEY in the URL with your key.

Historical data endpoint

https://api.marketstack.com/v1/eod?access_key=YOUR_ACCESS_KEY&symbols=AAPL&date_from=2022-10-19&date_to=2022-10-29

Along with the symbols parameter, you can also change the date_from (YYYY-MM-DD) and date_to (YYYY-MM-DD) parameter according to your requirements. 

Dividends data endpoint

https://api.marketstack.com/v1/dividends?access_key=YOUR_ACCESS_KEY&symbols=AAPL