Quandl

Quandl Functions & Syntax

Overview

Quandl is a popular source for open, commercial, and alternative data, with a focus on investment professionals. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can lookup and import tablular and time-series data sets from Quandl without leaving your spreadsheet.

What you can do

With this integration, you can:

  • Import tables from Quandl directly in Excel and Google Sheets
  • Import time-series data from Quandl directly in Excel and Google Sheets
  • Search and filter tables and time-series data sets
  • Enrich your spreadsheet with data from Quandl

What you need

You need to have a Quandl account to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Quandl Series

Returns the contents of a time series on Quandl

Syntax

=FLEX("YOUR_TEAM_NAME/quandl-series", name, [properties], [mindate], [maxdate])

Sample Usage

=FLEX("YOUR_TEAM_NAME/quandl-series", "NASDAQOMX/XNDXT25")
=FLEX("YOUR_TEAM_NAME/quandl-series", "NASDAQOMX/XNDXT25", "*")
=FLEX("YOUR_TEAM_NAME/quandl-series", "NASDAQOMX/XNDXT25", "trade date, low, high")
=FLEX("YOUR_TEAM_NAME/quandl-series", "NASDAQOMX/XNDXT25", "*", "2019-09-01", "2019-09-30")
=FLEX("YOUR_TEAM_NAME/quandl-series", "NASDAQOMX/XNDXT25", "trade date, low, high", "2019-09-01", "2019-09-30")

Parameters

Property Type Description Required
name string The name of the time series to return true
properties array The properties to return (defaults to all properties). The properties are the columns/headers of the time series being requested. Use "*" to return everything. false
mindate date The minimum date for the time series to return false
maxdate date The maximum date for the time series to return false

Returns

Notes

Quandl Table

Returns the contents of a table on Quandl

Syntax

=FLEX("YOUR_TEAM_NAME/quandl-table", name, [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/quandl-table", "SHARADAR/SF3")
=FLEX("YOUR_TEAM_NAME/quandl-table", "SHARADAR/SF3", "*", "ticker=AAPL")
=FLEX("YOUR_TEAM_NAME/quandl-table", "SHARADAR/SF3", "*", "investorname=VANGUARD GROUP INC")
=FLEX("YOUR_TEAM_NAME/quandl-table", "SHARADAR/SF3", "*", "ticker=AAPL,MSFT&investorname=VANGUARD GROUP INC")

Parameters

Property Type Description Required
name string The name of the table to return true
properties array The properties to return (defaults to all properties). The properties are the columns/headers of the table being requested. Use "*" to return everything. false
filter string Filter to apply with key/values specified as a URL query string. The keys allowed are table-dependent; see the Quandl documentation for each table to find out the filter parameters that are allowed. If a filter isn't specified, all the results up to the maximum result limit will be returned. false

Returns

Notes

Results are limited to 100k rows.

Need help?

Have questions? Need help getting started? Need other Quandl templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!