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

All functions begin with the TD{function_name}. 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).

Add-on menu

Add-ons ➤ Twelve Data ➤ Insert
The 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 simultaneously.

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

Reference data

Core data

TDStockList

Returns the list of equities satisfying the criteria.
=TDStockList(symbol: string, exchange: string, country: string, type: string, headers: string)

TDForexList

Returns the list of physical pairs satisfying the criteria.
=TDForexList(symbol: string, currency_base: string, currency_quote: string, headers: string)

TDCryptoList

Returns the list of digital pairs satisfying the criteria.
=TDCryptoList(symbol: string, exchange: string, currency_base: string, currency_quote: string, headers: string)

TDETFList

Returns the list of ETFs satisfying the criteria.
=TDETFList(symbol: string, headers: string)

TDIndicesList

Returns the list of indices satisfying the criteria.
=TDIndicesList(symbol: string, country: string, headers: string)

TDExchanges

Returns the list of exchanges satisfying the criteria.
=TDExchanges(type: string, name: string, code: string, country: string, headers: string)

TDCryptoExchanges

Returns the list of all cryptocurrency exchanges available.
=TDCryptoExchanges(symbol: string, country: string, headers: string)

TDSymbolSearch

Returns the list of instruments primarily satisfying the search criteria.
=TDSymbolSearch(symbol: string, headers: string)

TDTimeSeries

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)

TDCurrencyTimeSeries

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)

TDExchangeRate

Returns the exchange rate for the base currency against the quote currency.
=TDExchangeRate(base: string, quote: string, headers: string)

TDCurrencyConversion

Returns the exchange rate + the amount converted from the base currency to the quote currency.
=TDCurrencyConversion(base: string, quote: string, amountl: string, headers: string)

TDQuote

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)

TDPrice

Returns the latest price for the specified instrument.
=TDPrice(symbol: string, exchange: string, country: string, type: string, prepost: string, headers: string)

TDEOD

Returns the official EOD price for the specified instrument.
=TDEOD(symbol: string, exchange: string, country: string, type: string, prepost: string, headers: string)

TDTechnicalIndicator

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.

Did this answer your question?