Can I specify whether I want ascending or descending date order when downloading historical data using the Excel Add-In?
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 data
- REST API for time-series
- REST API for tables
You can learn more about these APIs and data formats here.
The Excel Add- In may only be used with data delivered through the REST API for time-series or the REST API for tables.
When downloading data that is in time-series format, it is possible to specify ascending or descending date order by using the QSERIES formula or the Nasdaq Data Link Formula Builder. See below. By default, the time-series data is downloaded in descending date order with the most recent dates at the top.
However, when downloading data that is in tables format, it is not possible to specify ascending or descending date order. For tables, we recommend downloading the data and filtering by the date column manually to change the order.
Using the QSERIES formula
Note that the structure of the QSERIES formula is as follows, with sortOrder as the fourth argument:
=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)<br>
To return data in ascending order, put "asc" in the sortOrder argument, like this:
=QSERIES("XNAS/ACIW",,,"asc")<br>
The above formula will return data from the XNAS/ACIW time-series in ascending order.
The sortOrder argument can be "desc" for descending or "asc" for ascending.
Using the Nasdaq Data Link Formula Builder
To return data in ascending order 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, like this:
- Click Next and follow the prompts. When you reach the Filters stage and can filter by Sort order, select Ascending from the drop down, like this:
- Enter any other desired filters and click Next. Follow the prompts to download the data.
