GOOGLE SHEETS
August 7, 2021

Twelve Data Google Sheets Add-on Documentation

This guide will make sure to highlight all the features available with the Twelve Data Google Sheets Add-on. Before we proceed, make sure to have the add-on installed.

All functions begin with the TD.... The Parameter Info popup shows the names of the parameters in function calls. Google Sheets automatically shows a popup with all available method signatures within 1 second (1000 milliseconds).
Parameter info popup window

Add-on menu

Add-ons ➤ Twelve Data ➤ Insert
Interval button would generate the combo box with all available interval options.
The Technical Indicators button will load a dynamically updated list of indicators from the server.

Add-ons ➤ Twelve Data ➤ Update
Due to some limitations that Google Sheets imposes, e.g. Google Quotas, we provide the option to update the formulas manually and automatically. With this submenu, formulas can be updated manually in the selection, only the error ones, or all at the same.

Add-ons ➤ Twelve Data ➤ Settings
The first field allows you to change or remove the API key.
The second field accepts an integer number with the number of minutes for the automatic refresh of the sheet. Take note that the updates will only work when the Twelve Data Settings tab is open.

Functions

Returns the list of equities satisfying the criteria.
=TDStockList(symbol: string, exchange: string, country: string, type: string, headers: string)
Returns the list of physical pairs satisfying the criteria.
=TDForexList(symbol: string, currency_base: string, currency_quote: string, headers: string)
Returns the list of digital pairs satisfying the criteria.
=TDCryptoList(symbol: string, exchange: string, currency_base: string, currency_quote: string, headers: string)
Returns the list of ETFs satisfying the criteria.
=TDETFList(symbol: string, headers: string)
Returns the list of indices satisfying the criteria.
=TDIndicesList(symbol: string, country: string, headers: string)
Returns the list of exchanges satisfying the criteria.
=TDExchanges(type: string, name: string, code: string, country: string, headers: string)
Returns the list of all cryptocurrency exchanges available.
=TDCryptoExchanges(symbol: string, country: string, headers: string)
List of all cryptocurrency exchanges
Returns the list of instruments mostly satisfying the search criteria.
=TDSymbolSearch(symbol: string, headers: string)
Returns time series with open, high, low, and close prices (OHLC) + the volume data (V).
=TDTimeSeries(symbol: string, interval: string, exchange: string, country: string, type: string, outputsize: integer, order: string, timezone: string, start_date: string, end_date: string, prepost: string, headers: string)
Returns time series with open, high, low, and close prices (OHLC) for physical & digital currencies.
=TDCurrencyTimeSeries(base: string, quote: string, interval: string, exchange: string, country: string, type: string, outputsize: integer, order: string, timezone: string, start_date: string, end_date: string, prepost: string, headers: string)
Returns the exchange rate for the base currency against the quote currency.
=TDExchangeRate(base: string, quote: string, headers: string)
Returns the exchange rate + the amount converted from the base currency to the quote currency.
=TDCurrencyConversion(base: string, quote: string, amountl: string, headers: string)
Returns the latest quote with OHLC, volume, and 52-week data at the specified interval.
=TDQuote(symbol: string, interval: string, exchange: string, country: string, volume_time_period: integer, type: string, timezone: string, prepost: string, headers: string)
Returns the latest price for the specified instrument.
=TDPrice(symbol: string, exchange: string, country: string, type: string, prepost: string, headers: string)
Returns the official EOD price for the specified instrument.
=TDEOD(symbol: string, exchange: string, country: string, type: string, prepost: string, headers: string)
Returns the technical indicator time series for the specified instrument and interval.
=TDTechnicalIndicator(name: string, parameters: string, symbol: string, interval: string, exchange: string, country: string, type: string, outputsize: integer, order: string, timezone: string, start_date: string, end_date: string, prepost: string, headers: string)

parameters might be a string consisting of customized parameters for the technical indicator as per documentation. Each parameter has to be separated by the ampersand (&) sign.

Share article

More articles

ANNOUNCEMENT
August 10, 2021

API3 Alliance Officially Announced with Twelve Data as a Founding Member

Twelve Data, a Founding Member of the API3 Alliance, To Offer First-Party Oracle Services on Web3 Leading Web API provider to provide data and services to the next generation of decentralized applications via Airnode Singapore – August 10, 2021 — Twelve Data today joined with [API3](https://api3.

GOOGLE SHEETS
August 7, 2021

Twelve Data Google Sheets Add-on Installation Guide

There are two methods to install this add-on: for yourself or for the entire domain (G Suite).

INTEGRATION
July 30, 2021

Twelve Data Launches Chainlink Node, Bringing Non-U.S. Equities, ETF, and Index Prices to DeFi

[Twelve Data](https://twelvedata.

ANNOUNCEMENT
January 11, 2021

Twelve Data to Launch Chainlink Oracle Node, Providing Origin-Signed Financial Data to Smart Contracts

We are proud to announce that [Twelve Data](https://twelvedata.

EXCEL
April 23, 2020

Twelve Data Excel Add-in Documentation

This documentation is designed to show the proper setup and the outstanding features of the Twelve Data Excel Add-in.

EXCEL
April 23, 2020

Twelve Data Excel Add-in Installation Guide for Windows

Installation is super fast and intuitive; it will take not more than 1 minute.

TUTORIAL
March 27, 2020

API for Forex Data: Accessing the $6.6 Trillion Market

This brief article will take you through how to get reliable currency data for free.