How do I download a specific date range or just a few rows of historical data using the Excel Add-In?

To download data using the Excel Add-In, you first have to download and install the Excel Add-In package as per the instructions here. 

Note that each data feed on Nasdaq Data Link is delivered through one of the following Nasdaq Data Link APIs:

  • Streaming API for real-time data
  • REST API for real-time or delayed
  • REST API for time-series
  • REST API for tables

You can learn more about these APIs and Data formats here.

The Excel Add-in only works with data that is delivered through the REST API for time-series or the REST API for tables.

Time-series
You can download time-series data for a specific date range by using the QSERIES formula or the Nasdaq Data Link Formula Builder. 

Using the QSERIES formula
Note that the structure of the QSERIES formula is as follows, with  dateRange as the second argument and limit as the sixth argument: 

=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)

To download a specific date range, you can use a QSERIES formula like this where  dateRange is set to 2016-01-01 to 2016-01-31:

=QSERIES("XNAS/ACIW",{"2016-01-01","2016-01-31"})

The above formula will therefore return data from 2016-01-01 to 2016-01-31 from the XNAS/ACIW time-series.

To download the latest row only, you can also use a QSERIES formula like this where  limit is set to 1: 

=QSERIES("XNAS/ACIW",,,,,1)

The above formula will return the latest 1 row of the XNAS/ACIW time-series i.e. it will download the latest observation. You can replace 1 with any other number of rows you want.

Please note that it is only possible to get data for a specific date range for an individual time-series. The above examples return data for the XNAS/ACIW time-series which is part of the NASDAQ Stock Market Prices data feed. If you wanted to get data for a specific date range for the entire NASDAQ Stock Market Prices data feed (i.e. all tickers), this is not currently possible with our Excel Add-In. In this case, we would recommend using the API to bulk download the entire NASDAQ Stock Market Prices data feed and then filtering by date locally. Instructions for how to do a bulk download are explained in our API documentation under the section called Get an entire time-series dataset.

Using the Nasdaq Data Link Formula Builder
To download time-series data for a specific date range by using the Nasdaq Data Link Formula Builder, please follow these steps:

  • Open Excel
  • Go to the Nasdaq Data Link tab and click Get Data

  • Search for the time-series data feed you want or enter the database code for the data feed you want. For example, enter XNAS for the  NASDAQ Stock Market Prices data feed, like this: 

  • Click Next and follow the prompts. When you reach the Filters stage and can filter by Date, select Period Range from the drop down and select the date range you want, like this:  

  • Enter any other desired filters and click Next. Follow the prompts download the data. 




Tables
You can download tables data for a specific date range by using the QTABLE formula or the Nasdaq Data Link Formula Builder. 

Using the QTABLE formula
Note that the structure of the QTABLE formula is as follows:

=QTABLE(Datatable code, columns, filter name, filter value, filter name, filter value)

To download a specific date range from a table, you first have to identify which columns you can use as  filters for that particular table and if any of those filters are date-related. This is because each table on Nasdaq Data Link uses different filters. You can identify filters for a particular table by reading the Documentation for that table or by making a metadata API call for that table.

Once you've identified which date-related columns you can use as filters, you can download a specific date range by using the .gte and .lte operators with those filters in your QTABLE formula. You can learn more about operators here. 

For example:

  • The Mergent Global Fundamentals (MF1) data feed is in tables format. You can see the product page for this data feed here. As you'll see, there is one data table called Mergent Global Fundamentals with Quandl code MER/F1. 
  • To identify which columns can be used as filters for the Mergent Global Fundamentals table, go to the product page, click on Documentation at the top. Then, click Column Definitions at the left. That will lead you to this page. From the chart, you'll see that the "reportdate" column is a date filter. 
  • You can also use a metadata API call like this to identify which columns may be used as filters: 
    • https://www.data.nasdaq.com/api/v3/datatables/MER/F1/metadata.json?api_key=YOURAPIKEY<br>
  • You can then use a QTABLE formula like this which will return data for a date range ie. where reportdate is greater than or equal to (.gte) 2010-12-31 and less than or equal to (.lte) 2015-12-31: 
    • =QTABLE("MER/F1",,"reportdate.gte","2010-12-31","reportdate.lte","2015-12-31")<br>

Using the Nasdaq Data Link Formula Builder
To download tables data for a specific date range by using the Nasdaq Data Link Formula Builder, please follow these steps:

  • Open Excel
  • Go to the Nasdaq Data Link tab and click Get Data

  • Search for the tables data feed you want or enter the database code for the data feed you want. For example, enter MF1 for the Mergent Global Fundamentals data feed, like this:

  • Click Next and follow the prompts. When you reach the Filters stage and can filter by reportdate, select Period Range from the drop down and select the date range you want, like this:

  • Enter any other desired filters and click Next. Follow the prompts to download the data.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.