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



Tables

You can download tables data for a specific date range by using the NASDAQ.TABLE formula or Formula Builder.


Using the NASDAQ.TABLE formula

Note that the structure of the NASDAQ.TABLE formula is as follows:

=NASDAQ.TABLE(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 NASDAQ.TABLE 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 NASDAQ.TABLE 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: 
=NASDAQ.TABLE("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.