Quandl
+
Google Sheets
+
Microsoft Excel

Quandl in your spreadsheet

Import live, refreshable data from your Quandl account in Microsoft Excel and Google Sheets.

Import Quandl data in your spreadsheet

Quandl is a premier source for open, commercial, and alternative data, with a particular focus on investment professionals. This Quandl spreadsheet integration for Google Sheets and Microsoft Excel enables you to import table and time-series datasets from Quandl. This add-on will enable you to integrate on-demand, refreshable stock market and portfolio data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Extract financial time-series data directly in Excel and Google Sheets, filtering by both columns and date.
  • Import tables, such as the Sharadar Fundamentals, and filter based on what is relevant and available for that given data set (e.g., columns, date, ticker, investor, etc.).

Click here to learn more about the specific syntax for each of the Quandl spreadsheet functions.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Quandl function collection with Microsoft Excel or Google Sheets. Please note that you'll need a Quandl account to use this integration.

Need Help?

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

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])

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

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")

Notes

Quandl Table

Returns the contents of a table on Quandl

Syntax

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

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

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")

Notes

Results are limited to 100k rows.

Use Quandl in your spreadsheet now!