- Click Get Data to access the Quandl 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 Mergent Global Fundamentals is "MF1".)
- Data: Choose the table you would like to download.
- Columns: Select the columns you wish to include (by default, all columns will be downloaded).
- Filter: The dialog box will provide the relevant filters dynamically.
- Placement: Select the cell where you would like to place the data.
- Click Insert.
If a valid API key is not used, some tables will default to returning sample data. If you are not receiving all the expected data, please double check your API key.
In addition to the Quandl Formula Builder, the Quandl Excel add-in allows users to download tables data with the QTABLE formula. Users can directly type a formula into a cell to download data.
The structure of the formula is given below. Note that you can have multiple filters as part of a single query.
=QTABLE(Datatable code, columns, filter name, filter value, filter name, filter value)
Datatable code (required)
Filter columns (optional)
Filter rows (optional)
By specifying one or more columns to act as the filter name, you can download your desired rows. If the value in a given column matches the specified filter value, the row containing that value is returned.
Users are encouraged to directly reference cells that contain the desired specification when using the Quandl formula. The following two examples are meant to get you familiar with referencing cells in the Quandl Formula.
This example queries and downloads four columns from the ZACKS/FC tables. Enter the Datatable Code and column names you wish to query in the worksheet (e.g.,
A4 cells). Use the QTABLE formula and reference these cells (e.g.,
This example queries and downloads four columns, filtering for only the
AAPL value in the ticker column and for the
Q value in the
per type column. To do this, enter the Datatable Code and column names you wish to query in the worksheet (e.g.,
A4 cells). Then enter the filter names and filter values you wish to filter by. Use the QTABLE formula and reference these cells.
Updated 3 years ago