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
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!