TIMESERIES
Download data with the Formula Builder
 Click Get Data to access the Formula Builder dialog box.
 Database: Select the database you would like to download from or search with a database code. (For instance, the database code for Wiki EOD Stock Prices is "WIKI".)
 Data: Choose the timeseries you would like to download. (You may choose more than one timeseries dataset.)
 Columns: Select the columns you wish to include. (By default, all columns will be downloaded.)
 Filter: You can filter your data by period range and frequency; the data can also be transformed, sorted or limited by the number of observations.
 Placement: Select the cell where you would like to place the data.
 Click Insert.
Download timeseries data with the QSERIES formula
In addition to the Formula Builder, the Excel addin allows users to download timeseries data using the QSERIES formula. Users can directly type a formula into a cell to download data.
The structure of the formula is given below:
=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)
NOTE : The Timeseries code is the only required input for the formula. The other parts of the formula are optional inputs. Also, a single query can contain multiple filters.
DESCRIPTION  

Timeseries code (required) 
The timeseries codes can be found on our website. You can specify the column by the name or number. If a column is not specified, all columns from the timeseries will be retrieved.
To specify multiple columns in a timeseries, use curly brackets “{}” and indicate the columns you wish to query in quotation marks.

Date range (optional) 

Frequency (optional) 

Sort order (optional) 

Transformation (optional) 

Limit (optional) 

Headers (optional) 

Dates (optional) 

Transpose (optional) 

Reference Cells in the Formula
Users are encouraged to directly reference cells that contain the desired specification when using the formula. The following two examples are meant to get you familiar with referencing cells in the Formula.
Example 1: Query multiple timeseries
This example queries and downloads the closing prices for the three tickers (AAPL
, FB
, TCB
). To do this, enter the Timeseries codes for the three tickers in the worksheet cells (e.g., B1
, C1
, D1
). Then enter the QSERIES formula in cell A2
and reference the tickers by clicking and dragging your mouse over them.
Example 2: Query multiple timeseries within a period range
This example queries and downloads the closing prices for the three tickers (AAPL
, FB
, TCB
) in the month of September. To do this, enter the Timeseries codes for the three tickers in the worksheet (e.g., D1
, E1
, F1
cells). Enter the start and end dates in the worksheet (e.g., B1
, B2
cells). Then use the QSERIES formula in cell C2
and reference the tickers and start/end dates.
Useful Links
For other useful tips on Nasdaq Data Link's Excel addin, please visit our YouTube channel and Help Center.
Updated over 5 years ago