TIME-SERIES
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 time-series you would like to download. (You may choose more than one time-series 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 time-series data with the QSERIES formula
In addition to the Formula Builder, the Excel add-in allows users to download time-series 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 Time-series 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 | |
---|---|
Time-series code (required) |
The time-series 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 time-series will be retrieved.
To specify multiple columns in a time-series, 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 time-series


This example queries and downloads the closing prices for the three tickers (AAPL
, FB
, TCB
). To do this, enter the Time-series 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 time-series 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 Time-series 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 add-in, please visit our YouTube channel and Help Center.
Updated over 5 years ago